EXP-00056: ORACLE error 600 encountered 解決方法

/*
*時間：2009-05-11 Monday
*環境：AIX5.3  Oracle10.2.0.1.0
*標題：EXP-00056: ORACLE error 600 encountered 解決方法
*/
用exp匯出資料時，報下面的錯誤：
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CQOMSWAS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CQOMSWAS
About to export CQOMSWAS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], []
EXP-00000: Export terminated unsuccessfully

原因：注意是Oracle的環境變數LD_LIBRARY_PATH/LIBPATH變數設定得不對

1、停止資料庫和資料庫的listener監聽器
$ sqlplus "/as sysdba"
SQL> shutdown immediate  （如果shutdown immediate關閉需要很長時間，可以直接用shutdown abort快速關閉）
SQL>exit
$lsnrctl stop

2、oracle使用者修改.profile檔案
$ vi  .profile
增加下面的內容：
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LIBPATH=$ORACLE_HOME/lib

“Esc” wq  儲存退出

 

$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ export LIBPATH=$ORACLE_HOME/lib

 

3、再重新啟動資料庫和listener
$ sqlplus "/as sysdba"
SQL>startup
SQL>exit

$lsnrctl start

4、再用exp命令匯出就沒有問題了