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