RE: Error Message - Database is Already Up

I always use a shutdown abort to clean up oracle sga files and processes.

>>> VIVEK_SHARMA_at_infy.com 05/29/01 04:10AM >>> Unal

NOTE - sgadef$ORACLE_SID.dbf Files Existed in $ORACLE_HOME/dbs Dir

Upon Receipt of This Error "Database is Already Up . Shut it Down First" we MOVED the sgadef$ORACLE_SID.dbf Files to a Temporary SUB-Dir under $ORACLE_HOME/dbs Dir

Upon RE-Initiating the Oracle Installation We Still GOT The SAME Error

SOLUTION - The sgadef$ORACLE_SID.dbf Files Should NOT Exist Under $ORACLE_HOME/dbs Dir NOR in Any SUB-Dir Under the SAME.

Thanks Again so Much Unal , List

> -----Original Message-----
> From: Danisment Gazi Unal (Unal Bilisim)
> [SMTP:danisment.unal_at_unal-bilisim.com]
> Sent: Tuesday, May 29, 2001 5:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Error Message - Database is Already Up
>
> Hello Vivek,
>
> Check followings:
>
> - If I'm not wrong there should be lk* file 7.3.3 and onwards. remove
> it.
> - check shared memory/semaphores by ipcs. if They still exist, remove
> them
> by ipcrm
>
> if problem still exist, you are most probably hitting a bug.
>
> - debug your process by truss/trace in OS system call level. check
> last
> lines of truss/trace output. I'm not sure last system call is flushed
> to
> file. check it.
> - set event="<error code> trace name errorstack forever, level 10" in
> init.ora. re-produce error. then send us trace file created under
> udump.
>
> regards...
>
>
>
> VIVEK_SHARMA wrote:
>
> > After Installing Additionally Only the PQO Component of ORA 7.3.4.5
> ,
> > When Finally Attempting to RE-Link the Oracle Exe , Following Error
> > Message ( of sorts ) is Displayed :-
> >
> > Database is Already Up . Shut it Down First .
> >
> > Hence Re-Link of Oracle Exe Failing
> >
> > NOTE -
> > 1) NO Database whatsoever is UP
> > 2) ORACLE_SID is NOT Set to Any Value
> > 3) NO sgadef$ORACLE_SID File Exists in $ORACLE_HOME/dbs Dir
> > 4) NO $ORACLE_SID_struct File Exists in $ORACLE_HOME/dbs Dir
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: VIVEK_SHARMA
> > INET: VIVEK_SHARMA_at_infy.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: Danisment Gazi Unal (Unal Bilisim)
> INET: danisment.unal_at_unal-bilisim.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: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infy.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: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.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).