| 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: Shutdown immediate hangs.
To get the status on the Intelligent Agent:
lsnrctl dbsnmp_status
To stop:
lsnrctl dbsnmp_stop
To start:
lsnrctl dbsnmp_start
Also, you can check for the data gatherer process: vppcntl
Thanks
G!
--- "Khushalani, Vikram" <vkhushalani_at_grci.com> wrote:
> Lee,
>
> We had a similar problem (NT Platform) with one of
> our databases and
> discovered that it was the Intelligent Agent (as
> Eric Lansu also mentioned)
> which prevented the shutdown. We then started to
> stop the Intelligent Agent
> Service before shutting down the database, and
> restarting it after our
> backups were completed and the database was
> re-started. This resolved the
> problem.
>
> HTH
> Vikram Khushalani
> Oracle DBA
>
>
> -----Original Message-----
> Sent: Friday, October 13, 2000 7:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
> The database won't go down if there is an
> Intelligent Agent or some process
> like this running. The easiest way to shutdown is
> with abort etc...
>
> Eric Lansu
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Friday, 13 October 2000 11:40
>
>
> > Lee,
> >
> > We had some similar problems. Over here they were
> caused by stored
> > procedures that were being executed and hadn't
> finished before the
> Shutdown
> > Immediate.
> >
> > We decided to do a shutdown abort, startup again,
> and then issue the
> > shutdown immediate. It was the only way for us to
> assure the DB would be
> > shut down at the time we wanted.
> >
> > Greets,
> >
> > Kirsten
> >
> > > -----Original Message-----
> > > From: lerobe - Lee Robertson
> [SMTP:LEROBE_at_acxiom.co.uk]
> > > Sent: Friday, October 13, 2000 10:10 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Shutdown immediate hangs.
> > >
> > > All,
> > >
> > > Last night our backups were not able to kick in
> as the shutdowns did not
> > > work. The trace file shows the following
> > >
> > > *** SESSION ID:(25.43498)
> 2000.10.12.18.08.57.034
> > > SHUTDOWN: waiting for active calls to complete.
> > > *** 2000.10.12.18.13.59.069
> > > SHUTDOWN: waiting for active calls to complete.
> > > *** 2000.10.12.18.19.01.069
> > > SHUTDOWN: waiting for active calls to complete.
> > >
> > > This goes on for sometime until a shutdown abort
> is issued. Am i right
> in
> > > assuming that the DB is attempting to rollback
> active transactions
> before
> > > shutting down or is there something else causing
> this. I am new at this
> > > place and apparently they say this has never
> happened before.
> > >
> > > Anyone seen this ??
> > >
> > > Lee
> > >
> > > > Lee Robertson
> > > > Acxiom
> > > > Tel: 0191 525 7344
> > > > Fax: 0191 525 7007
> > > > Email: lerobe_at_acxiom.co.uk
> > > >
> > > >
> > >
> > >
> > > The information contained in this communication
> is
> > > confidential, is intended only for the use of
> the recipient
> > > named above, and may be legally privileged. If
> the reader
> > > of this message is not the intended recipient,
> you are
> > > hereby notified that any dissemination,
> distribution or
> > > copying of this communication is strictly
> prohibited.
> > > If you have received this communication in
> error, please
> > > re-send this communication to the sender and
> delete the
> > > original message or any copy of it from your
> computer
> > > system.
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: lerobe - Lee Robertson
> > > INET: LEROBE_at_acxiom.co.uk
> > >
> > > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > > San Diego, California -- Public Internet
> access / Mailing Lists
> > >
>
 |
 |