Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: a problem after reboot

    I install oracle8.1.7 on linux

    when install finish and successful

    I can user sqlplus .

    then i reboot.

    sqlplus cannt be used.
    -------

    ERROR:
    ORA-01034: ORACLE not avilable
    ORA-27101: shared memory realm dose not exist
    Linux Error: 2: No such file or directory

    -------

    why ??

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Sounds like Oracle did not restart. Have you checked that it is running? Check you alert log and see if something is amiss.
    NOTE: Please disregard the label "Senior Member".

  3. #3
    Join Date
    Jan 2004
    Posts
    3
    I am a new bird

    how to check the alter log and restart the oracle ?

    -__-

  4. #4
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    "ps -ef | grep ora" should give you a listing of several processes.

    your ALERT (not alter) log is located in your $DBHOME/admin/{SID}/bdump directory.
    NOTE: Please disregard the label "Senior Member".

  5. #5
    Join Date
    Jan 2004
    Posts
    370
    Do you have shared memory configured on your system?

  6. #6
    Join Date
    Jan 2004
    Posts
    3
    I used ps command and cannt find oracle services.

    I open the alert log.

    the last date in the file is the day I installed oracle , I can't find anything today

  7. #7
    Join Date
    Jan 2004
    Posts
    99
    check your oracle_sid.....

    echo $ORALCE_SID

    if this is not set then export ORACLE_SID=sid_name!

  8. #8
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Try starting svrmgrl and connect as internal. Type "startup". Once the DB is running then you can proceed to figure out why it is not restarted.
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

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