Re: Cannot start database (already running)

Did you try shutdown abort? That should do it. But remember to startup restrict, shutdown normal, startup to allow smon to do his thing.

HTH<
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, August 21, 2002 2:33 PM

>
> Oracle 8.0.5
> Solaris 2.6
> HA Cluster 2.1
>
> This is wacky.
> Any ideas on this one (other than reboot the box)???
> I cannot start up this database (claims it's already running).
> Clearly it is not. No background processes for this instance. The only
> process I see even remotely related to this database is the oracledesi
> process. (I don't know what that process is.)
>
> I do have a semaphore set for oracle. Should I remove it? (I normally
have
> other databases on this box, but I've shut them all down.)
>
> This database worked fine till a network device was ripped out from under
> it, and the HA stuff kicked in and failed it over.
>
> Any ideas? Thanks for any help
>
> Barb
>
> atex-tad3> ps -ef | grep pmon
> oracle 1604 23498 0 11:16:54 pts/3 0:00 grep pmon
>
> atex-tad3> ps -ef | grep -i desi
> oracle 17319 1 0 Aug 15 ? 0:00 oracledesi (LOCAL=NO)
> oracle 1621 23498 0 11:17:02 pts/3 0:00 grep -i desi
>
> atex-tad3> svrmgrl
> Oracle Server Manager Release 3.0.5.0.0 - Production
> Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.5.2.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> ORA-01081: cannot start already-running ORACLE - shut it down first
>
> atex-tad3> ipcs -b
> IPC status from <running system> as of Wed Aug 21 11:28:38 2002
> Message Queue facility not in system.
> T ID KEY MODE OWNER GROUP SEGSZ
> Shared Memory:
> m 0 0x50000e45 --rw-r--r-- root root 68
> m 1 0x2de8bf84 --rw-r----- oracle dba 43458560
> m 202 0x00280267 --rw-r--r-- root root 1048576
> T ID KEY MODE OWNER GROUP NSEMS
> Semaphores:
> s 0 00000000 --ra-r----- oracle dba 100
> s 327681 0x00280269 --ra-ra-ra- root root 14
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Baker, Barbara
> INET: bbaker_at_denvernewspaperagency.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).