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
    Location
    chicago
    Posts
    13

    Angry

    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?.

    kreddy

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    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 ?
    Vinit

  3. #3
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    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