在solaris操作系统下使用Oracle10.1g廋客户端

 

在solaris操作系统下使用Oracle10.1g廋客户端

liuxuezong

一、下载必要的资源包

从Oracle官方网站上下载安装包，选择Version 10.1.0.5即可。

http://www.oracle.com/technetwork/topics/solsoft-094353.html

 

Version 10.1.0.5   Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications

 instantclient-basic-solaris32-10.1.0.5-20060502.zip (37,318,944 bytes) (cksum - 1748114228)

 

*Instant Client Package - JDBC Supplement: Additional support for XA, Internationalization, and RowSet operations under JDBC

 instantclient-jdbc-solaris32-10.1.0.5-20060502.zip (4,649,761 bytes) (cksum - 2161919621)

 

*Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client 

instantclient-sqlplus-solaris32-10.1.0.5-20060502.zip (635,088 bytes) (cksum - 3995088606)

 

*Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client 

 instantclient-sdk-solaris32-10.1.0.5-20060502.zip (294,409 bytes) (cksum - 2371771795)

 

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.

  

二、目录安排

把上述几个文件解压到/oracle/instantclient10_1目录中

/oracle/ 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下该文件配置正确即可。

   

tnsnames.ora:

# tnsnames.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

MYORACLE =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.239.2)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

 

ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.239.2)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

 

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

  

三、环境变量配置

    1、在/etc/profile文件里添加如下配置

ORACLE_HOME=/oracle/instantclient10_1

PATH=$ORACLE_HOME/bin:$PATH

NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export ORACLE_HOME PATH  NLS_LANG LD_LIBRARY_PATH

    2、生效命令

#source profile “注意solaris10该命令不存在，您可以注销一下！”

    3、环境变量查看

#env |grep ORACLE_HOME

 

四、验证效果

使用sqlplus查询，如果出现如下信息，orale client基本安装完成。

用户名:username

密  码: password

服务名: myoracle

三项基本信息要根据你自己系统实际配置。

# sqlplus username/password@myoracle

 SQL*Plus: Release 10.1.0.5.0 - Production on 星期二 10月 11 09:00:06 2011

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

连接到:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

 

SQL> 

 

五、其他问题

    为了能够访问Oracle10g的服务器，您必须保证环境变量正确配置以及内部网络的正常。

A、查看本机网络正常否

#ifconfig –a

lo0: flags=2001000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4,VIRTUAL> mtu 8232 index 1

        inet 127.0.0.1 netmask ff000000

e1000g0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 2

        inet 192.168.239.100 netmask ffffff00 broadcast 192.168.239.255

        ether 0:c:29:9d:9c:79

#

 

B、查看Oracle10g服务是否能够连接

# ping 192.168.239.2

192.168.239.2 is alive

#