本来打算就使用sqlplus命令行访问oracle,发现实在是不好用,比windows下的pl/sql难用不说,比起Linux下的mysql命令行也难用很多, 特别是那个重复上一个命令,不像普通的mysql命令行,或者shell命令行那样用一个上箭头就可以重复上一条命令,还很好修改,sqlplus下用/来实现, 不知道怎么修改,应该是我sqlplus用的不熟,算了,我还是省省,于是我改用gui 1)官方网站下载 Oracle SQL Developer RPM for Linux (This zip does not include a JDK) 2)安装 rpm -Uhv sqldeveloper-1.5.54.40-1.noarch.rpm 如果没有jdk还需要安装 2.1) 出错 界面空白 Oracle SQL Developer Copyright (c) 2008, Oracle. All rights reserved. Locking assertion failure. Backtrace: #0 /usr/lib/libxcb-xlib.so.0 [0x268767] #1 /usr/lib/libxcb-xlib.so.0(xcb_xlib_unlock+0x31) [0x268831] #2 /usr/lib/libX11.so.6(_XReply+0x244) [0x701f64] #3 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/xawt/libmawt.so [0x87d6cd7e] #4 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/xawt/libmawt.so [0x87d56d47] #5 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/xawt/libmawt.so [0x87d56ec3] #6 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/xawt/libmawt.so(Java_sun_awt_X11GraphicsEnvironment_initDisplay+0x26) [0x87d57106] #7 [0xb1623008] #8 [0xb161cb6b] #9 [0xb161cb6b] #10 [0xb161a236] #11 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/server/libjvm.so [0xb7869d7c] #12 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/server/libjvm.so [0xb7a39618] #13 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/server/libjvm.so [0xb7869baf] #14 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/server/libjvm.so(JVM_DoPrivileged+0x32d) [0xb78c76bd] #15 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/libjava.so(Java_java_security_AccessController_doPrivileged__Ljava_security_PrivilegedAction_2+0x3d) [0xb75cb30d] #16 [0xb1622898] #17 [0xb161ca94] #18 [0xb161a236] #19 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/server/libjvm.so [0xb7869d7c] Locking assertion failure. Backtrace: #0 /usr/lib/libxcb-xlib.so.0 [0x268767] #1 /usr/lib/libxcb-xlib.so.0(xcb_xlib_lock+0x2e) [0x26890e] #2 /usr/lib/libX11.so.6 [0x701109] #3 /usr/lib/libX11.so.6(XGetVisualInfo+0x26) [0x6f71f6] #4 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/xawt/libmawt.so [0x87d56089] #5 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/xawt/libmawt.so [0x87d562d3] #6 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/xawt/libmawt.so [0x87d56f71] #7 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/xawt/libmawt.so(Java_sun_awt_X11GraphicsEnvironment_initDisplay+0x26) [0x87d57106] #8 [0xb1623008] #9 [0xb161cb6b] #10 [0xb161cb6b] #11 [0xb161a236] #12 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/server/libjvm.so [0xb7869d7c] #13 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/server/libjvm.so [0xb7a39618] #14 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/server/libjvm.so [0xb7869baf] #15 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/server/libjvm.so(JVM_DoPrivileged+0x32d) [0xb78c76bd] #16 /usr/local/dev/jdk1.5.0_12/jre/lib/i386/libjava.so(Java_java_security_AccessController_doPrivileged__Ljava_security_PrivilegedAction_2+0x3d) [0xb75cb30d] #17 [0xb1622898] #18 [0xb161ca94] #19 [0xb161a236] 换成jdk6 ok 2.2) 界面不能输入中文,查询结果也出现乱码 google了很多,都说是没有设置NLS_LANG 必须export NLS_LANG=服务端的设置(select userenv('language') from dual;) 比如:SIMPLIFIED CHINESE_CHINA.UTF8 还特意google了很多关于oracle nls,发现误入歧途,还是解决不了问题 郁闷了一天 2.3)偶然发现同事joshua也用了sqldeveloper没有乱码 发现其解决办法是: ln -s /usr/share/fonts/cjkunifonts-uming/uming.ttf $your_java_home/jre/lib/fonts/fallback/zysong.ttf 按照此法终于ok 问同事是怎么找到答案的,原来他在用linux 下用netbean也遇到过这种情况,所以如法炮制
fc oracle,fc9下oracle sqldeveloper安装日志
最新推荐文章于 2023-11-11 16:29:38 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)