ORA-27101: shared memory realm does not exist

[inosov]

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]

[forad98]

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.

[lwangf]

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.