Oracle process cannot be stopped during halt of package

[Paul Barmettler]

HP-UX 11.23 (IA64)
Installed versions of SG:
B5140BA A.11.23.05 Serviceguard NFS Toolkit
T1905BA A.11.17.00 Serviceguard
T2803BA B.04.01 Serviceguard Extension for SAP

While halting the package the process oracle cannot be stopped.
Get following message in log-file of package:
Oct 31 19:38:11 - Node "infhp150": (ora_wait): Wait for Oracle shadow process cleanup (Timeout: 200 secs)
Oct 31 19:38:11 - Node "infhp150": (ora_wait): 6869 ? 00:00 oraclePE2
Oct 31 19:48:24 - Node "infhp150": (ora_wait): WARNING: Failed. Archiver stuck?

Any idea how to solve?

With kind regards

Paul

[Steven E. Protter]

Shalom,

The dbshut program from Oracle ships broken.

Where it says shutdown should be changed to shutdown immediate.

This will probably fix the problem.

SEP

[spex]

Hi,

umount: cannot unmount /oracle/PE2 : Device busy
umount: return error 1.
WARNING: Running fuser to remove anyone using the file system directly.
/dev/PE2vg10/lvol1: 6865m(pe2adm) 6869mcto(orape2)

There is a file still open on /oracle/PE2, which appears to be your $ORACLE_BASE and $SAPDATA_HOME. The file is open (o) by pid 6865 in the current dir (c), login name orape2, and is memory mapped (m), as well as a text file (t).

Oct 31 19:38:11 - Node "infhp150": (ora_wait): 6869 ? 00:00 oraclePE2
Oct 31 19:48:24 - Node "infhp150": (ora_wait): WARNING: Failed. Archiver stuck?

This error tells us the archiver background process is hung. You could try to force a logswitch and stop the archiver process:

SQL> ALTER SYSTEM SWITCH LOGFILE;
SQL> ALTER SYSTEM ARCHIVE LOG STOP;
SQL> SHUTDOWN IMMEDIATE;

But you may end up needing to kill the process. First try from within Oracle:

SQL> SELECT * FROM V$SESSION;
SQL> ALTER SYSTEM KILL SESSION 'SESSION-ID,SESSION-SERIAL#';

And if that doesn't work, from the OS:

# kill 6869

PCS

[Paul Barmettler]

Where in ServiceGuard Extension for SAP do I have to put "shutdown immediate"?

With kind regards

Paul

[spex]

Hi Paul,

# su - ora
$ echo $ORACLE_SID
$ sqlplus /nolog
SQL> CONNECT / AS SYSDBA;

PCS

[Paul Barmettler]

No solution found.