OraFAQ Forum: Server Administration » ORA-01034 & ORA-27101: shared memory realm does not exist

Home » RDBMS Server » Server Administration » ORA-01034 & ORA-27101: shared memory realm does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01034 & ORA-27101: shared memory realm does not exist [message #54465]

Tue, 19 November 2002 07:36

Sue
Messages: 49
Registered: May 2000

Member

I have Oracle 9i, running on RedHat 7.2. I have my environment variables (ORACLE_HOME, ORACLE_SID, NLS etc...) set during login for my user Oracle.

When I attempt to "sqlplus sue " I recieve the error:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

However, when I attempt to "sqlplus sue@test " I connect no problem. Also, if I echo my $ORACLE_SID I do get the correct variable name (it matches my tnsnames.ora).

What am I missing here?

Thanks!!

Report message to a moderator

Re: ORA-01034 & ORA-27101: shared memory realm does not exist [message #54468 is a reply to message #54465]

Tue, 19 November 2002 08:11

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. is $ORACLE_HOME/bin included in your $PATH?
2. if TEST is the connect string, does that target
   database SID same as your ORACLE_SID?

Report message to a moderator

Re: ORA-01034 & ORA-27101: shared memory realm does not exist [message #54470 is a reply to message #54465]

Tue, 19 November 2002 08:17

B
Messages: 327
Registered: August 1999

Senior Member

this error append when Oracle is not stated .. but it's not ( in this case )

1-use tnsping [[DB]] to see if Ur database is local
host = ur machine if not connect to host...
2-verify that ORACLE_SID and ORACLE_HOME is correct
( like 0 ( zero )is not O ( o letter ) )
3-verify that all processes are started ( use ps -ef | grep [[DBNAME]] if not Ur database is not open.

Report message to a moderator

Previous Topic:	Oracle on WIndows 2000 & Terminal Services
Next Topic:	how to set ORACLE_HOME ORACLE_SID PATH

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 16:56:11 CST 2024