Re: oracle not coming up

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 7 Feb 2003 19:40:54 -0000
Message-ID: <3e4421e5_3@mk-nntp-1.news.uk.worldonline.com>

"SP" <sdpantDelete_this_to_reply_at_yahoo.com> wrote in message news:y4S0a.887$8Z5.14547_at_sea-read.news.verio.net...
> 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
>

The listener may be up by now, but the database instance is not started.

If you know the SID, and have an admin/dba account, go to a command prompt and set it, then type sqlplus "/ as sysdba" then startup, like so (this is 9i on XP but 8i on W2K should be the same):

G:\Documents and Settings\Dad\Documents>set ORACLE_SID=DAD

G:\Documents and Settings\Dad\Documents>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 7 19:37:50 2003

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes

Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes

Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

G:\Documents and Settings\Dad\Documents>

Hope this helps,
Regards,
Paul Received on Fri Feb 07 2003 - 13:40:54 CST