ORA-27101: shared memory realm does not exist
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-27101: shared memory realm does not exist

  1. #1
    Join Date
    Aug 2000
    Posts
    32

    Unhappy ORA-27101: shared memory realm does not exist

    Can someone identify the problem in from the below....This is solaris flatform. Problem in short is...if I login to sqlplus as oracle(os user) then, it works without connect string, if I login to sqlplus as another OS user, it works with connect string but not without connect string.


    psdevfm1 21: su - oracle
    Password:
    Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001
    [oracle@psdevfm1] $ sqlplus eastdev1/eastdev1

    SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 11 16:23:45 2004

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    SQL> exit
    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production
    [oracle@psdevfm1] $ exit
    logout
    psdevfm1 22: sqlplus eastdev1/eastdev1

    SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 11 16:24:09 2004

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 Error: 2: No such file or directory


    Enter user-name: ^C
    psdevfm1 25: sqlplus eastdev1/eastdev1@efmdev1

    SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 11 16:24:32 2004

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    SQL>


    I would really appreciate if someone can figure it out.

    Thanks,
    Vimala

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Either your environment is setup wrong or you aren't a member of the DBA group.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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