Step 1. Set $ORACLE_HOSTNAME to the old hostname
export ORACLE_HOSTNAME=old_name
Step 2. De-configure the old DB Console by running the following command:
$ORACLE_HOME/bin/emca -deconfig dbcontrol db
Step 3. $ORACLE_HOSTNAME to the new hostname:
export ORACLE_HOSTNAME=new_name
Step 4. Configure the new DB Console
$ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate
Step 1: Open with Upgrade Option
SQL> startup upgrade;
Step 2: upgrade database – it means run script $ORACLE_HOME/rdbms/admin/catupgrd.sql
SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/catupgrd.sql;
Step 3: Shutdown database and Startup
SQL> shutdown immediate;
SQL> startup;
Step 4: Run script $ORACLE_HOME/rdbms/admin/utlrp.sql – for recompile all invalid PL/SQL packages
SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/utlrp.sql
CREATE CONTROLFILE .................................
.................................................
CHARACTER SET AL32UTF8;
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode
SQL> alter system set cluster_database=FALSE scope=spfile sid='*'; SQL> shutdown immediate; SQL>startup nomount;
Now, re-run script for creating controlfile
CREATE CONTROLFILE ................................. ................................................. CHARACTER SET AL32UTF8; Control file created.
Then, change parameter with its old value and restart database.
SQL>alter system set cluster_database=TRUE scope=spfile sid='*';