Shut down all the Sentinel applications.

Install the Oracle 11g software on a new ORACLE_HOME and ORACLE_BASE directory. For more information, refer to the Oracle Documentation Web site.

Verify the database for upgrading to Oracle 11g by using the pre-upgrade information tool (utlu111i.sql).

The SQL script is available at the Oracle 11g location, oracle_home/rdbms/admin/utlu111i.sql. Run the script from the source database (Oracle 10g).

Connect to the database sysdba and run the following script:

SQL>spool upgrade_info.log
SQL>@/11g_oracle_home/rdbms/admin/utlu111i.sql

Open the upgrade.info log file and check for any errors. If there are any errors, download and install the required patch files from the Oracle Web site.

Specify the following parameters in the initialization parameter file:

diagnostic_dest= $ORACLE_BASE/diag
memory_max_target=1GB
memory_target= 800m
compatible= 11.1.0

Shut down the Oracle 10g database:

SQL>shutdown immediate

Set the ORACLE_HOME and ORACLE_BASE environment variables to the Oracle 11g software.

Use the new parameter values to Connect to Oracle 11g.

Start the database in the upgrade mode:

SQL> startup upgrade

Use the catupgrd.sql script to upgrade the database:

SQL> spool upgrade.log
SQL> @/rdbms/admin/catupgrd.sql

Open the upgrade.log file and check for errors. If there are any errors, download and install the required patch files from the Oracle Web site.

Run the utlu111s.sql post upgrade script:

SQL>startup

SQL>@/rdbms/admin/utlrp.sql

Check the status of database components and ensure that all components are using the Oracle 11g version.

SQL>select comp_name,version,status from dba_registry

Copy the tnsnames.ora, listener.ora, sqlnet.ora files from the Oracle 10g source ORACLE_HOME to the Oracle 11g ORACLE_HOME.

Shut down the database and start the database, database listener, Sentinel, and all other services.