- 浏览: 190954 次
- 性别:
- 来自: 杭州
文章分类
最新评论
-
find13:
学习
iReport中文教程 -
coderfly:
thanks !
iReport中文教程 -
月亮不懂夜的黑:
下载 学习。thanks!
iReport中文教程 -
yanqingluo:
谢谢,先转走.再验证.
eclipse maven debug -
周佳1986:
谢谢,分享。
iReport中文教程
转自:https://help.ubuntu.com/community/Oracle%20Instant%20Client
Introduction
Oracle Instant Client is a free Oracle database client. The current version is 11.2.0.1.0, and several versions back to 10.1.0.5 are available.
Install RPMs
-
Download the Oracle Instantclient RPM files fromhttp://www.oracle.com/technetwork/database/features/instant-client/index-097480.html. Everyone needs either "Basic" or "Basic lite", and most users will want "SQL*Plus" and the "SDK".
-
Convert these .rpm files into .deb packages and install using "alien" ("sudo apt-get install alien" if you don't have it):
alien -i oracle-instantclient-basic*.rpm alien -i oracle-instantclient-sqlplus*.rpm alien -i oracle-instantclient-devel*.rpm
- Test your Instantclient install by using "sqlplus" to connect to your database:
sqlplus username/password@//dbhost:1521/SID
If sqlplus complains of a missing libaio.so.1 file, run
sudo apt-get install libaio1
If sqlplus complains of a missing libsqlplus.so file, follow the steps in the section "Integrate Oracle Libraries" below.
If you execute sqlplus and get "sqlplus: command not found", see the section below about adding the ORACLE_HOME variable.
Integrate Oracle Libraries
If oracle applications, such as sqlplus, are complaining about missing libraries, you can add the Oracle libraries to the LD_LIBRARY_PATH each time it is used, or to add it to the system library list create a new file as follows:
sudo vi /etc/ld.so.conf.d/oracle.conf
- and add the oracle library path as the first line. For example,
/usr/lib/oracle/11.1.0.1/client/lib
- or
/usr/lib/oracle/11.2/client/lib/
- Then run ldconfig:
sudo ldconfig
ORACLE_HOME
Many Oracle database applications look for Oracle software in the location specified in the environment variable 'ORACLE_HOME'.
Typical workstations will only have one Oracle install, and will want to define this variable in a system-wide location.
sudo vi /etc/profile.d/oracle.sh
Add the following:
export ORACLE_HOME=/usr/lib/oracle/11.1.0.1/client
or
export ORACLE_HOME=/usr/lib/oracle/11.2/client
Alternatively, each user can define this in their ~/.bash_profile
Note: For 11.04 sqlplus was not recognized as a command unless the following line was also included in the oracle.sh file:
export PATH=$PATH:$ORACLE_HOME/bin
SDK fix
Some packages may look for 'oci.h' in $ORACLE_HOME/include, or in $ORACLE_HOME/rdbms/public
The instant client sometimes places the include files, such as oci.h, in /usr/include/oracle/<version>/client.
Inspect your system by running the following commands
ls $ORACLE_HOME ls -d /usr/include/oracle/*/client
If there is no 'include' directory under ORACLE_HOME, and it is located over in /usr/include/oracle/ , create a symbolic link to assist packages looking for these header files. For example,
sudo ln -s /usr/include/oracle/11.2/client $ORACLE_HOME/include
And then check it is correct
ls $ORACLE_HOME
发表评论
-
spring事务管理的几种方式
2014-06-19 20:38 6637原文:http://sishuok.com/forum/bl ... -
【转】<maven权威指南>学习笔记
2013-06-06 12:32 1098一些常用的命令 mvn help:effective-pom ... -
ubuntu 下安装oracle客户端oracle-xe-client
2012-12-13 16:19 1634本文转自 http://os.chinaunix.net/a2 ... -
JVM监控工具介绍jstack, jconsole, jinfo, jmap, jdb, jstat
2012-12-11 23:46 5653本文转自:http://blog.csdn.net/ke ... -
iReport中文教程
2012-11-22 19:11 1839iReport中文教程 -
svn cat 查看历史版本信息
2012-11-13 12:01 9028转自:http://lee2013.iteye.com/ ... -
【转】自动ssh登录的几种方法
2012-11-01 19:50 1032本文转自 http://blueicer.blog.51cto ... -
【转】ubuntu自动登录ssh
2012-11-01 19:47 1030本文转自 http://huqilong.b ... -
Oracle 存储过程调用存储过程
2012-10-25 11:24 945create or replace procedure ... -
ORACLE 时间函数(SYSDATE)
2012-10-22 20:40 1806本文转自:http://www.cnblogs.com/jin ... -
Linux下如何保持gnome-terminal窗口执行命令后停留而不立刻关闭(gnome-terminal -x)
2012-10-17 11:46 11992Linux下如何保持gnome-terminal窗口执行命令 ... -
常见Oracle HINT的用法
2012-10-10 17:17 874常见Oracle HINT的用法 1. /*+ALL ... -
快速理解VirtualBox的四种网络连接方式
2012-10-06 11:54 939本文转自:http://www.cnblogs. ... -
大数量事务提交
2012-07-19 13:47 782一次折腾几千万的话, 那么设置一下, 有 20W了, 就 ... -
HTML页面跳转的5种方法【转】
2012-07-02 14:49 1900转自:http://blog.sina.com.cn/s/bl ... -
【转】健康成长系列之宝宝不能乱吃的那些食物 大家警惕
2012-06-05 18:40 1049转自:http://www.19lou.com/foru ... -
电脑保护色
2012-05-01 15:56 872色调(E):85 饱和度(S):95 亮度(L):2 ... -
Ubuntu apt.conf 代理
2012-04-24 16:19 1700Acquire::http::Proxy "h ... -
【转】Oracle的decode、sign、trunc函数
2012-04-20 13:46 1346本文转自 http://knowyouknowme.iteye ... -
Oracle for loop
2012-03-12 17:35 874DECLARE i number; j n ...
相关推荐
Oracle Instant Client 11.2.0.1.0是轻量级Oracle客户端,用于连接访问Oracle 9i、10g、11g 11.2.0.1.0版本的Oracle数据库。 Oracle Instant Client11.2.0.1.0 安装程序包含OCI/ OCCI、JDBC-OCI SDK(软件开发工具...
oracle instant client 32位,提供使用方法,链接如下: http://blog.csdn.net/s592652578/article/details/79447996
Oracle Instant Client 12 C Oracle12C客户端解压可用,内含配置说明
Oracle Instant Client 11g base 绿色版(32位),安装方便
Oracle Instant client 是oracle提供的简便客户端, 支持多种平台. 可从oracle网站下载,我这里为了方便上传到这儿,navacat for oracle15亲测可用!
instantclient-basic-win32-10.1.0.5-20060419 instantclient-basic-win32-10.2.0.5 instantclient-basic-win32-11.1.0.7.0 instantclient-basic-nt-11.2.0.4.0 instantclient-basic-nt-12.1.0.2.0 instantclient-...
自己制作的这个小巧的客户端(文件全部源自Oracle官方网站),原理其实很简单,就是向注册表写几个键值,非常绿色和环保。 下载后,只需要将Oracle压缩文件解压,建议放在D:\Oracle目录下,运行OracleSetup32.exe...
Oracle InstantClient是一个简化的Oracle客户端,其安装、配置过程都很简单,5分钟即可完成。 InstantClient一般不用于开发环境,而是为简化需要通过OCI访问Oracle数据库的应用程序的部署而设计的。 本安装程序...
linux服务器上 oracle instantclient 客户端。Oracle Instant client 是oracle提供的简便客户端, 支持多种平台。 内容包含 oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-...
instantclient-basic-win64-10.2.0.5.zip instantclient-basiclite-win64-10.2.0.5.zip instantclient-jdbc-win64-10.2.0.5.zip instantclient-sqlplus-win64-10.2.0.5.zip instantclient-sdk-win64-10.2.0.5.zip ...
11 32位的 oracle instantclient basic, oracle网站总崩, 提供给需要的小伙伴
instantclient-basic-win64-10.2.0.5.zip instantclient-basic-windows.x64-11.2.0.4.0.zip instantclient-basic-windows.x64-12.1.0.2.0.zip instantclient-basic-windows.x64-12.2.0.1.0.zip instantclient-basic-...
Oracle instantclient 连接数据库服务器
*********重要********** OracleXEClient64位:Oracle Instant Client__V11.2.0.3.0__64bit.exe OracleXEClient64位安装时,右键选"以兼容方式运行WindowsXP,以管理员身份运行此程序
Oracle InstantClient是一个简化的Oracle客户端,其安装、配置过程都很简单,5分钟即可完成。 InstantClient一般不用于开发环境,而是为简化需要通过OCI访问Oracle数据库的应用程序的部署而设计的。 本安装程序...
Oracle Instant Client(sdk-basic), 已经整合了 instantclient-basiclite-nt-11.2.0.4.0.zip和 instantclient-sdk-nt-11.2.0.4.0.zip
Instant Client for Microsoft Windows (x64),instantclient-basic-windows.x64-12.2.0.1.0.zip
Oracle Instant Client_12_1 Downloads 有效解决oracle library is not loaded的问题 有效解决ORA-28547:connection to server failed,probable Oracle Net admin error的问题
oracle instantclient ( instantclient-basic-nt-12.1.0.1.0.zip )
关于WIN10系统使用oracle instant client 时候提示ORA-01019错误的解决方案,本方案是配置好环境变量后依然提示ORA-01019错误的解决方案,内附本人制作测试的全过程说明