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

In Oracle How to shrink Securefile LOB tables

As per Oracle support, if the table uses securefile LOB the traditional shrink method ALTER TABLE MODIFY LOB (XMLRECORD) (SHRINK SPACE) will...