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 - 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 - 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.