Ubuntu下安装Oracle sqldeveloper记录

阳光穿透心脏的1/2处 2022-06-05 07:22 337阅读 0赞

系统环境:Ubuntu16.04

## 1.安装oracle client客户端 ##

从oracle[官网下载][Link 1]如下图三个文件  
![这里写图片描述][SouthEast]  
网速较差，作者提供百度云盘下载链接: [https://pan.baidu.com/s/1hs1pWNy][https_pan.baidu.com_s_1hs1pWNy] 密码: 74qk，并新建一个文件夹存放oracle相关文件  
`sudo mkdir -p /home/mote(用户名)/Oracle`  
开始安装

sudo apt install alien
    cd Oracle/
    sudo alien -i *.rpm

安装完成之后添加环境变量  
`vim ~/.bashrc`  
添加如下内容

export ORACLE_HOME=/usr/lib/oracle/12.1/client64
    export PATH=$PATH:$ORACLE_HOME/bin
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

source一下

source ~/.bashrc

此时客户端已经完成安装，如下就能在终端内运行使用客户端

cd /usr/lib/oracle/12.2/client64/bin
    
    sqlplus username/password@//dbhost:1521/SID

终端操作已经很便利，下面延伸如何安装oracle可视化客户端**sqldevaloper**

## 2.安装jdk ##

可以选择命令行安装或者jdk包安装，两种方式任选其一即可

### 2.1.命令行安装 ###

sudo add-apt-repository ppa:webupd8team/java
    sudo apt-get update
    sudo apt-get install oracle-java8-installer

验证一下

java -version

![这里写图片描述][SouthEast 1]

### 2.2.JDK包安装 ###

*  从oracle[官网下载JDK][JDK]（作者选用的是 Java SE Development Kit 8u211）  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zNTk2NTM1MQ_size_16_color_FFFFFF_t_70]
 *  解压并移动文件

tar -xzvf jdk-8u211-linux-x64.tar.gz
    sudo mv jdk-8u211 /usr/lib/jvm

*  配置环境变量`sudo vim ~/.bashrc`

export JAVA_HOME=/usr/lib/jvm/jdk-8u211
    export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/jre/lib:$CLASSPATH
    export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH

source ~/.bashrc
    java -version

![在这里插入图片描述][20190521102354196.png]

## 3.安装sqldeveloper ##

从oracle[官网][Link 2]下载sqldeveloper (非\*\*.rpm\*\* 格式)，即下图中**Other Platforms**  
![这里写图片描述][SouthEast 2]

同样作者提供百度云下载链接: [https://pan.baidu.com/s/1miMM7Mw][https_pan.baidu.com_s_1miMM7Mw] 密码: vnex，解压后得到如下

![这里写图片描述][SouthEast 3]

运行**[sqldeveloper.sh][]**

sudo ./sqldeveloper

运行后会提示输入jdk位置，如作者位置`usr/lib/jvm/jdk1.8.0_211`  
![在这里插入图片描述][20190521102533973.png]

或者在配置文件里设置jdk路径

cd ../../sqldeveloper/sqldeveloper/bin
    sudo vim sqldeveloper.conf
    add this line  " SetJavaHome /usr/lib/jvm/jdk1.8.0_211"

如下界面就算安装成功了

![这里写图片描述][SouthEast 4]  
如下为起始页  
![这里写图片描述][SouthEast 5]

参考资料：  
[https://www.jianshu.com/p/a383804ca15d][https_www.jianshu.com_p_a383804ca15d]  
[http://www.th7.cn/system/lin/201702/203494.shtml][http_www.th7.cn_system_lin_201702_203494.shtml]  
[http://www.linuxidc.com/Linux/2015-02/114259.htm][http_www.linuxidc.com_Linux_2015-02_114259.htm]

[Link 1]: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
[SouthEast]: /images/20220605/d42972d874234579bbda6ad5e722e32e.png
[https_pan.baidu.com_s_1hs1pWNy]: https://pan.baidu.com/s/1hs1pWNy
[SouthEast 1]: /images/20220605/7461c927462941978a92051f85c34435.png
[JDK]: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zNTk2NTM1MQ_size_16_color_FFFFFF_t_70]: /images/20220605/0dcb19c44632400086c62a9e0e2757ec.png
[20190521102354196.png]: /images/20220605/fb6bdcb6fbb94459a63c2af37437588f.png
[Link 2]: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
[SouthEast 2]: /images/20220605/2b9a0b9cb05448da855fe9761dbc647c.png
[https_pan.baidu.com_s_1miMM7Mw]: https://pan.baidu.com/s/1miMM7Mw
[SouthEast 3]: /images/20220605/23c2cdca16f94f468c12872d3480a573.png
[sqldeveloper.sh]: http://sqldeveloper.sh
[20190521102533973.png]: /images/20220605/f88d310ec27443c8aa87208ed9fecd61.png
[SouthEast 4]: /images/20220605/acb01a84c4ed48cbb3e9fa418cea0b61.png
[SouthEast 5]: /images/20220605/1ba9a3d68c9a46f4a9db10f67b1e7467.png
[https_www.jianshu.com_p_a383804ca15d]: https://www.jianshu.com/p/a383804ca15d
[http_www.th7.cn_system_lin_201702_203494.shtml]: http://www.th7.cn/system/lin/201702/203494.shtml
[http_www.linuxidc.com_Linux_2015-02_114259.htm]: http://www.linuxidc.com/Linux/2015-02/114259.htm