Home » Infrastructure » Unix » DB Name Change
DB Name Change [message #97122] Thu, 13 December 2001 23:09 Go to next message
Easwar Palanisamy
Messages: 2
Registered: December 2001
Junior Member
How to change the Oracle Database Name....?
Is this possible....?

Awaiting reply...
Thanks,
Easwar Palanisamy

----------------------------------------------------------------------
Re: DB Name Change [message #97123 is a reply to message #97122] Thu, 13 December 2001 23:17 Go to previous message
Hrudananda Baral
Messages: 12
Registered: October 2001
Junior Member
Check Metalik: Note:15390.1 How to Determine and Change DB_NAME or ORACLE_SID

Otherwise follow the steps below one by one..
1. sqldba
2. connect internal
3. alter database backup controlfile to trace;
This will write in a trace file, the CREATE CONTROLFILE command that
would recreate the controlfile as it currently exists.
4. Exit and go to the directory where your trace files are located.
They are usually in the $ORACLE_HOME/rdbms/log directory.
If user_dump_dest is set in the initSID.ora, then go to the directory listed in the user_dump_dest variable.
The trace file will have the form "ora_NNNN.trc with NNNN being a number.
5. Get the CREATE CONTROLFILE command from the trace file and put it in a
new file called something like ccf.sql.
6. Edit the ccf.sql file and modify the CREATE CONTROLFILE command.
Just change the word "REUSE" to "SET",and "NORESETLOGS" to "RESETLOGS", and modify the dbname.
Old line:
CREATE CONTROLFILE REUSE DATABASE "olddbname" NORESETLOGS ...
New line:
CREATE CONTROLFILE set DATABASE "newdbname" RESETLOGS ...
Then save the ccf.sql file.
7. Rename the old control files for backup purposes and so they are not in the way of creating the new ones.
8. Edit initSID.ora so that db_name="newdbname".
9. sqldba
10. connect internal
11. startup nomount
12. @ccf
13. alter database open;
14. Make sure the database is working. Shutdown and backup the database.

Cheers
Baral

----------------------------------------------------------------------
Previous Topic: Re: MS Excel data into Oracle on Unix DB
Next Topic: Re: MS Excel data into Oracle on Unix DB
Goto Forum:
  


Current Time: Wed Sep 30 11:59:13 CDT 2020