DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 9i Database Creation problem...

  1. #1
    Join Date
    Feb 2002
    Posts
    2
    I am trying to create a 9i database on a W2K, 128 MB 1.0 GHZ machine. The process using the Database Configuration Assistant is very slow, so I decided to drop the database, run the Assistant and generate the scripts ONLY and then run the scripts individually.

    When I ran the CreateDB.sql script, I get "ORA--01092: ORACLE instance terminated. Disconnection forced." This is the native script generated by the assistant. The weird thing is that the redo logs, control files, and the database files have been created.

    Any ideas?

    Thanks,

    Tom



  2. #2
    Join Date
    Sep 2001
    Posts
    120
    hi,

    check to see that sqlnet.ora has entries like :
    ///////////////////////////////////////////
    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)

    /////////////////////////////////////////////

    then you should delete any instance created by giving this command

    oradim -DELETE -SID

    also delete any files created by the previous instnace

    then make sure all the folders are there which the scripts have as they r not made when the scripts r generated.


    -------------------
    create now as follows..
    open command window

    set ORACLE_SID=%YourSID%

    oradim -new -sid -startmode m -pfile
    oradim -edit -sid -startmode a

    A typical setup will have these scripts

    sqlplus /nolog @c:\TESTDIR\CreateDB.sql
    sqlplus /nolog @c:\TESTDIR\CreateDBFiles.sql
    sqlplus /nolog @c:\TESTDIR\CreateDBCatalog.sql
    sqlplus /nolog @c:\TESTDIR\JServer.sql
    sqlplus /nolog @c:\TESTDIR\ordinst.sql
    sqlplus /nolog @c:\TESTDIR\interMedia.sql
    sqlplus /nolog @c:\TESTDIR\context.sql
    sqlplus /nolog @c:\TESTDIR\ordinst.sql
    sqlplus /nolog @c:\TESTDIR\spatial.sql
    sqlplus /nolog @c:\TESTDIR\ultraSearch.sql
    sqlplus /nolog @c:\TESTDIR\cwmlite.sql
    sqlplus /nolog @c:\TESTDIR\demoSchemas.sql
    sqlplus /nolog @c:\TESTDIR\postDBCreation.sql

    let me know any problem comes...

    while running the first file if it gives error the stop the service which you just created and restart the service and again set the oracle_sid in the window.

    if error comes you have to create it manually...

    i think you have not created password file so see the alert file and make a password file through orapwd in oracle_home/database/ directory..


    saurabh


    [Edited by saurabhg29 on 02-23-2002 at 08:11 PM]
    Saurabh Garg
    OCP 9i

  3. #3
    Join Date
    Feb 2002
    Posts
    2

    Talking FIxed!!

    The password file was missing. Don't know why, but it wasn't created. Once I created it, everything ran smoothly.

    Much obliged,

    Tom

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