mint下安装oracle instance client(五)

2014-11-24 12:04:10 · 作者: · 浏览: 3
0-1.i386.rpm
oracle-instantclient11.2-basic_11.2.0.3.0-2_i386.deb oracle-instantclient11.2-jdbc_11.2.0.3.0-2_i386.deb
oracle-instantclient11.2-devel-11.2.0.3.0-1.i386.rpm oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.i386.rpm
oracle-instantclient11.2-devel_11.2.0.3.0-2_i386.deb oracle-instantclient11.2-sqlplus_11.2.0.3.0-2_i386.deb
下面开始安装生成到deb文件:
[plain]
dba@dba ~/oracle-instantclient11.2 $ sudo dpkg -i oracle-instantclient11.2-basic_11.2.0.3.0-2_i386.deb
Selecting previously unselected package oracle-instantclient11.2-basic.
(正在读取数据库 ... 系统当前共安装有 149643 个文件和目录。)
正在解压缩 oracle-instantclient11.2-basic (从 oracle-instantclient11.2-basic_11.2.0.3.0-2_i386.deb) ...
正在设置 oracle-instantclient11.2-basic (11.2.0.3.0-2) ...
正在处理用于 libc-bin 的触发器...
ldconfig deferred processing now taking place
dba@dba ~/oracle-instantclient11.2 $ sudo dpkg -i oracle-instantclient11.2-devel_11.2.0.3.0-2_i386.deb
Selecting previously unselected package oracle-instantclient11.2-devel.
(正在读取数据库 ... 系统当前共安装有 149661 个文件和目录。)
正在解压缩 oracle-instantclient11.2-devel (从 oracle-instantclient11.2-devel_11.2.0.3.0-2_i386.deb) ...
正在设置 oracle-instantclient11.2-devel (11.2.0.3.0-2) ...
dba@dba ~/oracle-instantclient11.2 $ sudo dpkg -i oracle-instantclient11.2-jdbc_11.2.0.3.0-2_i386.deb
Selecting previously unselected package oracle-instantclient11.2-jdbc.
(正在读取数据库 ... 系统当前共安装有 149710 个文件和目录。)
正在解压缩 oracle-instantclient11.2-jdbc (从 oracle-instantclient11.2-jdbc_11.2.0.3.0-2_i386.deb) ...
正在设置 oracle-instantclient11.2-jdbc (11.2.0.3.0-2) ...
dba@dba ~/oracle-instantclient11.2 $ sudo dpkg -i oracle-instantclient11.2-sqlplus_11.2.0.3.0-2_i386.deb
Selecting previously unselected package oracle-instantclient11.2-sqlplus.
(正在读取数据库 ... 系统当前共安装有 149716 个文件和目录。)
正在解压缩 oracle-instantclient11.2-sqlplus (从 oracle-instantclient11.2-sqlplus_11.2.0.3.0-2_i386.deb) ...
正在设置 oracle-instantclient11.2-sqlplus (11.2.0.3.0-2) ...
还需要设置一下环境变量,否则会报错,添加下面几行:
[plain]
dba@dba ~ $ sudo vim /etc/bash.bashrc
export ORACLE_HOME=/usr/lib/oracle/11.2/client
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG="AMERICAN_AMERICA.UTF8"
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
dba@dba ~ $ source /etc/bash.bashrc
dba@dba /usr/lib/oracle/11.2/client $ sqlplus /nolog
sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
注意到TNS_ADMIN所在目录其实并不存在,是要自己创建
[plain]
dba@dba /usr/lib/oracle/11.2/client $ ls
bin lib
dba@dba /usr/lib/oracle/11.2/client $ sudo mkdir -p $ORACLE_HOME/network/admin
上面sqlplus /nolog的错误提示很明显,系统少了libaio包,给安装下即可
[plain]
dba@dba ~ $ sudo apt-get install libaio-dev
正在读取软件包列表... 完成
正在分析软件包的依赖关系树
正在读取状态信息... 完成
下列软件包是自动安装的并且现在不需要了:
libwxbase2.8-0 libwxgtk2.8-0
Use 'apt-get autoremove' to remove them.
将会安装下列额外的软件包:
libaio1
下列【新】软件包将被安装:
libaio-dev libaio1
升级了 0 个软件包,新安装了 2 个软件包,要卸载 0 个软件包,有 18 个软件包未被升级。
需要下载 21.3 kB 的软件包。
解压缩后会消耗掉 139 kB 的额外空间。
您希望继续执行吗?[Y/n]y
获取:1 http://mirro