Hello,

Normally when I have this problem I try the follwing;

Connect as svrmgrl.
Then I use shutdown abort. After that startup again.
Startup force shut also work.
It always works for me.

Hope it helps.

Greetings,
Ben Martens





-----Original Message-----
From: Ade Bankole [mailto:[Email Address Removed] Monday, June 30, 2003 2:14 PM
To: LazyDBA.com Discussion
Subject: URGENT STARTUP PROBLEM.


Hello All,

While tring to connect to Oracle I got the following message :

SQL*Plus: Release 8.1.6.0.0 - Production on Mon Jun 30 04:53:04 2003

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter user-name: system
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

The error states that Oracle isn't up, but if I issue ps-ef, I can see that
the process for that instance are up and running :

oracle 25517 1 0 Jun 26 ? 0:21 ora_snp0_moose816
oracle 25527 1 0 Jun 26 ? 0:01 ora_d000_moose816
oracle 25519 1 0 Jun 26 ? 0:20 ora_snp1_moose816
oracle 25511 1 0 Jun 26 ? 1:35 ora_ckpt_moose816
oracle 25521 1 0 Jun 26 ? 0:19 ora_snp2_moose816
root 25067 1 0 Jun 27 ? 0:00 ./ypbind

The ipcs command shows two Oracle processes, how can I determine which is
which :

s 23263 0xd9446cf0 --ra-r----- oracle dba
s 33224 0x00003e9b --ra------- dmadmin dmadmins
s 39865 0x000059b2 --ra------- dmadmin dmadmins
s 162706 0x00006136 --ra------- dmadmin dmadmins
s 23267 0x010e6a56 --ra-r----- oracle dba


How can I resolve this problem.

Many Thanks.
Ade.

_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today!
http://www.msn.co.uk/messenger


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page