Oracle shutdown immediate hangs with MC/SG on HP-UX 11.00

[Rui Vilao]

Greetings,

I have a problem which only occurs with HP-UX11.00 and MC/SG A.11.12 and Oracle 7.3.4 (..).


Whithin my control script dbshut (with shutdown immediate) hangs.
the same script works perfectly well with HP-UX 10.20...

With shudown abort it works...

Does anyone have a solution for this that avoids
the usage of shutdown abort???

Any help is apreciated,

Kind Regards,

Rui.

[Alexander M. Ermes]

Hi there.
Did you check, whether there were any processes still running on the database ?
This hangup might appear, if you have processes still running at the time of the database shutdown.
Shutdown immediate is a shutdown, which does not allow any new logins, but it will let processes finish before going down.
Rgds
Alexander M. Ermes

[Thierry Poels_1]

uh? Alexander?
"Shutdown immediate is a shutdown, which does not allow any new logins, but it will let processes finish before going down."


shutdown NORMAL : blocks new logins, and waits until all processes have exited before shutting down.

shutdown IMMEDIATE : blocks new logins, and aborts all running processes and performs a clean rollback. This rollback can however take a while!

shutdown ABORT : instant full stop of the database; rollback/recovery of the aborted sessions will be done at database startup.



Rui,
are you sure a 'shutdown immediate' is issued? Check alert.log, check db activity after shutdown is issued, does the script work when issued manually? , ...

good luck,
Thierry.

[T G Manikandan]

Hello,
Just wait for your shutdown immediate to work.
First check using the shutdown immediate to work on the svrmgrl prompt.
Then try it on the script.Please post the script !
It may also take around 5 minutes.
Just wait for the shutdown immediate to work.
Also check your alert log.

[Duncan Edmonstone]

The point about shutdown immediate is that it will kick out *any* users currently logged in. This means that any transactions taking place which have not been completed must be rolled back, and this can take several minutes (I've even seen it take 30 minutes on a large data warehouse batch process).

However, if your saying that this was not a problem at 10.20, it should still not be a problem at 11.00 (although I think Oracle don't offer the full support package for 7.3.4 on HP-UX11 - you should look to upgrade to 8i) - Has anything else apart from the OS changed?

Duncan

[Printaporn_1]

Hi,

shutdown immediate will wait for all current session ended , please check current sessions from v$sessions , also plese don't use shutdown abort , you will need media recovery.

[Rui Vilao]

Hi,

Thanks to all for your advice.

The problem seems to me to be related to SG...
Outside my control file, the database shutdown does not hang! Inside the control file it hangs!

I have the same problem with OV DM daemons...
ovstart -v hangs inside the control file.
Outside the control file it works!

any sugestion is welcome.

regards,
Rui

[Sanjay_6]

Hi Rui,

This should be a silly question. But is hope you are trying to shutdown the database using the oracle id. Or at least your test outside the control script and inside the control script is done using the same user id. The control script runs all the commands with the superuser id. Also are there any messages logged to the packge log file or the oracle log files.

Hope this helps.

Regds

[Rui Vilao]

Hi,

I am doing (like I always did...) with the control file:

...
su oracle -c ${ORACLE_HOME}/bin/svrmgrl <connect internal
shutdown immediate
EOF

...

TIA,

Rui

[Rui Vilao]

Hi all,

Just for the record, this problem is solved by applying the patch: PHSS_24537

Best Regards,

Rui