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 recovery PDB when PDB database is dropped in Oracle

  How to recovery PDB when PDB database is dropped :) [oracle@rac01 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 21.0.0.0.0 - Product...