Re: Oracle Server Manager

Newsgroups: comp.databases.oracle.misc
Subject: Re: Oracle Server Manager
References: <32F9E4B7.FB6_at_hpbbn.bbn.hp.com>

There are only a few reasons why the Oracle database will not "shutdown immediate". First, if a user is in the process of logging in, the database will wait for "logins to complete." For example, this will happen if someone types "sqlplus" and leaves the computer at the "Username:" prompt.

Also, some "zombie" UNIX processes will hold the database up. Otherwise, you have an Oracle bug and should contact support.

The first thing that you should investigate is for any trace files in the bdump, cdump, udump directories. The alert_{SID}.log could also have the reason included.

Good luck to you,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: http://homepage.interaccess.com/~akaplan   <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

 Werner Menges
<wernerm_at_hpbbn.bbn.hp.com> writes:

>Hi all,
 

> I tried to shutdown a running database with the
> ServerManager svrmgrl (line mode tool) but it
> was only possible to stop the database with 'shutdown abort'.
 

> No other db client had connected the database and it's also
> impossible to stop with 'shutdown immediate".
 

> Our database version is 7.3.2.2.
 

> I would appreciate for any help?
> Thanks in advance.
 

>Regards
> Werner
Received on Thu Feb 06 1997 - 00:00:00 CST