Re: oracle not coming up

From: OctoPrime <OctoPrime_at_NOSPAMWhiteHouse.gov>
Date: Fri, 07 Feb 2003 16:02:34 -0500
Message-ID: <pan.2003.02.07.21.02.33.687338.387@NOSPAMWhiteHouse.gov>

On Fri, 07 Feb 2003 13:01:16 -0500, Oradba Linux wrote:

You can get this error if your ORACLE_SID is unset. to verify if your db is up go to the command line:

sqlplus sys/(pw)@instance(actually this part will determine if it is the

                                  sid or not)

select username from dba_users;(or some other simple command)

Tim

> On Fri, 07 Feb 2003 17:32:14 +0000, SP wrote:
> 

>> Hi all,
>> The DBA that's looking after a development box (oracle 8.1.7 on windows
>> 2000) is out. I restarted the box and Oracle and the listner sevvices
>> are configured to start automatically but I couldn't connect. It's
>> giving me ora-01034: oracle not available, ora-27101:shared memory
>> realm does not exist. I restarted the services and still that doesn't
>> work. I don't have any other privileged accounts. Why is Oracle not
>> coming up? TIA,
>> SP

> Oracle is not surely up and running . check the event viewer to see if > there were any issues . Received on Fri Feb 07 2003 - 15:02:34 CST