ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXP-00056: ORACLE error 600 encountered 解决方法

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

原创 Linux操作系统 作者:mengzhaoliang 时间:2009-05-11 10:09:23 0 删除 编辑

/*
*时间: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/12778571/viewspace-594691/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2008-01-30

  • 博文量
    335
  • 访问量
    2942863