Rename an Oracle Database

Below Mentioned Steps will help you to rename an oracle Database

• Start by making a full database backup of your database (in case you need to restore if this procedure is not working).
  
• Execute this command from sqlplus while connected to 'SYS AS SYSDBA':

ALTER DATABASE BACKUP CONTROLFILE TO TRACE RESETLOGS;

• Locate the latest dump file in your USER_DUMP_DEST directory (show parameter USER_DUMP_DEST) - rename it to something like dbrename.sql.
  
• Edit dbrename.sql, remove all headers and comments, and change the database's name. Also change "CREATE CONTROLFILE REUSE ..." to "CREATE CONTROLFILE SET ...".
  
• Shutdown the database (use SHUTDOWN NORMAL or IMMEDIATE, don't ABORT!) and run dbrename.sql.
  
• Rename the database's global name:

ALTER DATABASE RENAME GLOBAL_NAME TO new_db_name;