Linux安装Oracle Client
还在整理,请勿参考
Oracle官方网站:http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
1.RPM INSTALL
1.1 下载安装包
1.对包功能的介绍
Package | Desc |
---|---|
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm | 基础包,为了运行OCI、OCCI、JDBC-OCI 这几个应用程序; |
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm | 补充包/文件,是为了运行sql*plus的即时客户端; |
oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm | 补充包/文件,为运行ODBC环境附加库; |
oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm | 补充JDBC下的XA、国际标准、行集操作; |
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm | 包含头文件和示例文件,为开发Oracle应用程序的即时客户端; |
2.我只下载了这三个,上传到linux
3.也可以用wget直接下载
- wget https://download.oracle.com/otn_software/linux/instantclient/216000/oracle-instantclient-basic-21.6.0.0.0-1.el8.x86_64.rpm
- wget https://download.oracle.com/otn_software/linux/instantclient/216000/oracle-instantclient-sqlplus-21.6.0.0.0-1.el8.x86_64.rpm
- wget https://download.oracle.com/otn_software/linux/instantclient/216000/oracle-instantclient-devel-21.6.0.0.0-1.el8.x86_64.rpm
1.2 进行安装
安装三个包
- sudo rpm -ivh oracle-instantclient-xxxx-21.6.0.0.0-1.el8.x86_64.rpm
安装位置
- 头文件:/usr/include/oracle/21/client64/
- 包文件:/usr/lib/oracle/21/client64/
1.3 创建监听文件
- 1.创建文件夹
sudo mkdir -p /usr/lib/oracle/21/client64/network/admin/- 2.创建文件
sudo vim /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora
//内容如下:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxx)
)
)
1.4 配置环境变量
sudo vim /etc/profile
//内容如下:
export ORACLE_HOME=/usr/lib/oracle/21/client64/
export LD_LIBRARY_PATH=:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_LANG=AMERICAN_AMERICA.UTF8
source /etc/profile
sudo vim ~/.bashrc
export ORACLE_HOME=/usr/lib/oracle/21/client64/
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export NLS_LANG=AMERICAN_AMERICA.UTF8
source ~/.bashrc
1.5 测试
- sqlplus 用户名/密码@库名
sqlplus xxx/xxx@xxx.xxx.xx.xx:1521/库名
- 配置tnsnames.ora,直接使用
sqlplus xxx/xxx@ORCL