|
|
|
|
|
|
|
|
| Re: How does one rename a database in detail [message #145338 is a reply to message #145025] |
Wed, 02 November 2005 10:24  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
| shri_1983 wrote on Mon, 31 October 2005 07:25 |
Dear Sir,
I have done following steps:
1.rename of last dump file in user_dump_dest after the 'alter database command' as specified in the orafaq second question.
2.removed all comments,headers.
3.where should i change the dbname ? in create controfile command or else.. bez there is only instance of db name that is in create controlfile command only.also i have change'reuse' to 'set'in the same command.
4.after shutdown of the db ,i have runned dbrename.sql.
5.at this time it gives the error after startup mount command execution.i.e. for ex. new db_name is sri and current one is ishakti. then it gives the error. create controlfile command failed.db name sri doesnot match parameter db_name 'ishakti'.
6.please clarify regarding the same.
7. as per my info i have to set the parameter db_name to new name 'sri' before run of dbrename.sql.
thanks..
shrinivas.
|
I think I got a picture of what u r doing..and what u r doing wrong
Try thse steps after shutdown and before running dbrename.sql (#4)
a. make a copy of init.ora
cp initishakti.ora initsri.ora
b. edit initsri.ora
"db_name=sri" (your new db) - VERY IMP
c. rename the control files as new ones are created during the dbrename.sql (all of them)
mv control.ctl control_old.ctl
d. set ORACLE_SID=sri (hope you did this)
You should be OK..
--
Sanjay
[Updated on: Wed, 02 November 2005 10:27] Report message to a moderator |
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
