Wednesday, May 31, 2023

Installing 19c setup on Linux with latest patch




                   Installing19c setup and patching with 19.17 RU minimum command line.


Step 1: Installing RPM 


From root user 

#yum -y install oracle-database-preinstall-19c Step 2: Creating a folder for ORACLE HOME


Step 2: Creating a folder for ORACLE HOME


mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 export

ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 export ORACLE_BASE=/u01/app/oracle 

edit the bash 


# User specific environment and startup programs export ORACLE_SID=TEST export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1 export AGENT_HOME=$ORACLE_BASE/agent/agent_inst export PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin:$AGENT_HOME/bin


Step 3: Download the software/patch/OPatch with wget command. 


3.1 download wget script from edelivery 

3.2 find the latest patch on oracle metalink. RU 19.17 

3.3 Downloading OPatch 12.2.0.1.33


Step 4 : Installation for 19.3.0 software 

Response file = db_install.rsp 

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_ response_schema_v19.0.0 oracle.install.option=INSTALL_DB_SWONLY 

UNIX_GROUP_NAME=oinstall 

INVENTORY_LOCATION=/u01/app/oraInventory 

ORACLE_BASE=/u01/app/oracle 

oracle.install.db.InstallEdition=EE 

oracle.install.db.OSDBA_GROUP=dba 

oracle.install.db.OSOPER_GROUP=dba 

oracle.install.db.OSBACKUPDBA_GROUP=dba 

oracle.install.db.OSDGDBA_GROUP=dba 

oracle.install.db.OSKMDBA_GROUP=dba 

oracle.install.db.OSRACDBA_GROUP=dba 

oracle.install.db.rootconfig.executeRootScript=false

----------check for prechecks------- 

/u01/oracle/product/19.0.0/dbhome_1/runInstaller -silent - executePrereqs -responseFile /u01/oracle/software/db_install.rsp 

Check for any error and resolve it. 

---command for installation---------


/u01/oracle/product/19.0.0/dbhome_1/runInstaller -silent -applyRU 

/u01/oracle/software/34419443 -responseFile /u01/oracle/software/db_install.rsp


[oracle@prashant1 software]$ /u01/oracle/product/19.0.0/dbhome_1/runInstaller -silent -applyRU /u01/backup/software/34419443 -responseFile /u01/backup/software/db_install.rsp 

Preparing the home to patch... 

Applying the patch /u01/backup/software/34419443... 

Successfully applied the patch. 

The log can be found at: /tmp/InstallActions2022-10-19_06-22-22PM/installerPatchActions_2022- 10-19_06-22-22PM.log 

Launching Oracle Database Setup Wizard...


[WARNING] [INS-32047] The location (/u01/app/oraInventory) specified for the central inventory is not empty. 

 ACTION: It is recommended to provide an empty location for the inventory. 

The response file for this session can be found at: /u01/oracle/product/19.0.0/dbhome_1/install/response/db_2022-10-19_06-22-22PM.rsp 


You can find the log of this install session at: 

/tmp/InstallActions2022-10-19_06-22-22PM/installActions2022-10-19_06-22-22PM.log


As a root user, execute the following script(s): 

 1. /u01/app/oraInventory/orainstRoot.sh 

 2. /u01/oracle/product/19.0.0/dbhome_1/root.sh 

Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 

[prashant1] 

Execute /u01/oracle/product/19.0.0/dbhome_1/root.sh on the following nodes: 

[prashant1] 


Run below scripts from root


1. /u01/app/oraInventory/orainstRoot.sh 

 2. /u01/oracle/product/19.0.0/dbhome_1/root.sh


Create DB 


dbca -silent -createDatabase -responseFile NO_VALUE -templateName General_Purpose.dbc -sid TEST -gdbname TEST -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -sysPassword sys - systemPassword sys -createAsContainerDatabase FALSE -databaseType MULTIPURPOSE - automaticMemoryManagement FALSE -totalMemory 2048 -datafileDestination /u02/oradata - redoLogFileSize 50 -emConfiguration NONE -sampleSchema FALSE -recoveryAreaDestination /u03/fra -enableArchive TRUE -ignorePreReqs


********************************End of Document*************************************



No comments:

Post a Comment

PL/SQL PACKAGE SYS.DBMS_BACKUP_RESTORE VERSION IS NOT CURRENTPL/SQL PACKAGE SYS.DBMS_RCVMAN VERSION 19.03.00.00 IS TOO OLD

  Recently, I undertook the task of upgrading an Oracle database from version 19.03 to 19.22. As the process progressed, I began to encounte...