Linux 安装 Oracle SQL Developer

版本: sqldeveloper-3.2.20.09.87-no-jre.zip

安装目录 ~/.software/sqldeveloper

进入安装目录

cd ~/.software/sqldeveloper/sqldeveloper/bin/

给所有的 sh 执行权限

chmod a+x *.sh

给 sqldeveloper 执行权限

chmod a+x sqldeveloper

 指定 JDK 路径

vim ~/.software/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
SetJavaHome /usr/lib/jvm/java-7-oracle

进入用户目录下的 .bin (这个目录在PATH变量中)

cd ~/.bin                                       

新建一个当前用户的 sqldeveloper 执行命令

vim .bin/sqldeveloper
#!/bin/bash
# 给一个中文环境变量
export LANG="zh_CN.UTF-8"
# sqldeveloper 最终执行命令
~/.software/sqldeveloper/sqldeveloper/bin/sqldeveloper

给新建的 sqldeveloper 执行权限

chmod a+x sqldeveloper

JDK 中文字体

sudo mkdir /usr/lib/jvm/java-7-oracle/jre/lib/fonts/fallback
sudo cp ~/.local/share/fonts/zysong.ttf /usr/lib/jvm/java-7-oracle/jre/lib/fonts/fallback/
sudo chmod 655 zysong.ttf

配置界面中文字体大小

vim ~/.sqldeveloper/system3.2.20.09.87/o.sqldeveloper.11.2.0.9.87/ide.properties (目录得是你当前版本的版本号)
# Ide.FontSize=11
修改成 (去掉 #)
Ide.FontSize=12

添加第三方 JDBC 库

工具 -> 首选项 -> 数据库 -> 第三方 JDBC 驱动程序

 

嘿嘿,字体还不错吧,比一开始的好看多了!  ^_O

转载于:https://www.cnblogs.com/alexck/p/3424504.html

Oracle SQL Developer, v1.5.0.54.40 Release Notes 完整版下载:http://www.oracle.com/technology/global/cn/software/products/sql/index.html 1. Known Issues 1.1 General - Print prints only one page that is a truncation of the current tab. - Can't invoke SQL*Plus on Windows 2003. - The menu item, and right-click off a Connection node, for invoking SQL*Plus does not work with connections whose passwords are not persisted. 1.2 Connections - Cannot connect to remote database as OPS$ account. 1.3 Browse - If connected as sys with sysdba role, Types node displays built in data-types (e.g. BLOB, DATE, DECIMAL, etc.) If clicked on, will only see "create or replace". 1.4 Creating and Modifying Objects - Editing Triggers - If you have comments before the 'BEGIN' they will be lost if you edit. You will see when you click edit that they will not be there. To preserve them, they need to be below the BEGIN or you will need to edit via the SQL Worksheet. 1.5 Table > Data - Tables > Your_Table > Data - PageUp and PageDown buttons not working correctly if cursor is in the rownum column. 1.6 Export - Cannot export if result set contains duplicate column names. 2. Workarounds 2.1 To disable Code Insight Run SQL Developer from a command line using the following statement: Windows : sqldeveloper -J-Dsdev.insight=false Linux or Mac: Run sh sqldeveloper -J-Dsdev.insight=false or edit sqldeveloper.conf and add "AddVMOption -J-Dsdev.insight=false" 2.2 If DDL tab is null for all objects in a Connection Your dbms_metadata might be loaded incorrectly. If this statement fails when executed in a SQL Worksheet against the Connection select dbms_metadata.get_ddl('TABLE',table_name , user ) from user_tables; You need to reload $ORACLE_HOME/rdbms/admin/catmeta.sql 2.3 If Snippets are not accessible You may have not done a clean install. SQL Developer needs to be installed into a clean directory, not over a previous release. 3. Accessibility Issues The following is a li
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值