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.189: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.
at java.awt.Component.
atoracle.sysman.assistants.util.wizard.WizardObject.
atoracle.sysman.assistants.dbca.ui.DBCAWizard.
at oracle.sysman.assistants.dbca.ui.UIHost.
atoracle.sysman.assistants.dbca.ui.InteractiveHost.
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.189:0.0
[oracle@game_db ~]$ dbca
这套系统是之前的同事安装的,整个安装目录,都没有遵守OFA的架构,所以相关的目录结构看起来感觉有点别扭。