Re: URGENT STARTUP PROBLEM.

Re: URGENT STARTUP PROBLEM.

 

  

As martin says do a shutdown abort. Then check the shared memory and
semaphores-

ipcs -omb #shared memory
ipcs -s #semaphores

if there is any oracle process running then remove them by

ipcrm -m
ipcrm -s

after that you do normal startup it should work fine

lemme me if you still having problem starting up

Regards
Kavi


----- Original Message -----
From: "MARTENS, Ben" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Monday, June 30, 2003 8:18 PM
Subject: RE: URGENT STARTUP PROBLEM.


> 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] Sent: 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] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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