| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: hang/wait problem
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFD56A.1D1078F0
Content-Type: text/plain;
charset="iso-8859-1"
One gess is that maybe Gaja has larger head than we are, however it doesn't look like that, so maybe there is something else (what could it be? - kidding ).
Alex Hillman
-----Original Message-----
From: Jared Still [mailto:jkstill_at_bcbso.com]
Sent: Tuesday, June 13, 2000 11:54 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: hang/wait problem
Thanks Gaja.
Too many features, too many versions, and I can't keep it straight in my head as to which version has what feature.
How *do* you do it? :)
Jared
On Mon, 12 Jun 2000, Gaja Krishna Vaidyanatha wrote:
> Jared my buddy,
>
> How goes it? Please allow me to make a small modification to
> your response which says 7.x. The "warm start" feature of
> instance recovery was introduced in 7.3. The rollback is done
> after the database is opened starting in 7.3.0 and above.
>
> Cheers,
>
> Gaja.
>
>
> --- Jared Still <jkstill_at_bcbso.com> wrote:
> >
> > If the session is waiting on rollback, you will have to
> > wait it out anyway after bouncing the DB in ORacle 7.x, as
> > the rollback must complete before the DB is opened.
> >
> > Jared
> >
> > On Mon, 12 Jun 2000, Chuck Hamilton wrote:
> >
> > >
> > > I see this happen frequently. You kill a session from within
> > oracle and
> > > it doesn't go away. If the platform is unix, you might want
> > to try to kill
> > > the server process too. To get the PID use this query....
> > >
> > > select SPID from v$process p, v$session s
> > > where s.sid = '<SID_TO_KILL>' and p.addr = s.p_addr;
> > >
> > > You need to run this quest before trying to kill the session
> > though.
> > > V$PROCESS no longer holds the row for the session in
> > question after the "kill session."
> > > The only other ways to clean up "marked for kill" sessions
> > is to a) boucne the instance, or b) wait it out.
> > >
> > >
> > >
> > > Ruth Gramolini wrote:
> > >
> > > Try looking at v$lock and get the SID of the user who is
> > causing the
> > > trouble from this and check v$session for the serial# or
> > this user using
> > > the SID. Then you can issue this sql:
> > > alter system kill session 'SID,SEREAL#';Ruth B. Gramolini
> > > ORACLE & DB2 DBA
> > > VT Dept. of Taxes
> > > ph# 802.828.5708
> > > fax# 802.828..3754
> > > rgramolini_at_tax.state.vt.us
> > > to kill the user's session.
> > >
> > > HTH
> > >
> > > ----- Original Message -----
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > Sent: Friday, June 09, 2000 4:06 PM
> > >
> > >
> > > > Hello,
> > > >
> > > > I'm having a hang/wait problem with one of my systems, and
> > this is the
> > > > information I've gleaned. I want to alter a table
> > nologging:
> > > >
> > > > SVRMGR> alter table bvadmin.MR_purchased_items nologging ;
> > > >
> > > > alter table bvadmin.MR_purchased_items nologging
> > > >
> > > > *
> > > >
> > > > ORA-00054: resource busy and acquire with NOWAIT specified
> > > >
> > > >
> > > > I'm trying to kill the user I believe has the table:
> > > > 11 rows selected.
> > > >
> > > > SVRMGR> select * from v$session ;
> > > >
> > > > SADDR SID SERIAL# AUDSID PADDR USER# USERNAME
> > > >
> > > > -------- ---------- ---------- ---------- --------
> > ----------
> > > > ---------------
> > > > AB1C6328 1 1 0 AB1A1A04 0
> > > >
> > > > AB1C6B54 2 1 0 AB1A1CF4 0
> > > >
> > > > AB1C7380 3 1 0 AB1A1FE4 0
> > > >
> > > > AB1C7BAC 4 1 0 AB1A22D4 0
> > > >
> > > > AB1C83D8 5 1 0 AB1A25C4 0
> > > >
> > > > AB1C8C04 6 1 0 AB1A28B4 0
> > > >
> > > > AB1C9430 7 68 0 AB1A2BA4 0
> > > >
> > > > AB1CA488 9 348 1943952 AB1A3474 41 BVADMIN
> > > > <-------
> > > > AB1CACB4 10 15 0 AB1A2E94 0
> > > >
> > > > AB1CC538 13 8768 0 AB1A3764 0 SYS
> > > >
> > > > 10 rows selected.
> > > >
> > > >
> > > > Oracle says it's marked to kill, and has been for 15+
> > minutes (won't go
> > > > away). I'm also seeing this message in the alert log:
> > > >
> > > > Wed Jun 7 12:11:55 2000
> > > >
> > > > ORACLE Instance PETS - Can not allocate log, archival
> > required
> > > >
> > > > Wed Jun 7 12:11:55 2000
> > > >
> > > > ARCH: Connecting to console port...
> > > >
> > > > Thread 1 cannot allocate new log, sequence 6
> > > >
> > > > All online logs needed archiving
> > > >
> > > > Current log# 5 seq# 5 mem# 0:
> > > > /opt/oracle/app/oracle/oradata/PETS/log1/redoPEg
> > > > Current log# 5 seq# 5 mem# 1:
> > > > /opt/oracle/app/oracle/oradata/PETS/log2/redoPEg
> > > > Fri Jun 9 10:02:58 2000
> > > >
> > > >
> > > > Archiving is turned off (SVRMGR> ALTER SYSTEM ARCHIVE LOG
> > STOP;ORA-0250:
> > > > archiver not started .
> > > >
> > > > Is this sufficient information to tell if these messages
> > are related, and
> > > > can you recommend a course of action to 1) kill the user,
> > and 2) add
> > > another
> > > > log or turn on archiving, which would aleiviate this
> > problem?
> > > >
> > > > I tried to shutdown immediate, but it hung for 20+ minutes
> > before I
> > > > cancelled the shutdown.
> > > >
> > > > Any information is appreciated.
> > > >
> > > > Best regards, and thanks for the help.
> > > >
> > > > Linda
> > > >
> > > > --
> > > > Author: Linda Hagedorn
> > > > INET: Linda_at_pets.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).
> > > >
> > >
> > > --
> > > 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).
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Do You Yahoo!?
> > > Yahoo! Photos -- now, 100 FREE prints!
> >
> >
> > Jared Still
> > Certified Oracle DBA and Part Time Perl Evangelist ;-)
> > Regence BlueCross BlueShield of Oregon
> > jkstill_at_bcbso.com - Work - preferred address
> > jkstill_at_teleport.com - private
> >
> >
> > --
> > Author: Jared Still
> > INET: jkstill_at_bcbso.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).
>
>
> =====
> Gaja Krishna Vaidyanatha | 3460 West Bayshore Road,
> Manager - Integration | Palo Alto, CA 94303
> & Consulting Services | gaja_at_brio.com
> Global Alliances | (650)-565-4442
> Brio Technology | www.brio.com
>
> "Opinions and views expressed are my own and not of Brio Technology"
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
> --
> Author: Gaja Krishna Vaidyanatha
> INET: gajav_at_yahoo.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).
>
Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-)
Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address
jkstill_at_teleport.com - private
-- Author: Jared Still INET: jkstill_at_bcbso.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). ------_=_NextPart_001_01BFD56A.1D1078F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: hang/wait problem </TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>One gess is that maybe Gaja has larger head than we = are, however it doesn't look like that, so maybe there is something = else (what could it be? - kidding ).</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Jared Still [<A = HREF=3D"mailto:jkstill_at_bcbso.com">mailto:jkstill_at_bcbso.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, June 13, 2000 11:54 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: hang/wait problem </FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>Thanks Gaja.</FONT> </P> <P><FONT SIZE=3D2>Too many features, too many versions, and I = can't</FONT> <BR><FONT SIZE=3D2>keep it straight in my head as to which = version</FONT> <BR><FONT SIZE=3D2>has what feature.</FONT> </P> <P><FONT SIZE=3D2>How *do* you do it? :)</FONT> </P> <P><FONT SIZE=3D2>Jared</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>On Mon, 12 Jun 2000, Gaja Krishna Vaidyanatha = wrote:</FONT> </P> <P><FONT SIZE=3D2>> Jared my buddy,</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> How goes it? Please allow me to make a = small modification to</FONT> <BR><FONT SIZE=3D2>> your response which says 7.x. The = "warm start" feature of</FONT> <BR><FONT SIZE=3D2>> instance recovery was introduced in 7.3. = The rollback is done</FONT> <BR><FONT SIZE=3D2>> after the database is opened starting in 7.3.0 = and above.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Cheers,</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Gaja.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> --- Jared Still <jkstill_at_bcbso.com> = wrote:</FONT> <BR><FONT SIZE=3D2>> > </FONT> <BR><FONT SIZE=3D2>> > If the session is waiting on rollback, you = will have to</FONT> <BR><FONT SIZE=3D2>> > wait it out anyway after bouncing the DB = in ORacle 7.x, as</FONT> <BR><FONT SIZE=3D2>> > the rollback must complete before the DB = is opened.</FONT> <BR><FONT SIZE=3D2>> > </FONT> <BR><FONT SIZE=3D2>> > Jared</FONT> <BR><FONT SIZE=3D2>> > </FONT> <BR><FONT SIZE=3D2>> > On Mon, 12 Jun 2000, Chuck Hamilton = wrote:</FONT> <BR><FONT SIZE=3D2>> > </FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > I see this happen frequently. You = kill a session from within</FONT> <BR><FONT SIZE=3D2>> > oracle and </FONT> <BR><FONT SIZE=3D2>> > > it doesn't go away. If the platform = is unix, you might want</FONT> <BR><FONT SIZE=3D2>> > to try to kill </FONT> <BR><FONT SIZE=3D2>> > > the server process too. To get the = PID use this query....</FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > select SPID from v$process p, = v$session s</FONT> <BR><FONT SIZE=3D2>> > > where s.sid =3D '<SID_TO_KILL>' = and p.addr =3D s.p_addr;</FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > You need to run this quest before = trying to kill the session</FONT> <BR><FONT SIZE=3D2>> > though. </FONT> <BR><FONT SIZE=3D2>> > > V$PROCESS no longer holds the row for = the session in</FONT> <BR><FONT SIZE=3D2>> > question after the "kill = session." </FONT> <BR><FONT SIZE=3D2>> > > The only other ways to clean up = "marked for kill" sessions</FONT> <BR><FONT SIZE=3D2>> > is to a) boucne the instance, or b) wait = it out.</FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > Ruth Gramolini wrote: </FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > Try looking at v$lock and get the SID = of the user who is</FONT> <BR><FONT SIZE=3D2>> > causing the</FONT> <BR><FONT SIZE=3D2>> > > trouble from this and check v$session = for the serial# or</FONT> <BR><FONT SIZE=3D2>> > this user using</FONT> <BR><FONT SIZE=3D2>> > > the SID. Then you can issue this = sql:</FONT> <BR><FONT SIZE=3D2>> > > alter system kill session = 'SID,SEREAL#';Ruth B. Gramolini</FONT> <BR><FONT SIZE=3D2>> > > ORACLE & DB2 DBA</FONT> <BR><FONT SIZE=3D2>> > > VT Dept. of Taxes</FONT> <BR><FONT SIZE=3D2>> > > ph# 802.828.5708</FONT> <BR><FONT SIZE=3D2>> > > fax# 802.828..3754</FONT> <BR><FONT SIZE=3D2>> > > rgramolini_at_tax.state.vt.us</FONT> <BR><FONT SIZE=3D2>> > > to kill the user's session.</FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > HTH</FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > ----- Original Message -----</FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > To: Multiple recipients of list = ORACLE-L </FONT> <BR><FONT SIZE=3D2>> > > Sent: Friday, June 09, 2000 4:06 = PM</FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > > Hello,</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > I'm having a hang/wait problem = with one of my systems, and</FONT> <BR><FONT SIZE=3D2>> > this is the</FONT> <BR><FONT SIZE=3D2>> > > > information I've gleaned. I want = to alter a table</FONT> <BR><FONT SIZE=3D2>> > nologging:</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > SVRMGR> alter table = bvadmin.MR_purchased_items nologging ;</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > alter table = bvadmin.MR_purchased_items nologging</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > *</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > ORA-00054: resource busy and = acquire with NOWAIT specified</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > I'm trying to kill the user I = believe has the table:</FONT> <BR><FONT SIZE=3D2>> > > > 11 rows selected.</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > SVRMGR> select * from = v$session ;</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > SADDR SID SERIAL# AUDSID PADDR = USER# USERNAME</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > -------- ---------- ---------- = ---------- --------</FONT> <BR><FONT SIZE=3D2>> > ----------</FONT> <BR><FONT SIZE=3D2>> > > > ---------------</FONT> <BR><FONT SIZE=3D2>> > > > AB1C6328 1 1 0 AB1A1A04 0</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > AB1C6B54 2 1 0 AB1A1CF4 0</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > AB1C7380 3 1 0 AB1A1FE4 0</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > AB1C7BAC 4 1 0 AB1A22D4 0</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > AB1C83D8 5 1 0 AB1A25C4 0</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > AB1C8C04 6 1 0 AB1A28B4 0</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > AB1C9430 7 68 0 AB1A2BA4 = 0</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > AB1CA488 9 348 1943952 AB1A3474 = 41 BVADMIN</FONT> <BR><FONT SIZE=3D2>> > > > <-------</FONT> <BR><FONT SIZE=3D2>> > > > AB1CACB4 10 15 0 AB1A2E94 = 0</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > AB1CC538 13 8768 0 AB1A3764 0 = SYS</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > 10 rows selected.</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Oracle says it's marked to kill, = and has been for 15+</FONT> <BR><FONT SIZE=3D2>> > minutes (won't go</FONT> <BR><FONT SIZE=3D2>> > > > away). I'm also seeing this = message in the alert log:</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Wed Jun 7 12:11:55 2000</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > ORACLE Instance PETS - Can not = allocate log, archival</FONT> <BR><FONT SIZE=3D2>> > required</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Wed Jun 7 12:11:55 2000</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > ARCH: Connecting to console = port...</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Thread 1 cannot allocate new = log, sequence 6</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > All online logs needed = archiving</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Current log# 5 seq# 5 mem# = 0:</FONT> <BR><FONT SIZE=3D2>> > > > = /opt/oracle/app/oracle/oradata/PETS/log1/redoPEg</FONT> <BR><FONT SIZE=3D2>> > > > Current log# 5 seq# 5 mem# = 1:</FONT> <BR><FONT SIZE=3D2>> > > > = /opt/oracle/app/oracle/oradata/PETS/log2/redoPEg</FONT> <BR><FONT SIZE=3D2>> > > > Fri Jun 9 10:02:58 2000</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Archiving is turned off = (SVRMGR> ALTER SYSTEM ARCHIVE LOG</FONT> <BR><FONT SIZE=3D2>> > STOP;ORA-0250:</FONT> <BR><FONT SIZE=3D2>> > > > archiver not started .</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Is this sufficient information = to tell if these messages</FONT> <BR><FONT SIZE=3D2>> > are related, and</FONT> <BR><FONT SIZE=3D2>> > > > can you recommend a course of = action to 1) kill the user,</FONT> <BR><FONT SIZE=3D2>> > and 2) add</FONT> <BR><FONT SIZE=3D2>> > > another</FONT> <BR><FONT SIZE=3D2>> > > > log or turn on archiving, which = would aleiviate this</FONT> <BR><FONT SIZE=3D2>> > problem?</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > I tried to shutdown immediate, = but it hung for 20+ minutes</FONT> <BR><FONT SIZE=3D2>> > before I</FONT> <BR><FONT SIZE=3D2>> > > > cancelled the shutdown.</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Any information is = appreciated.</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Best regards, and thanks for the = help.</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Linda</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > --</FONT> <BR><FONT SIZE=3D2>> > > > Author: Linda Hagedorn</FONT> <BR><FONT SIZE=3D2>> > > > INET: Linda_at_pets.com</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Fat City Network Services -- = (858) 538-5051 FAX: (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > > > San Diego, California -- Public = Internet access / Mailing</FONT> <BR><FONT SIZE=3D2>> > Lists</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > > > To REMOVE yourself from this = mailing list, send an E-Mail</FONT> <BR><FONT SIZE=3D2>> > message</FONT> <BR><FONT SIZE=3D2>> > > > to: ListGuru_at_fatcity.com (note = EXACT spelling of</FONT> <BR><FONT SIZE=3D2>> > 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> > > > the message BODY, include a line = containing: UNSUB</FONT> <BR><FONT SIZE=3D2>> > ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > > (or the name of mailing list you = want to be removed from).</FONT> <BR><FONT SIZE=3D2>> > You may</FONT> <BR><FONT SIZE=3D2>> > > > also send the HELP command for = other information (like</FONT> <BR><FONT SIZE=3D2>> > subscribing).</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > -- </FONT> <BR><FONT SIZE=3D2>> > > Author: Ruth Gramolini</FONT> <BR><FONT SIZE=3D2>> > > INET: = rgramolini_at_tax.state.vt.us</FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > Fat City Network Services -- (858) = 538-5051 FAX: (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > > San Diego, California -- Public = Internet access / Mailing</FONT> <BR><FONT SIZE=3D2>> > Lists</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > > To REMOVE yourself from this mailing = list, send an E-Mail</FONT> <BR><FONT SIZE=3D2>> > message</FONT> <BR><FONT SIZE=3D2>> > > to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru')</FONT> <BR><FONT SIZE=3D2>> > and in</FONT> <BR><FONT SIZE=3D2>> > > the message BODY, include a line = containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > (or the name of mailing list you want = to be removed from).</FONT> <BR><FONT SIZE=3D2>> > You may</FONT> <BR><FONT SIZE=3D2>> > > also send the HELP command for other = information (like</FONT> <BR><FONT SIZE=3D2>> > subscribing). </FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > </FONT> <BR><FONT SIZE=3D2>> > > = ---------------------------------</FONT> <BR><FONT SIZE=3D2>> > > Do You Yahoo!?</FONT> <BR><FONT SIZE=3D2>> > > Yahoo! Photos -- now, 100 FREE = prints!</FONT> <BR><FONT SIZE=3D2>> > </FONT> <BR><FONT SIZE=3D2>> > </FONT> <BR><FONT SIZE=3D2>> > Jared Still</FONT> <BR><FONT SIZE=3D2>> > Certified Oracle DBA and Part Time Perl = Evangelist ;-)</FONT> <BR><FONT SIZE=3D2>> > Regence BlueCross BlueShield of = Oregon</FONT> <BR><FONT SIZE=3D2>> > jkstill_at_bcbso.com - Work - preferred = address</FONT> <BR><FONT SIZE=3D2>> > jkstill_at_teleport.com - private</FONT> <BR><FONT SIZE=3D2>> > </FONT> <BR><FONT SIZE=3D2>> > </FONT> <BR><FONT SIZE=3D2>> > -- </FONT> <BR><FONT SIZE=3D2>> > Author: Jared Still</FONT> <BR><FONT SIZE=3D2>> > INET: jkstill_at_bcbso.com</FONT> <BR><FONT SIZE=3D2>> > </FONT> <BR><FONT SIZE=3D2>> > Fat City Network = Services -- (858) 538-5051 FAX: (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > San Diego, = California -- Public Internet = access /</FONT> <BR><FONT SIZE=3D2>> > Mailing Lists</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > To REMOVE yourself from this mailing list, = send an E-Mail</FONT> <BR><FONT SIZE=3D2>> > message</FONT> <BR><FONT SIZE=3D2>> > to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru')</FONT> <BR><FONT SIZE=3D2>> > and in</FONT> <BR><FONT SIZE=3D2>> > the message BODY, include a line = containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > (or the name of mailing list you want to = be removed from). </FONT> <BR><FONT SIZE=3D2>> > You may</FONT> <BR><FONT SIZE=3D2>> > also send the HELP command for other = information (like</FONT> <BR><FONT SIZE=3D2>> subscribing).</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> =3D=3D=3D=3D=3D</FONT> <BR><FONT SIZE=3D2>> Gaja Krishna Vaidyanatha | 3460 = West Bayshore Road,</FONT> <BR><FONT SIZE=3D2>> Manager - = Integration | Palo Alto, CA 94303</FONT> <BR><FONT SIZE=3D2>> & Consulting = Services | gaja_at_brio.com</FONT> <BR><FONT SIZE=3D2>> Global = Alliances | = (650)-565-4442</FONT> <BR><FONT SIZE=3D2>> Brio = Technology &n= bsp; | www.brio.com </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> "Opinions and views expressed are my own = and not of Brio Technology"</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> = __________________________________________________</FONT> <BR><FONT SIZE=3D2>> Do You Yahoo!?</FONT> <BR><FONT SIZE=3D2>> Yahoo! Photos -- now, 100 FREE prints!</FONT> <BR><FONT SIZE=3D2>> <A HREF=3D"http://photos.yahoo.com" = TARGET=3D"_blank">http://photos.yahoo.com</A></FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Author: Gaja Krishna Vaidyanatha</FONT> <BR><FONT SIZE=3D2>> INET: gajav_at_yahoo.com</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>> </FONT> </P> <BR> <P><FONT SIZE=3D2>Jared Still</FONT> <BR><FONT SIZE=3D2>Certified Oracle DBA and Part Time Perl = Evangelist ;-)</FONT> <BR><FONT SIZE=3D2>Regence BlueCross BlueShield of Oregon</FONT> <BR><FONT SIZE=3D2>jkstill_at_bcbso.com - Work - preferred address</FONT> <BR><FONT SIZE=3D2>jkstill_at_teleport.com - private</FONT> </P> <BR> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Jared Still</FONT> <BR><FONT SIZE=3D2> INET: jkstill_at_bcbso.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, =Received on Tue Jun 13 2000 - 14:03:51 CDT
 |
 |