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

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

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    8
    Hi,

    I have installed Oracle Personal Edition on windows 2000.
    I get ORA-27101: shared memory realm does not exist; ORA-01034: ORACLE not available when i try to connect to the database through SQL*Plus: Release 8.1.7.0.0 - Production . I checked the tnsnames.ora for correct sid.

    Though i must mention that i also have a client version of oracle Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production on my machine, which has the database on the network. This seems to be working fine.

    Both the above versions are installed different directory and i am trying to access them from their directory only.

    Can someone please help me resolve this conflict that i am entangled in.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2001
    Posts
    37
    Comment out the line
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    in %ORACLE_HOME%/network/admin/sqlnet.ora
    inosov
    Brainbench MVP for Oracle DBA

  3. #3
    Join Date
    Apr 2001
    Posts
    8

    RE:

    Hi,

    Thanks for the reply.

    I tried what you mentioned. But i am still getting the same error. I need help!



  4. #4

    Unhappy

    Could you explain this?
    What does NTS mean?
    Why and how this will work?
    Thanks.
    Queyon Zeng

  5. #5
    Join Date
    Apr 2001
    Posts
    8

    The tns.ora that i have ..

    C:\OraclePersonal\network\admin\tnsnames.ora has following...


    MYORACPN =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = MyOracPn)
    )
    )



    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    The Oracle Service is running fine too. Please help!

  6. #6
    Join Date
    Apr 2001
    Posts
    37
    Open a DOS prompt, set ORACLE_SID and try to run svrmgrl:

    c:> set ORACLE_SID=
    c:> svrmgrl

    Can you use svrmgrl this way, startup and shutdown database etc?
    If yes, verify that ORACLE_SID is set correctly in registry.
    inosov
    Brainbench MVP for Oracle DBA

  7. #7
    Join Date
    Apr 2001
    Posts
    8

    RE:

    I get ORA-12560: TNS:Protocol adapter error whe i run the set command.

  8. #8
    Join Date
    Apr 2001
    Posts
    37
    Pls try again (due to typo error):
    Open a DOS prompt, set ORACLE_SID and try to run svrmgrl:

    c:> set ORACLE_SID= your_SID (!)
    c:> svrmgrl

    Can you use svrmgrl this way, startup and shutdown database etc?
    If yes, verify that ORACLE_SID is set correctly in registry.
    inosov
    Brainbench MVP for Oracle DBA

  9. #9
    Join Date
    Apr 2001
    Posts
    8

    RE:

    I get following error:ORA:12154 : TNS:Could not resolve service name.

    Also i noticed in the registry the following:

    software/ORACLE/ALL HOMES has 2 different homes. One for the version (HOME0)which has oracle db on the network and HOME1 which has the Personal Edition Oracle8i

    Under software/ORACLE/ORACLE_HOMES , there is ONLY ONE sublisting that is ORACLE0 which is referring to the network version.

    I suspect that that the reference is only to one Oracle_home although the Personal version is installed correctly with its own Oracle_home (HOME1) and respective attributes.

    I don't know what to do ?

    Thanks for your active help. I appreciate that.


  10. #10
    Join Date
    Apr 2001
    Posts
    8

    RE:

    I don't get the TNS unresolved error this time. The server mgr through dos seems to be working fine. I don't know what i can do at the registry level, as i mentioned earlier that the default home recognized is only one.

    Someone please help!
    Thanks.

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