LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 10-18-2004, 01:49 PM   #1
suresheva31
LQ Newbie
 
Registered: Oct 2004
Posts: 25

Rep: Reputation: 15
ORA-01034: ORACLE not available ORA-27101?


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
 
Old 09-12-2015, 08:34 PM   #2
tcnm
Member
 
Registered: Aug 2005
Location: Fanwood, NJ
Distribution: Ubuntu 15.10
Posts: 33

Rep: Reputation: 0
Same problem

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
 
Old 09-13-2015, 10:54 PM   #3
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.7, Centos 5.10
Posts: 17,091

Rep: Reputation: 2270Reputation: 2270Reputation: 2270Reputation: 2270Reputation: 2270Reputation: 2270Reputation: 2270Reputation: 2270Reputation: 2270Reputation: 2270Reputation: 2270
@suresheva31: ORACLE_SID is usually an env variable, so try
Code:
echo $ORACLE_SID
 
Old 09-14-2015, 07:33 AM   #4
tcnm
Member
 
Registered: Aug 2005
Location: Fanwood, NJ
Distribution: Ubuntu 15.10
Posts: 33

Rep: Reputation: 0
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
 
Old 09-16-2015, 11:56 AM   #5
tcnm
Member
 
Registered: Aug 2005
Location: Fanwood, NJ
Distribution: Ubuntu 15.10
Posts: 33

Rep: Reputation: 0
Wink Problem Solved

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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference between Oracle Server and Oracle Database ganninu Programming 3 02-27-2007 01:06 AM
xhost + as user oracle not working, need to see oracle install GUI enzo250gto Linux - Software 2 02-11-2007 11:27 AM
oracle 8i pudhiyavan Linux - Software 1 01-25-2005 05:06 AM
ORA-00205 Error ptreves Linux - Software 0 09-06-2004 04:48 PM
Oracle 9i client with Oracle 8i server ganninu Programming 1 02-19-2004 04:35 PM


All times are GMT -5. The time now is 11:48 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration