linux centos7上安装sql developer

安装JDK
下载地址:https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

1)root用户下:

 首先查询系统自带的jdk: rpm -qa | grep java

然后移除系统自带的jdk: yum remove java-1.*

 

 

 

2)安装oracle JDK

将JDK文件解压,放到/usr/java目录下:

mkdir /usr/java

 cd /usr/java

tar -zxvf /usr/java/jdk-8u311-linux-x64.tar.gz

chmod +X /usr/java/jdk1.8.0_311/bin/*

  3)设置环境变量

vim ~/.bash_profile

 #jdk

export JAVA_HOME=/usr/java/jdk1.8.0_131

export PATH=$JAVA_HOME/bin:$PATH

  使改动生效命令:

source ~/.bash_profile

 

或者修改    /etc/profile 中的环境变量如下:

 

 

测试配置:

[root@CentOS7_3 jdk1.8.0_311]# java -version
java version "1.8.0_311"
Java(TM) SE Runtime Environment (build 1.8.0_311-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.311-b11, mixed mode)
 

安装sql developer

 rpm包下载地址:https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

将sqldevelop的rpm包上传至服务器某文件夹下

[root@hostname backup]# rpm -ivh sqldeveloper-18.4.0-376.1900.noarch.rpm

默认安装位置为/opt/sqldeveloper

建立与oracle数据库的连接
打开sql developer--进入sql developer的目录
[root@hostname ~]# cd /opt/sqldeveloper/

[root@hostname sqldeveloper]# ./sqldeveloper.sh

以SID连接

 

以服务名连接

 

参考:

(八)Centos7 下安装jdk8(压缩包版)_zhengTornado的博客-CSDN博客

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

余额充值