ITPub博客

首页 > Linux操作系统 > Linux操作系统 > DBA那些事儿 (2). 又被lib给玩了一次

DBA那些事儿 (2). 又被lib给玩了一次

原创 Linux操作系统 作者:yxyup 时间:2009-08-23 15:46:57 0 删除 编辑

今天介绍exp功能使用时,又遇上lib问题.下面是详细过程.

环境.
OS: aix5.3
oracle: Oracle 10gR2

1.错误现象

oracle@DB1:/home/oracle$ exp system/abc123  wner=user1 file=user1.dmp log=user1.log

Export: Release 10.2.0.1.0 - Production on Thu Aug 20 09:20:06 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


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
server uses WE8ISO8859P1 character set (possible charset conversion)

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


2.解决过程
查询metalink后,发现是lib环境变量路径没有设置正确.

Doc ID:109621.1

5. WHICH VARIABLE SHOULD BE SET FOR 64 BIT ORACLE?
   -----------------------------------------------

A 64 bit install of Oracle includes both 32 bit executables (such as svrmgrl
and sqlplus) and 64 bit executables (such as oracle).

The installation contains two 'lib' areas:
   Prior to 9i:
      $ORACLE_HOME/lib     - 32 bit libs
      $ORACLE_HOME/lib64   - 64 bit libs
   9i onwards:
      $ORACLE_HOME/lib32   - 32 bit libs
      $ORACLE_HOME/lib     - 64 bit libs

Both of these directories contain libraries of the same name. To ensure
that 32 bit executables search the 32 bit dir, and 64 bit executables
search the 64 bit dir, set the following:

Prior to 9i:
$LD_LIBRARY_PATH - includes $ORACLE_HOME/lib64, but not $ORACLE_HOME/lib
$SHLIB_PATH      - includes $ORACLE_HOME/lib, but not $ORACLE_HOME/lib64

9i onwards:
$LD_LIBRARY_PATH - includes $ORACLE_HOME/lib, but not $ORACLE_HOME/lib32
$SHLIB_PATH      - includes $ORACLE_HOME/lib32, but not $ORACLE_HOME/lib



3.查看当前的.profile设置,果然是错误的

oracle@DB1:/home/oracle$ cat .profile
.......

LD_LIBRARY_PATH=/oracle/app/oracle/product/10.2.0/lib32:/oracle/app/oracle/product/10.2.0/lib

NLS_LANG=American_America.ZHS16GBK
ORA_NLS33=/oracle/app/oracle/product/10.2.0/nls/data

export PATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/etc:/usr/lbin:/usr/local/bin:/usr/sbin:/usr/ucb

TMP=/tmp
TMPDIR=/tmp
OPATCH_PLATFORM_ID=212
export LD_LIBRARY_PATH NLS_LANG ORA_NLS33 PATH TMP TMPDIR OPATCH_PLATFORM_ID
export AIXTHREAD_SCOPE=S
umask 022

修改为以下.

oracle@DB1:/home/oracle$ cat .profile

......

LD_LIBRARY_PATH=/oracle/app/oracle/product/10.2.0/lib:/oracle/app/oracle/product/10.2.0/lib32

NLS_LANG=American_America.ZHS16GBK
ORA_NLS33=/oracle/app/oracle/product/10.2.0/nls/data

export PATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/etc:/usr/lbin:/usr/local/bin:/usr/sbin:/usr/ucb

TMP=/tmp
TMPDIR=/tmp
OPATCH_PLATFORM_ID=212
export LD_LIBRARY_PATH NLS_LANG ORA_NLS33 PATH TMP TMPDIR OPATCH_PLATFORM_ID
export AIXTHREAD_SCOPE=S
umask 022

oracle@DB1:/home/oracle$

4.重新执行exp,一切OK了.


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

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

注册时间:2007-12-06

  • 博文量
    163
  • 访问量
    1319033