RE: Error Message - Database is Already Up
I always use a shutdown abort to clean up oracle sga files and processes. >>> [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] > 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=" 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Error Message - Database is Already Up
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:[EMAIL PROTECTED]] > 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=" 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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=" 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).