| 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.1Information 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 > TroubleShooting' 카테고리의 다른 글
| Ora-600 [16515] Reported While Gathering Statistics (0) | 2012.04.28 |
|---|---|
| Unable To Start Instance due to ORA-7445 Dump In KSBNFY on Power Linux [ID 563895.1] (0) | 2012.04.20 |
| Memory Notification: Library Cache Object loaded into SGA (0) | 2012.03.06 |
| ora-4031 and shared pool duration (0) | 2011.12.28 |
| "Pmon Failed To Acquire Latch" Messages in Alert Log -Database Hung [ID 468740.1] (0) | 2011.12.28 |
