2011. 7. 19. 07:59 오라클
ORA-48178 / ORA-48122 / ORA-27037/ HPUX-ia64 Error 251 while reading ADR file after upgraded to 11.2.0.2
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.2HP-UX Itanium
Symptoms
On HP-UX ItaniumAfter upgrade database from 11.2.0.1 to 11.2.0.2.
All V_$DIAG views are INVALID except V_$DIAG_AMS_XACTION and V_$DIAG_INFO.
ORA-942 reported on recompiling these invalid views.
ORA-942 was already reported on the same in the upgrade log file while running 'Catadrvw'.
When starting the instance, following messages are seen:
Error with dbgriap_init_adr_pga: 48178
ORA-48178: error encountered while reading an ADR block file during ADR initialization [/home/oracle/oraHome112/diag/rdbms/nora/nora/metadata/ADR_INTERNAL.mif]
ORA-48122: error with opening the ADR block file [/home/oracle/oraHome112/diag/rdbms/nora/nora/metadata/ADR_INTERNAL.mif] [0]
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 251: Function is not available
Additional information: 46Changes
Upgrade to 11.2.0.2 on HP-UX ItaniumCause
Bug 10302203: ORA-942 REPORTED WHEN COMPILING V_$DIAG VIEWS
As from 11.2.0.2, the file 'ADR_INTERNAL.mif' is opened with HP-UX directio code using
VX_SETCACHE (Set caching advisories) which is only available with the HP OnLineJFS product.
This issue happens when the HP OnLineJFS product is not installed !
Can be verified with:
usr/sbin/swlist -l product | grep -i vxfsIf HP OnLineJFS is installed it will give following output:
JFS B.11.31 Base VxFS File System 4.1 for HP-UX
OnlineJFS B.11.31 Online features of the VxFS File SystemSolution
Bug 10302203 is resolved in release 12.1 and patchset 11.2.0.3 (not available at the time of creation of this article.)
A one-off patch 10302203 is available for 11.2.0.2 on HP-UX Itanium and can be downloaded at MOS.
Workarounds:
1. Install the HP OnLineJFS product
-OR-
2. Set init.ora parameter _DIAG_ADR_ENABLED to FALSE
ADR is disabled and all tracing goes to $ORACLE_HOME/rdbms/log
