Disclaimer

Tuesday, 3 November 2020

Shell script for Database upgrade

 $ cat dbupgrade_orcl.sh

#!/bin/ksh
export ORACLE_BASE=/applications/oracle
export ORACLE_HOME=/applications/oracle/18.4.0.1
export PATH=$PATH:/$ORACLE_HOME/bin
export ORACLE_SID=ORCL
export LIB_PATH=$ORACLE_HOME/lib

cd /applications/oracle/18.4.0.1/bin
./dbupgrade -d $ORACLE_HOME/rdbms/admin -n 2 -l >> /home/oracle/ORCL_upgrade_30_Oct/dbupgrade_log/orcl_upgrade.log

No comments:

Post a Comment

How to Install Oracle Enterprise Manager 24-AI - OEM

Table of Contents Why OEM 24ai? Step 1: Prepare Your Oracle 19c Database Step 2: Verify and Tune Database Parameters Step 3: Patch the Datab...