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.
- Stop the databse
- Change the ownership of all files.
– include files in oradata, admin, and dbs folders
- Edit the oratab file (to point the db to the new home)
- Change to the new user
- Set the ORACLE_SID
- sqlplus “/ as sysdba”
- 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;