I'm trying to change the db name. I've created a trace controlfile. I changed the CREATE CONTROLFILE REUSE DATABASE... with CREATE CONTROLFILE SET DATABASE ...
I've stopped the instance, renamed current control files, modified init.ora as to reflect the new db name, issued startup and then run from svrmgr the script with controlfile creation. In this moment I get the following error:
ORA-01503 CREATE CONTROLFILE failed
ORA-01158 database already mounted
ORA-01507 DATABASE NOT MOUNTED
That's what I was doing. I issued
startup nomount - it was OK
I tried to run the script ind I got errors as if the database is already mounted which is not true, I've checked
I did all the changes in init.ora. I also found the reason for the error. It is related to the two services NT creates when running ORADIM utility OracleServiceSID and OracleStartSID. They must be stopped and restarted before recreating the controlfile. Don't ask me why...
Bookmarks