Oracle11g客户端client的下载与安装,PLSQL配置连接ORACLE

时间：2024-02-16 14:41:53

下载地址：http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html?ssSourceSiteId=otncn

备注：注册账号后即可下载

 

 

 

二、解压安装

 

三、安装报错：引用数据不可用于验证此操作系统分发的先决条件
原因：Oracle Client 11g版本不支持最新的Win10系统。 

解决方案：

打开Oracle Client 11g安装包目录：\client\stage\cvu

编辑该目录下的两个xml文件：oracle.client_InstantClient.xml和cvu_prereq.xml

 oracle.client_InstantClient.xml：

<?xml version="1.0"?>
<HOST PLATID="233">
    <SYSTEM>
        <MEMORY>
            <PHYSICAL_MEMORY VALUE="128" UNIT="MB" SEVERITY="IGNORABLE"/>
            <!--<AVAILABLE_MEMORY VALUE="20" UNIT="MB"/> -->
        </MEMORY>
    </SYSTEM>
    <CERTIFIED_SYSTEMS>
        <OPERATING_SYSTEM RELEASE="5.0">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="Windows2000"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="5.1">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="WindowsXP"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="5.2">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="Windows Server 2003"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.0">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="WindowsServer2008"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.0">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="WindowsVista"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.1">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="Windows 7"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.1">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="WindowsServer2008R2"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.2">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="Windows 10"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="5119" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
    </CERTIFIED_SYSTEMS>
    <ORACLE_HOME>
        <COMPATIBILITY_MATRIX>
            <ALLOW>
                <NEW_HOME/>
            </ALLOW>
            <DISALLOW>
                <COMP NAME="oracle.server" ATLEAST="8.1.0.0.0" ATMOST="11.2.9.9.9"/>
                <COMP NAME="oracle.client" ATLEAST="8.1.0.0.0" ATMOST="11.2.9.9.9"/>
                <COMP NAME="oracle.iappserver.iapptop" ATLEAST="9.0.2.0.0" ATMOST="9.0.9.0.0"/>
                <COMP NAME="oracle.iappserver.infrastructure" ATLEAST="9.0.2.0.0" ATMOST="9.0.9.0.0"/>
                <COMP NAME="oracle.iappserver.devcorner " ATLEAST="9.0.2.0.0" ATMOST="9.0.9.0.0"/>
                <COMP NAME="oracle.ids.toplevel.development" ATLEAST="9.0.0.0.0" ATMOST="9.0.9.0.0"/>
                <COMP NAME="oracle.install.instcommon" ATLEAST="8.1.3.0.0" ATMOST="9.2.9.9.9"/>
                <COMP NAME="oracle.networking.netclt" ATLEAST="8.1.3.0.0" ATMOST="9.2.0.9.0"/>
                <COMP NAME="ocommon" ATLEAST="7.3.2" ATMOST="8.0.7"/>
            </DISALLOW>
        </COMPATIBILITY_MATRIX>
    </ORACLE_HOME>
</HOST>

cvu_prereq.xml：

<?xml version="1.0"?>
<HOST PLATID="912">
    <SYSTEM>
        <MEMORY>
            <PHYSICAL_MEMORY VALUE="128" UNIT="MB" SEVERITY="IGNORABLE"/>
            <!--<AVAILABLE_MEMORY VALUE="20" UNIT="MB"/> -->
        </MEMORY>
        <SPACE>
            <LOC VAR="TEMP_AREA" TEMP="true" SIZE="130" UNIT="MB" SEVERITY="IGNORABLE"/>
        </SPACE>
    </SYSTEM>
    <CERTIFIED_SYSTEMS>
        <OPERATING_SYSTEM RELEASE="5.0">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="32-bit"/>
            <NAME VALUE="Windows2000"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="5.1">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="32-bit"/>
            <NAME VALUE="WindowsXP"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="5.2">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="32-bit"/>
            <NAME VALUE="Windows Server 2003"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.0">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="32-bit"/>
            <NAME VALUE="WindowsServer2008"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.0">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="32-bit"/>
            <NAME VALUE="WindowsVista"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.1">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="32-bit"/>
            <NAME VALUE="Windows 7"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.2">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="Windows 8"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.2">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="32-bit"/>
            <NAME VALUE="Windows 8"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
        <OPERATING_SYSTEM RELEASE="6.2">
            <VERSION VALUE="3"/>
            <ARCHITECTURE VALUE="64-bit"/>
            <NAME VALUE="Windows 10"/>
            <ENV_VAR_LIST>
                <ENV_VAR NAME="PATH" MAX_LENGTH="5119" />
            </ENV_VAR_LIST>
        </OPERATING_SYSTEM>
    </CERTIFIED_SYSTEMS>
    <ORACLE_HOME>
        <COMPATIBILITY_MATRIX>
            <ALLOW>
                <NEW_HOME/>
                <COMP NAME="oracle.server" ATLEAST="11.2.0.0.0" ATMOST="11.2.9.9.9"/>
                <COMP NAME="oracle.client" ATLEAST="11.2.0.0.0" ATMOST="11.2.9.9.9"/>
            </ALLOW>
            <DISALLOW>
                <COMP NAME="oracle.server" ATLEAST="8.1.0.0.0" ATMOST="10.2.9.9.9"/>
                <COMP NAME="oracle.client" ATLEAST="8.1.0.0.0" ATMOST="9.2.0.9.0"/>
                <COMP NAME="oracle.iappserver.iapptop" ATLEAST="9.0.2.0.0" ATMOST="9.0.9.0.0"/>
                <COMP NAME="oracle.iappserver.infrastructure" ATLEAST="9.0.2.0.0" ATMOST="9.0.9.0.0"/>
                <COMP NAME="oracle.iappserver.devcorner " ATLEAST="9.0.2.0.0" ATMOST="9.0.9.0.0"/>
                <COMP NAME="oracle.ids.toplevel.development" ATLEAST="9.0.0.0.0" ATMOST="9.0.9.0.0"/>
                <COMP NAME="oracle.install.instcommon" ATLEAST="8.1.3.0.0" ATMOST="9.2.9.9.9"/>
                <COMP NAME="oracle.networking.netclt" ATLEAST="8.1.3.0.0" ATMOST="9.2.0.9.0"/>
                <ORCA_HOME/>
            </DISALLOW>
        </COMPATIBILITY_MATRIX>
    </ORACLE_HOME>
</HOST>

三、PLSQL配置连接

3.1  配置plsql ——工具——连接配置oracle 主目录名路径和coi 库路径

 

 

 3.2 在系统环境变量中配置ORACLE_HOME ， 变量值一般是在bin的上一级目录

 

 

 3.3 最后配置监听：D:\Oracle\Instant Client\network\admin 文件夹下面的tnsnames.ora写入你要连接的库

# tnsnames.ora Network Configuration File: D:\oracleClient\oraclePath\product\11.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

CCWB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.178.11.9)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = autonavi)
    )
  )

 

 

 

 tnsnames.ora补充完成后可在查看

 

 

 

配置成功后可使用plsql可以看到tnsnames.ora中的CCWB已配置在此，即可连接成功。若连接不成功，需检查tnsnames.ora中的地址，端口，sid是否配置正确。

转载：https://blog.csdn.net/alex19961223/article/details/96115900

转载：https://blog.csdn.net/weinichendian/article/details/51735443

 oracle64位客户端 Instant Client v11.2.0.3.0(64-bit)

相关文章