unable to connect the database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: unable to connect the database

  1. #1
    Join Date
    Nov 2001


    i have already the 'oracle' database.
    i want to create new database 'pra'.
    after then i run the script 'create database pra................'.
    i got the error create database failed.
    then i tried and leave that one.

    then again i am going to connect my old database 'oracle'
    it is giving error.
    i given cmds like this
    svrmgr>startup pfile=c:\oracle\admin\oracle\pfile\init.ora

    ORA-01103:database name 'PRA' in control file is not 'ORACLE'.

    now what i have to do to connect the 'oracle' database and to open it.
    please help me anybody?.


  2. #2
    Join Date
    Oct 2000
    1. Did you set your ORACLE_SID before creating your new database ?
    2. Did you give connect internal before giving the startup command >
    3. Which version or Oracle/OS are you runnng ?

  3. #3
    Join Date
    Aug 2001
    Waterloo, On
    Did you give 'control file reuse' in the create database statement for 'pra'?
    In that case, your control file is affected. Since init.ora has a different db name, hence the error.
    You can create a new control file from your backed up control file.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i

    Mail me at raminderahluwalia@rediffmail.com.

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