-
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
Could anyone tell me what happened?
Thanx
-
startup nomount
run your script...
-
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
-
Did you make necessary changes in the init.ora??
-
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...
-
That's correct. Oradim has to be used to create a service to the db before creating the db or the controlfile.
-
Hallo,
could you tell me what those services do? I didn't find anything in the documentation.
Thanx
