Oracle dbca Exception in thread ldquo;mainrdquo; 解决方法

在一套DB服务器上运行DBCA 命令，报错：

[Oracle@game_db ~]$ dbca

Exception in thread "main"

[oracle@game_db ~]$

[oracle@game_db ~]$ exportDISPLAY=1921.68.3.1:0.0

[oracle@game_db ~]$ dbca

Exception in thread "main"

几年都没有遇到这种问题了，起初以为是DISPLAY变量的问题，设置以后也不行，，查看了一个DBCA的log 日志：

[oracle@game_db scripts]$ cd $ORACLE_HOME/cfgtoollogs/dbca

[oracle@game_db dbca]$ ls

trace.log

[oracle@game_db dbca]$ tail -50 trace.log

java.lang.UnsatisfiedLinkError:/home/oracle_app_10204/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot openshared object file: No such file or directory

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586)

at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1503)

at java.lang.Runtime.loadLibrary0(Runtime.java:788)

at java.lang.System.loadLibrary(System.java:834)

at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50)

at java.security.AccessController.doPrivileged(Native Method)

at sun.awt.NativeLibLoader.loadLibraries(NativeLibLoader.java:38)

atsun.awt.DebugHelper.(DebugHelper.java:29)

at java.awt.Component.(Component.java:506)

atoracle.sysman.assistants.util.wizard.WizardObject.(WizardObject.java:)

atoracle.sysman.assistants.dbca.ui.DBCAWizard.(DBCAWizard.java:425)

at oracle.sysman.assistants.dbca.ui.UIHost.(UIHost.java:214)

atoracle.sysman.assistants.dbca.ui.InteractiveHost.(InteractiveHost.java:54)

atoracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:160)

at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:94)

at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)

原因很明显，少包了：

libXp.so.6: cannot open shared object file:No such file or directory

验证一下包：

[oracle@game_db dbca]$ rpm -qa|grep libXp

libXpm-devel-3.5.5-3

libXpm-3.5.5-3

将libXp 包打上：

[root@game_db Server]# ll

-rwxrwSrwx 1 root root 22996 2007-07-26libXp-1.0.0-8.1.el5.i386.rpm

-rwxrwSrwx 1 root root 15262 2007-07-26libXp-devel-1.0.0-8.1.el5.i386.rpm

[root@game_db Server]# rpm -ivh libXp*.rpm

warning: libXp-1.0.0-8.1.el5.i386.rpm:Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:libXp ########################################### [ 50%]

2:libXp-devel ########################################### [100%]

[root@game_db Server]# rpm -qa|grep libXp

libXpm-devel-3.5.5-3

libXp-1.0.0-8.1.el5

libXpm-3.5.5-3

libXp-devel-1.0.0-8.1.el5

在次DBCA 成功：

[root@game_db ~]# xhost +

access control disabled, clients canconnect from any host

[root@game_db ~]# su - oracle

[oracle@game_db ~]$ exportDISPLAY=192.168.3.1:0.0

[oracle@game_db ~]$ dbca

这套系统是之前的同事安装的，整个安装目录，都没有遵守OFA的架构，所以相关的目录结构看起来感觉有点别扭。