Moving an Oracle database to a newer Oracle home

Moving a database to a new oracle home, owned by a different user and running a newer version.

NOTE : This is how is worked in my environment. It might not work the same in your environment. This is meant as a guide only.

  1. Stop the databse
  2. Change the ownership of all files.
    – include files in oradata, admin, and dbs folders
  3. Edit the oratab file (to point the db to the new home)
  4. Change to the new user
  5. Set the ORACLE_SID
  6. sqlplus “/ as sysdba”
  7. Upgrade the database
SQL> STARTUP NOMOUNT
SQL> SHOW PATAMETER SGA
SQL> SHOW PARAMETER SHARED_POOL_SIZE
SQL> SHOW PARAMETER JAVA_POOL_SIZE
If necessary, set the value of the SHARED_POOL_SIZE initialization parameter to at least 150 MB:
SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;
If necessary, set the value of the JAVA_POOL_SIZE initialization parameter to at least 150 MB:
SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;
SQL> SHUTDOWN

SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sqlSQL> SHUTDOWN
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql
SQL> SHUTDOWN

SQL> STARTUP
SQL> select instance_name, status, version from v$instance;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s