Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01034 & ORA-27101

420123Oct 18 2004 — edited Apr 12 2011
Hi

I'm getting the following error if I try to log in to sql*plus :

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

I had the error before, that was because my oracle does not want to start. So I typed the following in cmd :

set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup

And that has done the trick in the past. I've been on holiday for the past 2 weeks, and now it does not want to work. Everyone here swears they haven't changed anything, ya sure !!

My oracle does start up. I can desc a table. So that works. But if I try to logg into Toad or Sql*Plus it gives me the Ora 01034 & 27101 errors.

Anybody got any idea what it can be? I am working on the pc where oracle is installed on. So not through the network. Pc is logged onto a network though. I think somebody did change some security setting on the network. But I can not find that somebody ..... Could that give me the errors. Or is it something else ?

Thanks
Karen
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2011
Added on Oct 18 2004
13 comments
96,547 views