# Log in as 'oracle', the owner of the 11g Database software.
su - oracle
      
# Set up your environment to reference the 11g installation, with the
# ORACLE_SID referring to the newly-upgraded database.
     
export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
# Put ORACLE_HOME/bin first, in case 10g bin is already in the path.
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=orcl 

# Change to the 11g ORACLE_HOME directory:

cd $ORACLE_HOME/rdbms/admin

# Start up the database.
echo "STARTUP" | sqlplus / as sysdba

# Invoke the script utlu111s.sql, saving the output:

sqlplus / as sysdba @utlu111s.sql | tee upgrade_check.out

# The output of the script will indicate the status of the upgraded components.

# If any component was not upgraded to the current release level of
# 11.x.x.x, then examine the log files to see what might have gone wrong
# during the upgrade. 
