Database Oracle

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;