`
xitong
  • 浏览: 6204866 次
文章分类
社区版块
存档分类
最新评论

fc9下oracle sqldeveloper安装日志

 
阅读更多
本来打算就使用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也遇到过这种情况,所以如法炮制
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics