Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Cannot start database (already running)

Cannot start database (already running)

From: Baker, Barbara <bbaker_at_denvernewspaperagency.com>
Date: Wed, 21 Aug 2002 10:33:56 -0800
Message-ID: <F001.004BB857.20020821103356@fatcity.com>

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). Received on Wed Aug 21 2002 - 13:33:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US