fc9下oracle sqldeveloper安装日志

isiqi

浏览: 16572227 次
性别:
来自: 济南

最近访客更多访客>>

yuxiatongzhi

nison

hellohank

wangyy

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

2012-07 ( 335)
2012-06 ( 252)
2012-05 ( 362)
更多存档...

Oracle SQL Server Linux MySQL Security

本来打算就使用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也遇到过这种情况，所以如法炮制

分享到：