SHSUFLIGHT
asked on
ORA-01034: ORACLE not available ORA-27101
some body help me out of this i am using oracle 10 and suddenly got an error
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As the comment above, make sure the DB is up and open, if it is, then make sure your SID is set correctly, or use tns and DB name (network) to conenct.
I don't believe you will receive an "ORA-27101: shared memory realm does not exist" if it was a sid/tns config issue.
I agree with slightvw, check Oracle Alert log file for any error message.
mohammadzahid,
"I agree" really isn't a valid post. Unless you have additional content to add, please do not post.
"I agree" really isn't a valid post. Unless you have additional content to add, please do not post.
Not sure why you think incorrect SID willnot give such error, here is an example, please try it....
s365-us-ora-1:~$ ORACLE_SID=usora9i
s365-us-ora-1:~$ sqlplus system/manager
SQL*Plus: Release 9.2.0.8.0 - Production on Mon May 9 11:50:59 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
s365-us-ora-1:~$ ORACLE_SID=6238681~236;
s365-us-ora-1:~$ sqlplus system/manager
SQL*Plus: Release 9.2.0.8.0 - Production on Mon May 9 11:51:09 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
s365-us-ora-1:~$ ORACLE_SID=usora9i
s365-us-ora-1:~$ sqlplus system/manager
SQL*Plus: Release 9.2.0.8.0 - Production on Mon May 9 11:50:59 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
s365-us-ora-1:~$ ORACLE_SID=6238681~236;
s365-us-ora-1:~$ sqlplus system/manager
SQL*Plus: Release 9.2.0.8.0 - Production on Mon May 9 11:51:09 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
I wasn't thinking local connection. Yes, if connecting locally, SID comes into play.