Re: startup problems

From: Frank <fvanbortel_at_netscape.net>
Date: Thu, 30 Jan 2003 21:00:55 +0100
Message-ID: <3E398477.8060903@netscape.net>

Karsten Farrell wrote:

> Mathieu van As wrote:
> 

>> We have the following problem:
>>
>> Everything worked fine.
>> After placing an additional processor Oracle seemed to start without a
>> problem Listener started Database service started.
>> Connecting gave a problem ORA-27101.
>> Using DBA studio logging in as sysdba showed is a shutdown database.
>> Opening it worked fine. Connecting is now possible again.
>>
>> Does someone knows why this does occur everytime we boot and how to solve
>> it?
>>
>> Thanks,
>>
>> M
>>
>> Ora 8.1.7
>> W2K S3
>> P3 dual processor
>>

> Unfortunately, Win2K doesn't have this nice feature (oerr) available in 
> Unix. When I do that, I get:
> 
> oracle$ oerr ora 27101
> 27101, 00000, "shared memory realm does not exist"
> // *Cause: Unable to locate shared memory realm
> // *Action: Verify that the realm is accessible
> 
> Don't know what that means. But when I search on Google for ora-27101, I 
> get about 1,250 hits. Do a Google search and maybe something in there 
> will help you.
> 

Instance wasn't started. That's why a shutdown (presumably shuts the services as well) and a startup (services and instance) work.

oradim -edit -sid <your SID> -startmode auto

should do the trick Received on Thu Jan 30 2003 - 14:00:55 CST