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

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...