Ora-600 [Unable To Load Xdb Library] in AIX [ID 559911.1]

Ora-600 [Unable To Load Xdb Library] in AIX [ID 559911.1]
		수정 날짜 28-FEB-2012     유형 PROBLEM     상태 PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.
Checked for relevance on 28-Feb-1011

Symptoms

SQL> SELECT 'drop public synonym '||a.synonym_name||';' FROM all_synonyms a
WHERE a.owner = 'PUBLIC' AND a.table_owner in ('HOB', 'SCRUBBER')
AND not exists (SELECT null FROM all_objects b WHERE b.
object_name = a.table_name AND b.object_type <> 'SYNONYM');

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Errors in file /bendbsq2/oracle/admin/BEUA/udump/beua_ora_2924594.trc:
ORA-00600: internal error code, arguments: [unable to load XDB library], [], [],
[], [], [], [], []

Cause

The libxdb.so library could not be found

$ORACLE_HOME/lib and $ORACLE_HOME/lib32 need to be included in the LIBPATH environmental variable

Solution

Please follow step by step this instructions to fix the unable to load the XDB
library error:


1. Stop the database and stop the listener.

2. Set LIBPATH so the first directory referenced is $ORACLE_HOME/lib
Example (replace $ORACLE_HOME with the full path of the Oracle home directory):

csh:

setenv LIBPATH $ORACLE_HOME/lib:<other paths>

ksh:

export LIBPATH=$ORACLE_HOME/lib:<other paths>

Make sure $ORACLE_HOME/lib is first.

3. run /usr/sbin/slibclean as root

4. Re-start the database and the listener.

If the database is in a RAC configuration, the database is started with srvctl and the variable has to be set in the OCR for the database resource. See Note 733567.1

---

References

NOTE:733567.1 - Setting Environment Variables Through Srvctl

관련 자료 제품 Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition 오류 ORA-600[UNABLE TO LOAD XDB LIBRARY]; ORA-3113