Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    korea
    Posts
    2

    Unanswered: Error [ ORA-27101: shared memory realm does not exist ]

    Hi, everyone

    my system info is below :

    o/s : windows 2000 professional
    cpu : pentium IV
    Oracle version : oracle 8.1.7

    I've installed oracle 8i

    And I execute SQLPLUS.exe

    I entered name and password

    id: system
    password : manager

    But I've got the following error message.

    ORA-01034: ORACLE not avilable
    ORA-27101: shared memory realm does not exist


    please Help me!! I really want your help.. T.T

  2. #2
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    44

    Re: Error [ ORA-27101: shared memory realm does not exist ]

    As far as I can remember Oracle on Windows it means that is the message you get when database is down.
    Check if your database is running.

    Jacek

    Originally posted by parakiss
    Hi, everyone

    my system info is below :

    o/s : windows 2000 professional
    cpu : pentium IV
    Oracle version : oracle 8.1.7

    I've installed oracle 8i

    And I execute SQLPLUS.exe

    I entered name and password

    id: system
    password : manager

    But I've got the following error message.

    ORA-01034: ORACLE not avilable
    ORA-27101: shared memory realm does not exist


    please Help me!! I really want your help.. T.T

  3. #3
    Join Date
    Aug 2003
    Location
    korea
    Posts
    2

    I got the answer!

    ------------------------------------------------------------------------------
    Suffered from the same problem on an NT-instance. The NT service seems to be running but the instance isn't. Please use SQL*Plus; connect "sys/change_on_install as sysdba" and startup the instance manually

    try this, open dos window.

    C:> net start oracleservice%SID%
    The OracleService%SID% service is starting.
    The OracleService%SID% service was started successfully.

    C:> sqlplus
    SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 7 12:20:13 2002

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter user-name:sys/sys_change_on_install as sysdba
    connected to idle instance.

    SQL> startup open pfile=E:\oracle\admin\%SID%\pfile\init.ora
    ORACLE instance started.

    Total System Global Area 177281688 bytes
    Fixed Size 453272 bytes
    Variable Size 100663296 bytes
    Database Buffers 75497472 bytes
    Redo Buffers 667648 bytes
    Database mounted.
    Database opened.
    SQL>

Posting Permissions

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