ORA-01034: ORACLE not available ORA-27101?

suresheva31 · 10-18-2004, 01:49 PM

Hey guys?

I have the following error, when i try to retrieve data from oracle database. It was working fine all these time, but all the sudden i got this message. Andy Idea, how to fix this. I am posting this question I am using linux.

And I am not sure how to check my ORACLE_SID value. Does any one knows how to check the oracle sid value? Command for that..

Any hints or Ideas;

Suresh

tcnm · 09-12-2015, 08:34 PM

I have the same problem.
I am running oracle 11 on linux ubuntu 12.10. Oracle has been running successfully for some time. Now ,suddenly, when I try to log in, I get the message:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
ORACLE_HOME and ORACLE_SID have not changed, and I have made no changes in the database.
Can anyone help?
Thank you
tim mann

chrism01 · 09-13-2015, 10:54 PM

@suresheva31: ORACLE_SID is usually an env variable, so try

Code:

echo $ORACLE_SID

tcnm · 09-14-2015, 07:33 AM

ORACLE_HOME is /u01/app/oracle/product/11.2.0/xe
ORACLE_SID is XE
They have been these values for more than a year of successful operation

tim mann

tcnm · 09-16-2015, 11:56 AM

Fortunately, I was able to solve my problem
I entered 'sqlplus sys as sysdba'
It asked for a password, but luckily I was able to remember the one I had set a very long time ago
At the Oracle prompt I then entered 'startup'
And the database started!

tim mann