win 10系统下配置Oracle Instant Client 和 PLSQL Develope连接Red Hat系统Oracle SQL

Oracle Instant Client 官网地址：http://www.oracle.com/technetwork/cn/topics/winsoft-085727.html
PLSQL Developer 官网地址：https://www.allroundautomations.com/bodyplsqldevreg.html

安装完Oracle Client后修改Oracl Client 安装目录下的client\stage\cvu\cvu_prereq.xml
添加以下代码

        <OPERATING_SYSTEM RELEASE="6.1">
           <VERSION VALUE="3"/>
           <ARCHITECTURE VALUE="64-bit"/>
           <NAME VALUE="Windows 10"/>
           <ENV_VAR_LIST>
               <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
           </ENV_VAR_LIST> 
        </OPERATING_SYSTEM> 

整个文件内容，直接复制就可以用

<?xml version="1.0"?>
<HOST PLATID="233">
<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="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.1">
           <VERSION VALUE="3"/>
           <ARCHITECTURE VALUE="64-bit"/>
           <NAME VALUE="Windows 10"/>
           <ENV_VAR_LIST>
               <ENV_VAR NAME="PATH" MAX_LENGTH="1023" />
           </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>

Oracle数据库和客户端安装完毕以后，需要先配置服务器的监听服务

1. ——修改 服务器oracle11g下的 listener.ora文件

   C:\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN\listener.ora 修改 2 处

   第一处：在SID_LIST内部，增加SID_DESC描述，如下。

   (SID_DESC =
   (SID_NAME = orcl)
   (ORACLE_HOME = c:\app\Administrator\product\11.2.0\dbhome_1)
   (PROGRAM = extproc)
   (ENVS = “EXTPROC_DLLS=ONLY:c:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll”)
   )

   第二处：将下面的HOST的值修改成服务器的IP地址，如：

   LISTENER =
   (DESCRIPTION_LIST =
   (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   )
   )

2. ——修改 同一目录下的 tnsnames.ora 文件

   C:\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN\tnsnames.ora 修改 2 处，都是IP

   将文件中，两个HOST的IP值都修改成服务器的IP地址， 如：

   LISTENER_ORCL =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   ……

   ORCL =
   (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = orcl)
   )
   )

3. ——重新启动Oracle服务。

   OracleServiceORCL 和 OracleOraDb11g_home2TNSListener

   第一步：以超级管理员用户登录数据库
   [oracle@sandy ~]$ sqlplus / as sysdba

   第二步: 启动Oracle服务器
   SQL> startup
   第三步: 启动oracle监听服务
   [oracle@sandy ~]$ lsnrctl start
   然后登陆PLSQL Developer即可