Linuxの安装SQL Developer工具

一、下载JDK

JDK下载网址:http://www.oracle.com/technetwork/java/javase/downloads/java-archive-javase8-2177648.html

JDK安装版本:jdk-8u151-linux-x64.tar.gz

二、安装JDK

1)把下载的JDK安装包进行解压。解压命令:tar -zxvf jdk-8u151-linux-x64.tar.gz

2)配置JDK环境变量,此处不详细描述,请自行百度/谷歌

三、下载SQL Developer

SQL Developer下载网址:http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

SQL Developer安装版本:sqldeveloper-17.4.0.355.2349-1.noarch.rpm

 四、安装SQL Developer

1)把下载好的rpm包上传到服务器进行安装。安装命令:rpm -ivh sqldeveloper-17.4.0.355.2349-1.noarch.rpm

2)SQL Developer会默认安装在 /opt/ 目录下

3)此时SQL Developer已经安装完成。访问图形化界面,并在Applications菜单的Programming栏目能够查看到图标

 4)在图形化界面下启动SQL Developer

进入文件夹:cd /opt/sqldeveloper

启动程序:./sqldeveloper.sh

5)启动后弹出提示,系统的Java版本与developer所需版本不符,如下图所示:

修改启动文件的配置,手动指定启动所需的Java版本,输入刚才安装的jdk路径

 

输入jdk安装路径后,弹出提示,如下图所示:

因为之前没有安装过SQL Developer,不需要导入配置,所以选择 No,此时SQL Developer启动中

五、启动验证 

配置好数据库账号密码与路径地址,连接查询,成功!

 

 

 

 

转载于:https://www.cnblogs.com/maple-study/p/8416509.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、付费专栏及课程。

余额充值