linux下oracle instant client安装和运行

最新推荐文章于 2021-04-15 13:57:16 发布

原创最新推荐文章于 2021-04-15 13:57:16 发布 · 160 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

oracle 专栏收录该内容

34 篇文章

订阅专栏

本文详细介绍如何从Oracle官网下载Instant Client并完成在Linux系统的安装配置过程。步骤包括创建目录、设置权限、解压文件、配置环境变量及修改ld.so.conf文件等。

Step one:

download the correspondent instantclient from oracle website: [url]http://www.oracle.com/technetwork/topics/linuxsoft-082809.html[/url] for my case:

Download instantclient-basic-linux32-10.2.0.3-20061115.zip

step two:
mkdir -p /home/oracle/10.2.3
chown -R oracle:oinstall /home/oracle/10.2.3
chmod -R 775 /home/oracle/10.2.3

su - oracle
cd /home/oracle/10.2.3
unzip instantclient-basic-linux32-10.2.0.3-20061115.zip

step three:

copy sqlnet.ora and tnsname.ora into the directory

step four:
set ORACLE_HOME, ORACLE_SID, TNS_ADMIN, LD_LIBARARY_PATH, PATH

step five:

su - root
vi /etc/ld.so.conf

/home/oracle/10.2.3/instantclient_10_2

step six:
download sqlplus package from website.

issue:

if show missing sp*.msd

then

check if the oracle_home set?

check: type sqlplus to see where the path is.