Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2008
    Posts
    2

    Angry Unanswered: ORA-01034: ORACLE not available

    Hello! I have just installed Oracle 9i Release 9.2.0.1.0 On Windows Server 2003. I am trying to
    get SQLPlus working on my database server but I have one little problem.
    Only the oracle user (who setup the software) can access SQLPlus with any
    Oracle user account to do any database functions

    While trying to login the error was displaying

    ORA-01034: ORACLE not available
    ORA-27121: unable to determine size of shared memory segment


    What am I doing wrong?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > I have just installed Oracle 9i Release 9.2.0.1.0
    Installed an obsoleted version of software without reading & following Installation Guide.

    You're On Your Own YOYO)!
    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
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    did you setup the listener and the tnsnames.ora file?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jun 2008
    Posts
    2
    Hello! I have just installed Oracle 9i Release 9.2.0.1.0 On Windows Server 2003. I am trying to
    get SQLPlus working on my database server but I have one little problem.
    Only the oracle user (who setup the software) can access SQLPlus with any
    Oracle user account to do any database functions

    While trying to login the error was displaying

    ORA-01034: ORACLE not available
    ORA-27121: unable to determine size of shared memory segment

    Here after installing when i am in workgroup i am able to access sql plus but when i am adding to some other domain i am getting these type of errors


    What am I doing wrong?

  5. #5
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Google for ORA-27121, there's loads of hits with the answer that you want/need.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    in windows systems, a local group called ORADBA or some such is automatically created. Provided you have your password file set up correctly, anyone in that group should be able to connect internal.

  7. #7
    Join Date
    Apr 2007
    Posts
    1
    Hi,

    Please restart the listener i guess that should fix it

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by vikramroger
    Hi,

    Please restart the listener i guess that should fix it
    A listener is NOT required to connect to the database.
    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.

  9. #9
    Join Date
    Jul 2008
    Posts
    5
    Please check the memory related parameters in init.ora, please make sure youe setting is correct in Windows environment

Posting Permissions

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