本文介绍了如何安装SQL * Plus客户端在Linux的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我工作的AWS服务。我有一个 EC2(CentOS的)实例。我需要配置的SQL * Plus客户端这CentOS的机器上。

I am working on AWS services. I have an ec2 ( centos ) instance. I need to configure SQL*Plus client on this centos machine.

我与他想连接的服务器是在一些偏远地区。该服务器版本甲骨文-SE(11.2.0.2)

The server with whom I want to connect is at some remote area. The server version is oracle-se(11.2.0.2)

请帮我获得安装CentOS的机器上的客户端。

Kindly help me getting the client installed on the centos machine.

在此先感谢。

推荐答案

到http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html下载Oracle的Linux x86-64的即时客户端

Go to http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html to download the oracle Linux x86-64 instant clients

下载匹配的客户端

oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm

安装

rpm -ivh oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm
rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm

在设置环境变量的〜/ .bash_profile中

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

注销用户重新登录,现在你就可以使用SQL * Plus并连接服务器。式中:

Log-out user and log-in again and now you're ready to use SQL*Plus and connect your server. Type in :

sqlplus中"username/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.1)(PORT=1521))(CONNECT_DATA=(SID=YOURSID)))"

这篇关于如何安装SQL * Plus客户端在Linux的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-04 17:58