| Ora-27101: Shared Memory Realm Does Not Exist [message #158248] |
Thu, 09 February 2006 07:26  |
oraclechick
Messages: 33
Registered: February 2006
|
Member |
|
|
Hello,
I am getting the error below when i try to shutdown a database via a shell script...
SQL> ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
SQL> Disconnected
When I shut it down manually via sql*plus, it works fine. Then i started up the database again via sqlplus and tried running my script again, but i got the same error. Both oracle_home and oracle_sid are set.
Any suggestions how i can solve this?
|
|
|
|
| Re: Ora-27101: Shared Memory Realm Does Not Exist [message #158282 is a reply to message #158248] |
Thu, 09 February 2006 13:06  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
Make sure your shell script can connect to the database successfully and perform some operation to prove it. Such as connecting and running a query that spools results to a file or something, or connecting and creating or updating a table.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
