本来打算就使用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也遇到过这种情况,所以如法炮制
分享到:
相关推荐
FC9虚拟机安装方法及samba配置,是网上搜集到的资料
在虚拟机上装FC9后想通过/mnt/hgfs/的方式实现文件共享,只要按文档的方法一定能成功,亲测!!
tftp-server-0.48-6.fc9.i386.rpm TFTP安装文件
MiniGUI-3.0.12在FC9上到安装及其交叉编译
fedora9安装tftp服务所需rpm包
虚拟机vm下fedora系统下安装vmtools时用到的一个软件。为了方便虚拟机系统读取该文件。已经把他转成了.iso文件。只需加载到光驱就可以在虚拟机里读取了。 安装过程参考:...
readline-5.2-13.fc9.i386.rpm
安装:gconf-editor-2.22.0-1.fc9.i386.rpm 在终端中运行 gconf-editor 在打开的界面中选择: apps->gedit-2->preferences->encodings 在右边的auto_detected和shown_in_menu上点右键编辑,点add,分别加入GB...
readline-devel-5.2-13.fc9.i386.rpm
fedora9安装tftp服务所需的依赖
kernel-devel-2.6.25.14-108.fc9.i686.rpm 内核源码 解压过后 usr/src/kernels/2.6.25.14-108.fc9.i686/
libXp-1.0.0-11.fc9.i386.rpm和libXp-devel-1.0.0-11.fc9.i386.rpm
libXtst-1.0.3-3.fc9.src.rpm是用于安装嵌入式工具QT是所需要的东西,好不容易下的,上传下。。。。
IBM Informix Dynamic Server Version 11.50.FC9 for linux 64bit
lrzsz-0.12.20-23.fc9.i386.rpm,minicom辅助安装文件
S3FC9DC单片机代码优化技术研究
minicom-2.3-2.fc9.i386.rpm Linux下的串口调试
vnc-server-4.1.2-30.fc9.i386.rpm
kernel-devel-2.6.25-14.fc9.i686 FEDORA9内核头文件
openmotif-2.3.0-0.3.fc9.ccrma.i386.rpm