Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2012
    Posts
    22

    Unanswered: ora-01034 : ORACLE not available

    Hii..,

    i am using Windows vista Business 32bit, intalled s/w Oracle 11.2.0

    i created my database in oracle 11.2.0 manually and i able to mount successfully and at last i also run the 3 scripts from my command prompt but when ever i am starting my sqlplus and i am entering "scott/tiger" or "orcl/tiger" it shows me error

    >ora-01034 : ORACLE not available
    ora- 27101: shared memory realm does not exist
    Process ID:0
    Session ID:0
    Serial number:0

    Thanx..

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    034, 00000, "ORACLE not available"
    // *Cause: Oracle was not started up. Possible causes include the following:
    //         - The SGA requires more space than was allocated for it.
    //         - The operating-system variable pointing to the instance is
    //           improperly defined.
    // *Action: Refer to accompanying messages for possible causes and correct
    //          the problem mentioned in the other messages. 
    //          If Oracle has been initialized, then on some operating systems,
    //          verify that Oracle was linked correctly. See the platform
    //          specific Oracle documentation.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2005
    Location
    Gex - France
    Posts
    15
    I'm not using Oracle on Windows, but I guess it works quite the same way as Unix. So:
    You have to specify to which database you want to connect. To do that, you must set up the global variable ORACLE_SID.
    Another solution is to use a tns entry (in the tnsnames.ora file) and use this sqlplus syntax:
    sqlplus user/password@tns-entry-name
    Note: in this second solution, you must also start a listener for this database.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Ora-12560: Tnsrotocol adapter error [id 989716.1]
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Nov 2005
    Location
    Gex - France
    Posts
    15
    Did you check your global env variables? ORACLE_HOME, ORACLE_SID and PATH
    If PATH is not set with the correct oracle_home at the beginning, you can get this error.

  6. #6
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Maybe your instance is not started.
    Try these steps:
    1. open cmd prompt
    2. type: sqlplus /nolog
    3. type: connect sys/your_password as sysdba
    4. if you get connected to an idle instance, type: startup
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •