Wednesday, January 5, 2022

How to Create / Install repo on Solaris 11.4 ?

 Create / Install repo on Solaris 11.4


root@solaris11:/package_sol#

root@solaris11:/package_sol# ./install-repo.ksh -d repo/

Using sol-11_4-repo download.

Uncompressing sol-11_4-repo_1of5.zip...done.

Uncompressing sol-11_4-repo_2of5.zip...

done.

Uncompressing sol-11_4-repo_3of5.zip...done.

Uncompressing sol-11_4-repo_4of5.zip...

done.

Uncompressing sol-11_4-repo_5of5.zip...done.

Repository can be found in repo/.

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol# pkg set-publisher -G '*' -M '*' -g /package_sol/repo solaris

root@solaris11:/package_sol#

root@solaris11:/package_sol#



root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol# pkg info -r solaris-desktop

          Name: group/system/solaris-desktop

       Summary: Oracle Solaris Desktop

   Description: Provides an Oracle Solaris desktop environment

      Category: Meta Packages/Group Packages

         State: Not installed

     Publisher: solaris

       Version: 11.4

        Branch: 11.4.0.0.1.15.0

Packaging Date: Fri Aug 17 00:35:39 2018

          Size: 2.52 kB

          FMRI: pkg://solaris/group/system/solaris-desktop@11.4-11.4.0.0.1.15.0:20180817T003539Z

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol# pkg install solaris-desktop

           Packages to install: 357

           Mediators to change:   1

            Services to change:  17

       Create boot environment:  No

Create backup boot environment:  No


DOWNLOAD                                PKGS         FILES    XFER (MB)   SPEED

Completed                            357/357   61930/61930  958.4/958.4      --


PHASE                                          ITEMS

Installing new actions                   76265/76265

Updating package state database                 Done

Updating package cache                           0/0

Updating image state                            Done

Creating fast lookup database                   Done

Updating package cache                           1/1

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#




root@solaris11:/package_sol# shutdown -i6 -g0 -y



About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Tuesday, January 4, 2022

AWS Certified Database Specialty

 


About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Monday, January 3, 2022

How to empty swap if there is free RAM? : Linux Red-hat OS

Using root user 

 

 free -m

              total        used        free      shared  buff/cache   available

Mem:          15646        3908        1360        3237       10376        8192

Swap:           699         285         414



swapoff -a


swapon -a



 free -g
              total        used        free      shared  buff/cache   available
Mem:             15           4           1           3          10           7
Swap:             0           0           0

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Detach Home from Oracle Inventory - 19c oracle database

 

Go to below location :

/u01/app/oracle/product/19.0.0/dbhome/oui/bin


[oracle@ip- bin]$

[oracle@ip- bin]$

[oracle@ip- bin]$ ./runInstaller -silent -detachhome -invPtrLoc /etc/oraInst.loc oracle_home="/u01/app/oracle/product/19.0.0/dbhome" ORACLE_HOME_NAME="OraDB19Home1"

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 699 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

You can find the log of this install session at:

 /u01/app/oraInventory/logs/DetachHome2022-01-03_05-40-07PM.log

'DetachHome' was successful.

[oracle@ip- bin]$

[oracle@ip- bin]$

[oracle@ip- bin]$

[oracle@ip- bin]$

[oracle@ip- bin]$

[oracle@ip- bin]$ pwd

/u01/app/oracle/product/19.0.0/dbhome/oui/bin

[oracle@ip- bin]$

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Create Resource Manager , Resource Group / Consumer groups in Oracle Database to limit CPU resources

  Step to create Resource Manager  consumer groups in Oracle Database  1. First confirm the exact PROGRAM values     SELECT program, ...