Step one:
download the correspondent instantclient from oracle website: http://www.oracle.com/technetwork/topics/linuxsoft-082809.html 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.
download the correspondent instantclient from oracle website: http://www.oracle.com/technetwork/topics/linuxsoft-082809.html 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.
发表评论
-
dblink 阀值
2013-09-06 04:53 486调整方法: alter system set open_l ... -
查看 运行中的存储过程
2013-08-29 23:45 7801、查看ORACLE中正在运 ... -
oracle seconds to hh:mm:ss format
2013-03-13 02:26 962SELECT TO_CHAR(TRUNC(x/36 ... -
listener.ora、sqlnet.ora、tnsnames.ora
2013-03-06 04:57 743oracle网络配置 三个配置文件 listener.or ... -
oracle ratio_to_report
2013-02-20 03:20 908Ratio_to_report函数 Syntax ... -
Oracle 获取本周、本月、本季、本年的第一天和最后一天
2013-01-15 05:08 2680--取得当天0时0分0秒 select TRUNC ... -
package UTL_MAIL - 04042
2012-12-14 03:53 590Connect as SYS as sysdba: ... -
oracle常用的时间函数
2012-12-14 03:09 848SELECT SYSDATE FROM DUAL 取当前系 ... -
oracle ash awr addm 三把利剑 ---转贴
2012-10-19 04:53 786原文出处:http://space.itp ... -
expdp/impdp 进行数据库迁移例子
2012-09-21 01:59 850把一个数据库上的一个用户schema迁移到另外一个数据库上 ... -
数据库缓冲区命中率
2012-09-19 21:55 717数据库缓冲区命中率 select name,value ... -
oracle真实案例之oem大量占用cpu与内存问题的解决方法
2012-09-14 23:13 8727一、介绍 由于dba离职,所以公司所有的or ... -
grant all object to another user
2012-09-07 04:42 747If you really want to grant all ... -
oracle 权限管理
2012-09-07 04:41 6071.查看所有用户: select * from db ... -
impdp 在同一个数据库中把一个schema中所有的对象复制到另一个schema中
2012-09-07 02:03 1175在同一个数据库中把一个schema中所有的对象复制到另一个sc ... -
11g MEMORY_TARGET 参数对SGA 和PGA的影响
2012-09-06 04:32 83611g 中新增 MEMORY_MAX_TARGET 参数 ... -
每小时生成csv文件,并ftp到远端服务器
2012-08-17 03:31 2422CREATE OR REPLACE procedu ... -
全面学习DBMS包之DBMS_SQL (转贴)
2012-08-16 22:32 689在PL/SQL编程当中,经常 ... -
Oracle – Select sysdate +/- time from dual
2012-08-15 22:39 902如果想+,-系统时间: Sysdate: S ... -
ZT 查看Oracle数据库表空间大小(空闲、已使用),是否要增加表空间的数据文件
2012-08-08 23:15 856--1查看表空间已经使用的百分比 ...
相关推荐
linux服务器上 oracle instantclient 客户端。Oracle Instant client 是oracle提供的简便客户端, 支持多种平台。 内容包含 oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-...
oracle-instantclient-basic-21.6.0.0.0-1.x86_64.rpm oracle-instantclient-basic-21.6.0.0.0-1.x86_64.zip oracle-instantclient-devel-21.6.0.0.0-1.x86_64.rpm oracle-instantclient-sqlplus-21.6.0.0.0-1.x86_...
最近需要在appserver上安装oracle client,前几天刚下载下来的oracle 12c,就拿来尝尝鲜,并随笔记录下来安装过程;请大家多多指教;
oracle即时客户端 instantclient-basic-linux.x64-11.2.0.4.0.zip
linux环境中的oracle客户端远程安装包 oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64....
oracle Instant Client(11.2.0.4) for Linux x86-64 (64-bit) zip包,解压后添加path路径直接就能用了 export PATH=/opt/oracle/instantclient_11_2:$PATH
linux下oracle12g客户端,包含常用工具如:sqlplus、sqlldr、exp、imp,是官网以下版本的集合,方便大家使用。 instantclient-basic-linux.x64-12.2.0.1.0.zip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip ...
最新 instantclient-basic-linux.x64-11.2.0.4.0最新 instantclient-basic-linux.x64-11.2.0.4.0最新 instantclient-basic-linux.x64-11.2.0.4.0最新 instantclient-basic-linux.x64-11.2.0.4.0最新 instantclient-...
instantclient-basic-linux.x64-11.2.0.4.0.zip instantclient-jdbc-linux.x64-11.2.0.4.0.zip instantclient-odbc-linux.x64-11.2.0.4.0.zip instantclient-sdk-linux.x64-11.2.0.4.0.zip instantclient-sqlplus-...
Instant Client for Microsoft Windows (x64),instantclient-basic-windows.x64-12.2.0.1.0.zip
sudo alien -i /home/ubuntu/oracle-instantclient-basic-21.1.0.0.0-1.x86_64.rpm sudo alien -i /home/ubuntu/oracle-instantclient-devel-21.1.0.0.0-1.x86_64.rpm sudo alien -i /home/ubuntu/oracle-instant...
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm --包含头文件和示例文件,为开发Oracle应用程序的即时客户端; 1.2 使用rpm -ivh [包名] 进行安装, 如:rpm -ivh oracle-instantclient11.2-basic-11.2....
oracle客户端instantclient-linux.x64-12.2.0.1.0,包含instantclient-basic-linux.x64-12.2.0.1.0、instantclient-sdk-linux-12.2.0.1.0、instantclient-sqlplus-linux-12.2.0.1.0
OracleClient-19C Oracle客户端,包括windows和Linux
instantclient_12_2(Linux版oracle客户端)
oracle-instantclient19.6-basic-19.6.0.0.0-1.x86_64.rpm oracle-instantclient19.6-devel-19.6.0.0.0-1.x86_64.rpm
Oracle Instant client 是oracle提供的简便客户端,instantclient-basic-linux-11.2.0.3.0
环境表述: oracle11gR2数据库安装在虚拟机(CentOS5.5 64bit)上,数据库名orcl,有用户test。... 介质:instantclient-basic-win32-11.2.0.1.0.zip。 目标: PL/SQL通过instance client连接到虚拟机上的数据库orcl
OracleClient-18C Oracle客户端,包括windows和Linux
Linux下的Oracle Instant Client开发包.rpm包。对应的数据库版本为Oracle12c。