Upgrading 10gR2 Database Instance to 11gR2 Database Instance STEP 1: Install The Software: First download and install oracle 11g R2. Execute runInstaller to install “SOFTWARE ONLY” option. NOTE: DO NOT SHUTDOWN DATABASE BEFORE RUNNING DBUA. STEP 2: Run Pre-Upgrade Information tool The software was installed under “/ultimus/oracle/product/11.2.0/db_1″ location. Once the software is installed, then go to location $ORACLE_HOME/rdbms/admin and copy utlu112i.sql script to /tmp directory. Now login to 10g database “/ as sysdba” and startup the 10g database, then: SQL > spool /tmp/upgrade.spl SQL > @/tmp/utlu112i.sql SQL > spool off The output should look something like this: Oracle Database 11.2 Pre-Upgrade Information Tool . ********************************************************************** Database: ********************************************************************** --> name: ...