|
Summary
Adding or removing CPUs from the HP-UX Itanium server with Oracle10g causes a database crash
You usually get the following errors in the alert log.
Detected change in CPU count to 40
Mon Feb 2 14:38:37 2009
ORA-00600: internal error code, arguments: [kskreconfignuma2], [kskcpucc], [], [], [], [], [], []
ORA-27300: OS system dependent operation:mpctl_ldomspus failed with status: 22
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: skgsnnprocs
Mon Feb 2 14:38:40 2009
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00600: internal error code, arguments: [kskreconfignuma2], [kskcpucc], [], [], [], [], [], []
ORA-27300: OS system dependent operation:mpctl_ldomspus failed with status: 22
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: skgsnnprocs
CKPT: terminating instance due to error 2097
Instance terminated by CKPT, pid = 20573
It can happen with HP-UX Itanium or Solaris.
For Oracle this issue is closed as not a bug. Per Oracle development, adding/removing processor groups are not supported. Oracle does not support dynamic reconfiguration with instance up while running on Solaris 5.9 or 10 or HP-UX Itanium
As a workaround to prevent the error and instance crash:
Only change the CPU while no instances are running.
or
Disable Oracle NUMA optimizations by setting the following in the pfile / spfile / init.ora
used to start the instances:
_enable_NUMA_optimization=FALSE
_db_block_numa=1
Other links
Numa automatically enabled after upgrade to 10.2.0.4
|
