1. 分别安装
oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.1.0-1.x86_64.rpm
命令如下:
rpm -ivh 包名称
2. 添加dns等配置
在默认安装路径:/usr/lib/oracle/11.2/client64
新建 network/admin/tnsnames.ora文件
文件内容如下:
atuonavi_10.2.164.14 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.164.14)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
3. 添加环境变量
在/etc/profile添加
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG='simplified chinese_china'.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
4. 如何sql语句上下左右后退等键不能使用,安装
http://rpm.pbone.net/index.php3/stat/4/idpl/15276193/dir/redhat_el_5/com/rlwrap-
0.37-1.el5.x86_64.rpm.html
下载 rlwrap-0.37-1.el5.x86_64.rpm 安装即可
oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.1.0-1.x86_64.rpm
命令如下:
rpm -ivh 包名称
2. 添加dns等配置
在默认安装路径:/usr/lib/oracle/11.2/client64
新建 network/admin/tnsnames.ora文件
文件内容如下:
atuonavi_10.2.164.14 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.164.14)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
3. 添加环境变量
在/etc/profile添加
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG='simplified chinese_china'.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
4. 如何sql语句上下左右后退等键不能使用,安装
http://rpm.pbone.net/index.php3/stat/4/idpl/15276193/dir/redhat_el_5/com/rlwrap-
0.37-1.el5.x86_64.rpm.html
下载 rlwrap-0.37-1.el5.x86_64.rpm 安装即可