Hi,

I installed Oracle 9i in my computer (Windox XP Professional). Later, I need
to test something in Oracle 8i. So I installed Oracle8i for testing.
Everything is going perfect. But the next day when I turn on my computer. I
could connect to my Oracle8i database. Oracle8i database service is starting
and runing. Listener is starting and working. The error message is :

ORA-27101 shared memory realm does not exist

I try to restart the database and the listener, it doesn't work.

Thanks a lot for your help.

Richard

This may be because you are attempting a BEQUEATH connection using the wrong
Oracle home. Try finding the Oracle Home Chooser (or is it called Home
Selector now?) in the Oracle sections of your Start Menu, and make sure you
are using the correct Oracle Home. If you know more about Oracle
connectivity, you can make sure you are always using a TNS connection string
that will go through a listener, instead of requesting a BEQUEATH
connection, which requires that the current Oracle Home be the same as the
instance you are trying to connect to. If you don't know about BEQUEATH,
I'll just state that if your connection strings do not specify a server
name, then you are probably using BEQUEATH.

--
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"Richard Xu" <richardxu98 (AT) hotmail (DOT) com> wrote

Hi,

While the actual database service may be started, your instance is not.
Startup SVRMGRL from your Oracle 8i home (It doesn't come with 9i anyway),
and use the startup command with the correct parameter file.

This should resolve your problem.

"Richard Xu" <richardxu98 (AT) hotmail (DOT) com> wrote

Try increasing the virtual memory of the system. It will probably fix the
problem.


Regards

RS

"Richard Xu" <richardxu98 (AT) hotmail (DOT) com> wrote

"RS" <rohitsinha (AT) comcast (DOT) net> wrote

Hi man!

There are 2 diff versions of oracle installed.
Obviously there should be 2 diff oracle homes.The present oaracle home
refers to the TNS_ADMIN variable which points to a tnsnames.ora file
pointing to the 9i instance which is presently not started.
Check the $TNS_ADMIN variable. make it point to tnsnames.ora
of 8i oracle home.this should connect.

Best Regards
J