19c Manual Installation

 

mkdir -pv /dbbkup01-mussaib/mussaib_18c_rman_backup

mkdir -pv /dbbkup01-mussaib/upgrade

mkdir -pv /dbbkup01-mussaib/temp

mkdir -pv /dboracle-mussaib/19.0.0.0

mkdir -pv /dboracle-mussaib/oraInventory19.0.0.0

chown -R prhtorac:dba /dboracle-mussaib/mussaib_18c_rman_backup

chmod -R 777 /dboracle-mussaib/mussaib_18c_rman_backup

chown -R prhtorac:dba /dbbkup01-mussaib/upgrade

chmod -R 777 /dbbkup01-mussaib/upgrade

chown -R prhtorac:dba /dbbkup01-mussaib/temp

chmod -R 777 /dbbkup01-mussaib/temp

chown -R prhtorac:dba /dboracle-mussaib/19.0.0.0

chmod -R 777 /dboracle-mussaib/19.0.0.0

chown -R prhtorac:dba /dboracle-mussaib/oraInventory19.0.0.0

chmod -R 777 /dboracle-mussaib/oraInventory19.0.0.0

------------ Required dimussaibry verification and creation ------------------

mussaib

su - prhtorac

mkdir -pv /dboracle-mussaib/19.0.0.0

mkdir -pv /dboracle-mussaib/oraInventory19.0.0.0

mkdir -pv /dbbkup01-mussaib/upgrade

mkdir -pv /dbbkup01-mussaib/temp

mkdir -pv /dbbkup01-mussaib/mussaib_12c_rman_backup

ls -ld /dboracle-mussaib/19.0.0.0

ls -ld /dboracle-mussaib/oraInventory19.0.0.0

ls -ld /dbbkup01-mussaib/upgrade

ls -ld /dbbkup01-mussaib/temp

ls -ld /dbbkup01-mussaib/mussaib_12c_rman_backup

mkdir -pv /dboracle-mussaib/19.0.0.0

mkdir -pv /dboracle-mussaib/oraInventory19.0.0.0

mkdir -pv /dbbkup01-mussaib/mussaib_12c_rman_backup

mkdir -pv /dbbkup01-mussaib/upgrade

mkdir -pv /dbbkup01-mussaib/temp

---------------  Unzip/Untar the Oracle Software  --------------------------

nohup unzip -o /dbbkup01-mussaib/db_home_2022-01-05_07-39-06PM.zip -d /dboracle-mussaib/19.0.0.0/  &

 unzip -o db_home_2021-08-31_11-40-37PM.zip -d /dboracle-mussaib/19.0.0.0/

vi /dboracle-mussaib/19.0.0.0/install/response/db_install.rsp

                    

INVENTORY_LOCATION=/dboracle-mussaib/oraInventory19.0.0.0

ORACLE_HOME=/dboracle-mussaib/19.0.0.0

ORACLE_BASE=/dboracle-mussaib

---------------- Create oraInst.loc file   --------------------------

cat 1>/dboracle-mussaib/19.0.0.0/oraInst.loc <<EOF

inventory_loc=/dboracle-mussaib/oraInventory19.0.0.0

inst_group=dba

EOF

############################################################################################################################

export ORA_INVENTORY=/dboracle-mussaib/oraInventory19.0.0.0

export ORACLE_UNQNAME=

export ORACLE_BASE=/dboracle-mussaib

export ORACLE_HOME=/dboracle-mussaib/19.0.0.0

export ORACLE_SID=

export TNS_ADMIN=/dboracle-mussaib/19.0.0.0/network/admin

export LD_LIBRARY_PATH=/dboracle-mussaib/19.0.0.0/lib

export PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/dboracle-mussaib/19.0.0.0/bin:/dboracle-mussaib/19.0.0.0/OPatch:/bin

export TMP=/dbbkup01-mussaib/temp

export TMPDIR=/dbbkup01-mussaib/temp

env | grep ORA

env | grep TMP

cd /dboracle-mussaib/19.0.0.0/

nohup ./runInstaller  -silent -responseFile /dboracle-mussaib/19.0.0.0/install/response/db_install.rsp &

###############################################################################

export ORA_INVENTORY=/dboracle-mussaib/oraInventory19.0.0.0

export ORACLE_UNQNAME=

export ORACLE_BASE=/dboracle-mussaib

export ORACLE_HOME=/dboracle-mussaib/19.0.0.0

export ORACLE_SID=

export TNS_ADMIN=/dboracle-mussaib/19.0.0.0/network/admin

export LD_LIBRARY_PATH=/dboracle-mussaib/19.0.0.0/lib

export PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/dboracle-mussaib/19.0.0.0/bin:/dboracle-mussaib/19.0.0.0/OPatch:/bin

export TMP=/dbbkup01-mussaib/temp

export TMPDIR=/dbbkup01-mussaib/temp

cd $ORACLE_HOME

nohup /dboracle-mussaib/19.0.0.0/runInstaller -ignorePrereq -waitforcompletion -silent \

-responseFile ${ORACLE_HOME}/install/response/db_install.rsp \

oracle.install.option=INSTALL_DB_SWONLY \

UNIX_GROUP_NAME=dba \

