More clarity on 'Create Database'-Critical
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: More clarity on 'Create Database'-Critical

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    hi,

    I was creating a new database (In addition to the default ORCL database) on oracle 8.0.5 for NT.
    These were the steps followed by me.

    1) svrmgr> connect internal
    2) shutdown immediate
    3) changed the initorcl.ora for db_name = oct, and saved as
    initoct.ora
    4) svrmgr> startup pfile=d:\orant\database\initoct.ora
    nomount

    5) svrmgr>create database oct

    6) added the oct entry in the tnsnames.ora

    I am not able to open any of the database(orcl / oct).
    While try to connect as

    svrmgr>startup pfile=...\initorcl.ora open orcl (for orcl)
    svrmgr>startup pfile=...\initorcl.ora open orcl (for orcl)

    I get ERROR: ORA-03123:Operation would block

    could any one help me resolving this, my test database is stopped functioning.
    Also explain, how we can work with 2 databases on the same machine.
    Badrinath

  2. #2
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    Hi, in addition to init.ora file you must configure config.ora file also. After this only you control file will get created under the name of the new oracle db name
    Rgds
    Ganesh .R
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

  3. #3
    Join Date
    Jan 2000
    Location
    paris
    Posts
    11
    And what have you been doing with the services ?

    OracleServiceXXXX and OracleStartXXXX


    Laurence

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    have you changed ORACLE_SID when you created the second DB?

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