9i数据导入到10G后,oem中见不到表了 [复制链接]

精华贴数: 0
技术积分: 903
社区积分: 24
注册时间: 2005-7-10

论坛徽章:: 3

发表于 2006-5-13 15:43:34 |显示全部楼层

帮顶

高级会员

精华贴数: 1
技术积分: 6452
社区积分: 31
注册时间: 2003-1-21

论坛徽章:: 11

发表于 2006-5-13 21:50:09 |显示全部楼层

通过一个工具发现PL/SQL的TABLE执行的以下语句:
select object_name, owner object_owner, status
from sys.all_objects o
where object_type = 'TABLE'
and object_name not like 'BIN$%'
order by decode(owner, user, 0, 1),
owner,object_name
当把这个语句拿到PL/SQL中执行时,就一直挂起.
如果不加ORADER BY ,就没有问题.

高级会员

精华贴数: 1
技术积分: 6452
社区积分: 31
注册时间: 2003-1-21

论坛徽章:: 11

发表于 2006-5-13 22:00:41 |显示全部楼层

在报警文件中发现以下错误:

Errors in file /oracle/admin/orayb/udump/orayb_ora_417900.trc:
ORA-00600: internal error code, arguments: [unable to load XDB library], [], [],
[], [], [], [], []
Sat May 13 17:19:52 2006
Errors in file /oracle/admin/orayb/udump/orayb_ora_417900.trc:
[], [], [], [], [] error code, arguments: [unable to load XDB library], [], [],
Sat May 13 17:19:54 2006
Errors in file /oracle/admin/orayb/udump/orayb_ora_417900.trc:
[], [], [], [], [] error code, arguments: [unable to load XDB library], [], [],
Sat May 13 17:19:55 2006
Errors in file /oracle/admin/orayb/udump/orayb_ora_417900.trc:
[], [], [], [], [] error code, arguments: [unable to load XDB library], [], [],
Sat May 13 17:19:56 2006
Errors in file /oracle/admin/orayb/udump/orayb_ora_417900.trc:
[], [], [], [], [] error code, arguments: [unable to load XDB library], [], [],
Sat May 13 17:19:58 2006
Errors in file /oracle/admin/orayb/udump/orayb_ora_417900.trc:
[], [], [], [], [] error code, arguments: [unable to load XDB library], [], [],
Sat May 13 17:19:59 2006
Errors in file /oracle/admin/orayb/udump/orayb_ora_417900.trc:
[], [], [], [], [] error code, arguments: [unable to load XDB library], [], [],
Sat May 13 17:20:01 2006
Errors in file /oracle/admin/orayb/udump/orayb_ora_417900.trc:
[], [], [], [], [] error code, arguments: [unable to load XDB library], [], [],

高级会员

精华贴数: 1
技术积分: 6452
社区积分: 31
注册时间: 2003-1-21

论坛徽章:: 11

发表于 2006-5-13 22:34:29 |显示全部楼层

orayb_ora_417900.trc中的错误如下:

*** SERVICE NAME

SYS$USERS) 2006-05-13 17:19:50.037
*** SESSION ID

141.3887) 2006-05-13 17:19:50.036
Dynamic link error: 0509-022 Cannot load module /oracle/product/10.2.0/db_1/
lib32/libxdb.so.
0509-103 The module has an invalid magic number.
*** 2006-05-13 17:19:50.063
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [unable to load XDB library], [], [],
[], [], [], [], []

高级会员

精华贴数: 1
技术积分: 6452
社区积分: 31
注册时间: 2003-1-21

论坛徽章:: 11

发表于 2006-5-13 23:36:34 |显示全部楼层

问题找到,是由于64位机器的LD_LIBRARY_PATH路径不能设置为lib32,只能设置为lib,即可:

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

高级会员

精华贴数: 1
技术积分: 6452
社区积分: 31
注册时间: 2003-1-21

论坛徽章:: 11

发表于 2006-5-13 23:38:16 |显示全部楼层

这个根据MetaLink上说,还真与AIX平台有关系.

高级会员

精华贴数: 1
技术积分: 6452
社区积分: 31
注册时间: 2003-1-21

论坛徽章:: 11

发表于 2006-5-13 23:45:10 |显示全部楼层

MetaLink上的原文:

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

高级会员

精华贴数: 1
技术积分: 6452
社区积分: 31
注册时间: 2003-1-21

论坛徽章:: 11

发表于 2006-5-14 00:14:08 |显示全部楼层

他妈的,这个问题原来是ORACLE在搞鬼.
终于搞定,谢谢大家参与.

Olley

零级会员

精华贴数: 0
技术积分: 34
社区积分: 38
注册时间: 2006-5-11

论坛徽章:: 0

发表于 2006-5-14 08:35:12 |显示全部楼层

学习了一把

〇〇

版主

精华贴数: 12
技术积分: 56487
社区积分: 11400
注册时间: 2008-1-16

论坛徽章:: 237

发表于 2010-3-26 13:12:13 |显示全部楼层

我的$SHLIB_PATH为空，$LD_LIBRARY_PATH如下，还是出错

ibm01:/tmp$echo $LD_LIBRARY_PATH
/u01/app/oracle/product/11.1.0/db/lib:/usr/lib
ibm01:/tmp$echo $SHLIB_PATH

ibm01:/tmp$./ociuldr.exe
exec(): 0509-036 Cannot load program ./ociuldr.exe because of the following errors:
      0509-150 Dependent module /u01/app/oracle/product/11.1.0/db/lib/libclntsh.a(shr.o) could not be loaded.
      0509-103 The module has an invalid magic number.
ibm01:/tmp$ls -l $ORACLE_HOME/lib32/libclntsh*
-rw-r--r-- 1 oracle dba       40230978 Mar 26 12:54 /u01/app/oracle/product/11.1.0/db/lib32/libclntsh.a
-rwxr-xr-x 1 oracle dba       39146414 Mar 26 12:54 /u01/app/oracle/product/11.1.0/db/lib32/libclntsh.so
lrwxrwxrwx 1 oracle dba             52 Dec 08 03:28 /u01/app/oracle/product/11.1.0/db/lib32/libclntsh.so.10.1 -> /u01/app/oracle
/product/11.1.0/db/lib32/libclntsh.so
-rw-r--r-- 1 oracle dba             0 Nov 07 2007  /u01/app/oracle/product/11.1.0/db/lib32/libclntsh.so.11.1
ibm01:/tmp$ls -l $ORACLE_HOME/lib/libclntsh*
-rw-r--r-- 1 oracle dba       44177019 Mar 26 12:54 /u01/app/oracle/product/11.1.0/db/lib/libclntsh.a
-rwxr-xr-x 1 oracle dba       43092479 Mar 26 12:54 /u01/app/oracle/product/11.1.0/db/lib/libclntsh.so
lrwxrwxrwx 1 oracle dba             50 Dec 08 03:28 /u01/app/oracle/product/11.1.0/db/lib/libclntsh.so.10.1 -> /u01/app/oracle/p
roduct/11.1.0/db/lib/libclntsh.so