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
Received on Tue Jun 13 2000 - 09:30:08 CDT