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

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...