fc oracle,fc9下oracle sqldeveloper安装日志

博主在Linux环境下遇到使用SQL Plus不便,转而使用Oracle SQL Developer,但遇到了安装问题、界面中文乱码及命令行历史记录功能不熟悉的问题。通过更换JDK版本解决安装错误,通过设置NLS_LANG环境变量解决中文显示乱码,最后从同事那里学到将特定字体链接到Java的字体目录中解决了输入和显示中文的问题。
摘要由CSDN通过智能技术生成

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值