INVENTORY_LOCATION=${ORA_INVENTORY} \

SELECTED_LANGUAGES=en,en_GB \

ORACLE_HOME=${ORACLE_HOME} \

ORACLE_BASE=${ORACLE_BASE} \

oracle.install.db.InstallEdition=EE \

oracle.install.db.OSDBA_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 \

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \

DECLINE_SECURITY_UPDATES=true &

----------- Execute root scripts   --------------------------

# /dboracle-mussaib/oraInventory19.0.0.0/orainstRoot.sh

# /dboracle-mussaib/19.0.0.0/root.sh

Check the log file and collect the evidence of successful installation 

  -------------------------- JDK Update   --------------------------

tar -zxvf /dboracle-otmxcol3/jdk-8u301-linux-x64.tar.gz -C /dboracle-mussaib/19.0.0.0/;

cd /dboracle-mussaib/19.0.0.0

mv jdk jdk_bkp1

 mv jdk1.8.0_301 jdk

  --------------------------Opatch Update ( This step required if we are using the base binary)   --------------------------

mv /dboracle-mussaib/19.0.0.0/OPatch /dboracle-mussaib/19.0.0.0/OPatch_BKP

unzip -o /dbbkup01-mussaib/software_20210706/p6880880_190000_Linux-x86-64.zip -d /dboracle-mussaib/19.0.0.0/

--------------------------jre update for Opatch   --------------------------

mv /dboracle-mussaib/19.0.0.0/OPatch/jre /dboracle-mussaib/19.0.0.0/OPatch/jre_bkp

cp -R /dboracle-mussaib/19.0.0.0/jdk/jre /dboracle-mussaib/19.0.0.0/OPatch

-------------------------- 19.11 Patch Apply:   --------------------------

cd /dbbkup01-mussaib/software_20210706/

unzip p32218454_190000_Linux-x86-64.zip

export ORA_INVENTORY=/dboracle-mussaib/oraInventory19.0.0.0

export ORACLE_UNQNAME=

export ORACLE_BASE=/dboracle-mussaib

export ORACLE_HOME=/dboracle-mussaib/19.0.0.0

export ORACLE_SID=

export TNS_ADMIN=/dboracle-mussaib/19.0.0.0/network/admin

export LD_LIBRARY_PATH=/dboracle-mussaib/19.0.0.0/lib

export PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/dboracle-mussaib/19.0.0.0/bin:/dboracle-mussaib/19.0.0.0/OPatch:/bin

export TMP=/dbbkup01-mussaib/temp

export TMPDIR=/dbbkup01-mussaib/temp

env | grep ORA

env | grep TMP

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /dbbkup01-mussaib/software_20210706/32218454

cd /dbbkup01-mussaib/software_20210706/32218454

$ORACLE_HOME/OPatch/opatch apply

exit

-------------------------- Evidences:   --------------------------

su - prhtorac

export ORA_INVENTORY=/dboracle-mussaib/oraInventory19.0.0.0

export ORACLE_UNQNAME=

export ORACLE_BASE=/dboracle-mussaib

export ORACLE_HOME=/dboracle-mussaib/19.0.0.0

export ORACLE_SID=

export TNS_ADMIN=/dboracle-mussaib/19.0.0.0/network/admin

export LD_LIBRARY_PATH=/dboracle-mussaib/19.0.0.0/lib

export PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/dboracle-mussaib/19.0.0.0/bin:/dboracle-mussaib/19.0.0.0/OPatch:/bin

export TMP=/dbbkup01-mussaib/temp

export TMPDIR=/dbbkup01-mussaib/temp

date

hostname

$ORACLE_HOME/jdk/bin/java -version

$ORACLE_HOME/OPatch/jre/bin/java -version

which opatch

opatch version

opatch lspatches

which sqlplus 

sqlplus /nolog

which roohctl

prhtorac$ roohctl -enable -force;

  -------------------------- autoupgrade analyze   --------------------------

  cd /dbdata01-mussaib

cp autoupgrade.jar /dbbkup01-mussaib/upgrade

  

cd /dbbkup01-mussaib/software_20210727/upgrade

cp /dbbkup01-mussaib/software_20210727/autoupgrade.jar .

vi mussaib.cfg

global.autoupg_log_dir=/dbbkup01-mussaib/upgrade/logs

sbmx1.dbname= mussaib

sbmx1.sid=mussaib

sbmx1.start_time=NOW

sbmx1.source_home=/dboracle-mussaib/12.2.0.1

sbmx1.target_home=/dboracle-mussaib/19.0.0.0

sbmx1.log_dir=/dbbkup01-mussaib/upgrade/logs

sbmx1.upgrade_node=localhost

sbmx1.target_version=19

sbmx1.restoration=no

sbmx1.timezone_upg=yes

sbmx1.remove_underscore_parameters=

/dboracle-mussaib/12.1.0.1/jdk/jre/bin/java -jar autoupgrade.jar -config mussaib.cfg -mode analyze

got java error

tar -zxvf /dboracle-otmxcol3/jdk-8u301-linux-x64.tar.gz -C /dboracle-mussaib/12.2.0.1/;

cd /dboracle-mussaib/12.2.0.1

mv jdk jdk_bkp1

 mv jdk1.8.0_301 jdk