linux安装SQL Developer

环境一:

操作系统:Redhat 6

JDK:Sun JDK(Oracle JDK)

现在用的sql-developer4.0.3.16.84,装好JDK(1.7版本,只支持大于1.6小于1.8版本),再装sql-developer,直接点击图标就能启动。

安装JDKhttp://blog.youkuaiyun.com/silence_ljh/article/details/39024341

环境二(本文环境):

操作系统:Redhat 5

JDK:系统自带JDK(OpenJDK)

1、安装Jre
rpm -ihv jre-6u45-linux-x64-rpm

这里官网下载下来的是.bin文件,直接./jre-6u45-linux-x64-rpm.bin就会得到一个.rpm文件。

默认安装在/usr/java/jre1.6.0_45

如果报错error: can't create transaction lock on /var/lib/rpm/__db.000,这是没有权限,换成root用户。

2、安装sql-developer
rpm -ihv sqldeveloper-3.2.20.09.87-1.noarch.rpm

默认安装在/opt/sqldeveloper

3、启动sql-developer
虽然在程序菜单中有sql-developer的图标,但单击并不能启动,因为没有配置jre的路径。所以,只能用命令行启动。

./sqldeveloper.sh 出现

Oracle SQL Developer

Copyright (c) 2008, Oracle. All rights reserved.

Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.sqldeveloper/jdk

要求输入jre路径
/usr/java/jdk1.6.0_45

报错:

/opt/sqldeveloper/sqldeveloper/bin/../../ide/bin/launcher.sh: line 430: /root/.sqldeveloper/jdk: No such file or directory                                                                             

Error: Java home /usr/lib/jvm/java-1.6.0-openjdk-1.2_b11/jre//bin/java is not a J2SE SDK.           

Running SQL Developer under a JRE is not supported.                                                 


If the Java VM specified by the SetJavaHome is actually a full J2SDK installation

then add 'SetSkipJ2SDKCheck true' to /opt/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf

修改/opt/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf文件

#vi /opt/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf

更改红色,添加蓝色,保存退出

IncludeConfFile ../../ide/bin/ide.conf  
   SetJavaHome /usr/lib/jvm(如果是Sun JDK 就改成/usr/java/jdk1.6.0_45)
   SetSkipJ2SDKCheck true 
    AddVMOption -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true  
    AddVMOption -Dsun.java2d.ddoffscreen=false  内容来自17jquery 
    AddVMOption -Dwindows.shell.font.languages=  
    AddVMOption  -XX:MaxPermSize=256M  
    AddVMOption -Doracle.jdbc.mapDateToTimestamp=false  
    IncludeConfFile  sqldeveloper-nondebug.conf

然后可以通过命令启动,也可以点击程序图标启动。

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、付费专栏及课程。

余额充值