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

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

  1. #11
    Join Date
    Apr 2001
    Posts
    37
    1.Check ORACLE_SID in registry :
    HKEY_LOCAL_MASHINE\SOFTWARE\ORACLE\HOME1

    2.Try to switch ORACLE_HOMEs so ORA817HOME will be the first HOME
    (Start-> Programs -> Oracle for Windows NT -> Oracle Home Selector)


    [Edited by inosov on 04-09-2001 at 03:14 PM]
    inosov
    Brainbench MVP for Oracle DBA

  2. #12
    Join Date
    Apr 2001
    Posts
    8

    Hey Thanks! I just got time to look at it.

    As we discovered , it was the problem with multiple homes. I changed the default home to the Personal edition Oracle8i and the database is getting connected from the that directory.

    I am trying to use data blocks in form to base the table in the oracle8i edition. I must mention that forms and Reports6i was installed on another directory which apparently seem to be having its own HOME which is also reflected in the registry. But when i try to use Form builder to connect to the database which is in another HOME gives me the TNS:Could not resolve service name. I am new to this. Could you help me in resolving this problem.

    MUCH THANKS.

  3. #13
    Join Date
    Nov 2000
    Posts
    51
    I got the same error before, it's because you don't have enough memory. What I did is decrease the # of process defined in init.ora file.

    Hope it helps.

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