1、从oracle下载Instant Client
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
选择适合的版本,下载rpm包
oracle-instantclient-basic和oracle-instantclient-sqlplus
2、转换rpm为deb
sudo alien oracle-instantclient-basic.rpm
3、安装deb
sudo dkpg -i oracle-instantclient-basic.deb
4、配置环境变量
vim ~/.profile
export ORACLE_HOME=/usr/lib/oracle/10.2.0.5/client export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export TNS_ADMIN=$ORACLE_HOME/network/admin
5、立即生效变量
source ~/.profile
6、创建目录与tnsnames.ora文件
sudo mkdir -p $ORACLE_HOME/network/admin
sudo vim tnsnames.ora
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
这里需要在系统hosts文件中添加dbserver的ip对应。
7、测试连接
sqlplus 'scott/tiger@orcl'
这个单引号是必须的。