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命令导出就没有问题了

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/235507/viewspace-611946/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/235507/viewspace-611946/