ORA-27101: shared memory realm does not exist

[forad98]

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.

[inosov]

Comment out the line
SQLNET.AUTHENTICATION_SERVICES= (NTS)
in %ORACLE_HOME%/network/admin/sqlnet.ora

[forad98]

Hi,

Thanks for the reply.

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

[Queyon]

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

[forad98]

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!

[inosov]

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.

[forad98]

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

[inosov]

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.

[forad98]

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.

[forad98]

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.