Problems with database name
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Problems with database name

  1. #1
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    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

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    startup nomount

    run your script...

    Radhakrishnan.M

  3. #3
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    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

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Did you make necessary changes in the init.ora??

  5. #5
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    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...

  6. #6
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    That's correct. Oradim has to be used to create a service to the db before creating the db or the controlfile.

  7. #7
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    Hallo,
    could you tell me what those services do? I didn't find anything in the documentation.
    Thanx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width