数据库|mysql教程
Oracle教程,在Linux操作系统下使用Oracle 1
数据库-mysql教程
充值的页面模板源码,vscode结果输出窗口,ubuntu如何使用,tomcat端口8003,sqlite3的基本使用,爬虫工具和数据清洗工具都有哪些,php服务器一键安装,江苏正规seo优化排行,网站模板下载mbxzb,响应式模板网站模板lzw
A、下载必要的资源包 从Oracle官方网站上下载安装包，选择Version 10.1.0.5即可。 /technetwork/topics/
safari网页源码,vscode做C程序,win远程ubuntu,tomcat 内存 参数,sqlite中查询的结果是,个人网页设计策划书,数据库分表 查询,用自己的服务器建网站,闹钟 节假日插件,web前端框架开发教程交流,地球爬虫,php小程序源码,商品seo,springboot查视图,a标签包含太深 seo,基于tp3.2.1的通用网站后台,呼死你网页免费试用,emlog论坛模板,织梦后台文章不能删除,将div漂浮在页面右边,java 广告管理系统源码,带采集的电影程序lzw
qq头源码,vscode默认应用设置,ubuntu 病毒处理,tomcat入口文件,sqlite文件修复工具,大型网站前端一般用的什么框架,抓去头条视频的爬虫程序,php是后端吗,台州天台seo公司,极简手机网站模板,div css静态中文网页模板,eclipse 样式模板lzw
A、下载必要的资源包
从Oracle官方网站上下载安装包，选择Version 10.1.0.5即可。
Version 10.1.0.5 Instant Client Package – Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
instantclient-basic-linux32-10.1.0.5-0511.zip (31,413,713 bytes) (cksum – 384697539)
*Instant Client Package – JDBC Supplement: Additional support for XA, Internationalization, and RowSet operations under JDBC
instantclient-jdbc-linux32-10.1.0.5-0511.zip (4,649,614 bytes) (cksum – 753190421)
*Instant Client Package – SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client
instantclient-sqlplus-linux32-10.1.0.5-0511.zip (331,854 bytes) (cksum – 722849044)
*Instant Client Package – SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client
instantclient-sdk-linux32-10.1.0.5-0511.zip (294,618 bytes) (cksum – 4282446920)
Optional packages are marked with a *.
Installation Steps:
1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic package.
2. Unzip the packages into a single directory such as “instantclient”.
3. Set the library loading path in your environment to the directory in Step 2 (“instantclient”). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used.
4. Start your application and enjoy.
B、目录安排
把上述几个文件解压到/home/ instantclient10_1目录中
/home/ instantclient10_1
|_bin
|_sqlplus
|_lib
|_ libclntsh.so.10.1，libnnz10.so，libociei.so，libsqlplus.so
|_network
|_admin
|_tnsnames.ora
|_sqlplus
|_admin
|_glogin
|_mesg
|_sp1us.msb，sp1us.msg，sp1zhs.msb等
tnsnames.ora文件可以从X:\oracle\product\10.2.0\db_1\NETWORK\ADMIN目录下拷贝即可，，这样您只要保证在WINDOWS下该文件配置正确即可。
C、环境变量配置
1、在/etc/profile文件里添加如下配置
ORACLE_HOME=/home/instantclient10_1
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export ORACLE_HOME PATH LD_LIBRARY_PATH
2、生效命令
#source profile
3、环境变量查看
#env |grep ORACLE_HOME
D、验证效果
使用sqlplus查询，如果出现如下信息，orale client基本安装完成。
用户名:username
密 码: password
服务名: myoracle
三项基本信息要根据你自己系统实际配置。
# sqlplus username/password@myoracle
SQL*Plus: Release 10.1.0.5.0 – Production on Wed Sep 7 11:26:13
Copyright (c) 1982, , Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
SQL>
On other platforms the two packages should be unzipped into one directory, for example, /home/instantclient10_1 on UNIX or c:\instantclient10_1 on
D、动态库比较
Windows. This table shows the Oracle client-side files required to deploy SQL*Plus Instant Client 10.1.
Platform
Description
Package
UNIX/Linux
Windows
sqlplus
sqlplus.exe
SQL*Plus executable
SQL*Plus
libsqlplus.so
not applicable
SQL*Plus library
glogin.sql
glogin.sql
SQL*Plus site profile
libclntsh.so.10.1
oci.dll
Client code library
Basic
libociei.so
oraociei10.dll
OCI Instant Client data shared library
如果觉得《在Linux操作系统下使用Oracle 10.1g廋客户端》对你有帮助，请点赞、收藏，并留下你的观点哦！
