ORA 27101 Shared memory...

[CIMTEET]

I am running code on an oracle 9i database. The two areas that I have been developing in have recently crashed with this error:
ORA 01034 Oracle not available
ORA 27101 Shared memory realm does not exist

I am not as much a pessimist as I once was but it seems that I could be doing something that oracle does not like. I am running code that is creating and dropping tables several times a day. During testing between 30 - 50 times. Could this be affecting shared memory? If not, what else could it be.

Greg

 

[SantaMufasa]

Greg,

This is one of those cases where Oracle just does not know how properly to word their error message . They should simply say, "The Oracle database instance to which you are trying to connect is not running currently."

So, either you (or a DBA colleague) needs to do the following, beginning at the o/s prompt as a member of the DBA group on your machine:

sqlplus /nolog
(It responds with "Connected to an idle instance.")
SQL> connect / as sysdba
SQL> startup
(Oracle's normal startup messages...)

Let us know if that solves your problem.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[CIMTEET]

AS I am waiting for the sysdba password I was wondering if running the startup wouldup somehow tell me what went wrong?

 

[KenCunningham]

Does the alert log give any clues?

I want to be good, is that not enough?

 

[CIMTEET]

There are others (at the company)taking care of this problem, thank you for your input.

 

[acct098]

Does anyone know of another way that the database can be started besides using SQL+? Im getting the same error and I can't get to SQL+.

 

[SantaMufasa]

Acct,

When you say, "I can't get to SQL+," what, specifically does that mean? Whatever SQL*Plus's response to your attempt to connect, could you please post the copy-and-paste of the SQL*Plus response?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]