Re: oracle not coming up

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Mon, 10 Feb 2003 13:21:27 +0100
Message-ID: <3E479947.2040708@science-computing.de>

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
>
>

If I read your post correct, then the instance was started (so the service was running) but the database is not opened.

Besides that there might be a misconfiguration, which was answered by the other posters, it's also perfectly possible that your DBA intentionally wouldn't let the database come up automatically.

This is configured in the registry:

HKLM\Software\Oracle\HomeX\ORA_<SID>_AUTOSTART=FALSE

(where 'X' is a number from 0 up if you have multiple Oracle_Homes, and 'SID' is the instance name).

Regards,

Holger Received on Mon Feb 10 2003 - 06:21:27 CST