Marius Dreyer (dreyerm@iafrica.com) wrote:
: Hi everyone !
:
: Has any ever done a shutdown immediate which did not shut down at all ?
: I know that if there is a long running transaction, it will take a while to
: rollback, but what if there is none ?
: Running 7.3.3 on Sun Solaris 2.51.
:
: Thanks in advance
: Marius
:
: /* Africa is not for sissies */
Marius,
If someone is in the login process, then "shutdown immediate" will not
work, and will hang. Eventually, you will see a trace file saying "waiting
for logins to complete". For example, try issuing sqlplus, but when it
prompts you for a username/password, do not enter anything. Open another
window and try "shutdown immediate". You will see that Oracle will not
shut down.
You will either have to shutdown abort, or have a program kill all oracle
connections and then to a shutdown immediate.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 132+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page