ORA-01034 Oralce not available when creating database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: ORA-01034 Oralce not available when creating database

  1. #1
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82

    ORA-01034 Oralce not available when creating database

    Hi,

    Oracle 9iR2, OS Windows XP


    I am trying to set up instance and database manualy. I have allready created instance and I am able to connect to instance. But when I try to execute command CREATE DATABASE test I get ORA-01034 Oracle not available.

    And here are the steps

    1. I have created dictories

    oradim -new -sid TEST -pfile "c:\ora9iR2\databas\initTEST.ora" startmode a

    I have used the sample init file, renamed it copied it to default location, changed the value db_name to TEST and added two lines
    DB_CREATE_FILE_DEST=C:\ORA9iR2\OraData\TEST
    DB_CREATE_ONLINE _LOG_DEST_1=C:\ORA9iR2\OraData\TEST

    2. SET ORACLE_SID = TEST
    SET LOCAL = TEST

    3.sqplus /nolog
    4.conn /as sysdba
    Connected to idle instance

    5.create database "TEST";

    Here is where I get ORA-01034

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    After
    4.conn /as sysdba
    Connected to idle instance

    You have to give

    STARTUP NOMOUNT pfile=%path%

    Then

    Create DB command
    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"

  3. #3
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    Thank you, but now I have new problem

    I can now execute command
    create database TEST;

    But now I am getting ORA-01092 Oracle instance terminated. Disconnection forced.

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    I wud now suggest RTM
    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"

  5. #5
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    I am allready doing that and asking experts like you if they can help.

    Thank you.

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Check Alert.log for errors.
    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"

  7. #7
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Check if you have right permissions in the folders you are trying to create the database. Also check if you are trying to overwrite the any datafile during database creation. Maybe the alertlog will let you know what other errors are associated.
    Last edited by patel_dil; 08-13-2003 at 09:47 AM.
    -- Dilip

  8. #8
    Join Date
    Jul 2002
    Posts
    335

    Re: ORA-01034 Oralce not available when creating database

    ------------------------------------------------------------
    oradim -new -sid TEST -pfile "c:\ora9iR2\databas\initTEST.ora" startmode a

    ---------------------------------

    try startmode manual (you can use oradim -edit later if need be to set it to auto startup), when you create the instance.

    Wipe out any old services and clean up your box before starting again of course, make sure you delete any old PWD*.ora files as well.

    Bazza

  9. #9
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    Check Alert.log for errors.

    Check alert.log for errors and then post the question!!!!

    I forgot to create password file


    Thank you all ( for now )

  10. #10
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    Check Alert.log for errors.

    Check alert.log for errors and then post the question!!!!

    I forgot to create password file


    Thank you all ( for now )

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