Database name already exists
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Database name already exists

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    Database name already exists

    Running 8.1.5.0 on NT4

    Created a DB using the DB Configuration Assistant, then deleted it with same.

    I've checked and it has deleted:

    All reference to any datafiles created.
    All references in the registry.

    However, when I try to create another DB with the same name I get an error that the name is in use by an existing DB.

    Where else can I look to find references to this DB and delete them as I need to use this name.

  2. #2
    Join Date
    Jul 2002
    Posts
    5
    >>However, when I try to create another DB with the same name I get an error that the name is in use by an existing DB.

    Are you getting the error with the Configuration Assistant?
    If so, you just need to go out and delete the FOLDERS that the config assistant created for you.
    So if you created a db called FRED, go out and delete all the FRED folders. I believe they are located in the ORACLE_HOME directory.
    --Christopher

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Not a very techy reason !!!!

    When you create a new DB you're prompted for a location for the pfile.
    The first time I did it - it creates a folder in NT for the parameter file.

    When you try the 2nd time, it realises the folder already exists and assumes that the database also exists.

    I renamed the NT folder and could then create the DB again.

    Amazing!

  4. #4
    Join Date
    Jul 2000
    Posts
    9
    Make sure that all entries in the registry are deleted.

    1. From Dos prompt regedit- HKEY_LOCAL_MACHINE then SOFTWARE Delete all entries regarding to the deleted Database.
    2. From Dos prompt regedit- HKEY_LOCAL_MACHINE then SYSTEM -CurrentControlSet- Services .Delete all the services about deleted database.

    Thanks

    Sam

  5. #5
    Join Date
    Dec 2002
    Posts
    36
    In addition to sri_purna's contribution, delete all oracle related files/folders from the registry. Shutdown and restart.

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Playing with registry might cost u very much.......
    Be sure wat u r deleting in registry.....

    Before u delete try checking this in registry.....

    HKEY_LOCAL_MACHINE\SOFTWARE\YOUR_ORACLE_BASE(DIR)\HOME

    ckeck if u still have the ORACLE_SID set as ur DB name in this path.

    also remove from environmental variables if Oracle_SID was set......

    check if the OracleServiceYOUR_DB_Name still exists in the services.

    regards
    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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