oracle提供了五种网络服务解析

向右看齐 2021-09-10 09:58 240阅读 0赞

<table style="direction:ltr; border-collapse:collapse; border-style:solid; border-color:#A3A3A3; border-width:1pt"> 
 <tbody> 
 <tr> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:.6673in; padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:8.9145in; padding:4pt 4pt 4pt 4pt"> oracle提供了五种网络服务解析： 1、Oracle Internet Directory 2、External Naming 3、host naming 4、Oracle Easy Connect 5、local naming </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:.6673in; padding:4pt 4pt 4pt 4pt"> 1 </td> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:8.9145in; padding:4pt 4pt 4pt 4pt"> Oracle Internet Directory：管理许多Oracle服务器的复杂网络时有优势，管理员可以在一个比较集中位置配置和管理Net Service Names。 </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:.6673in; padding:4pt 4pt 4pt 4pt"> 2 </td> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:8.9145in; padding:4pt 4pt 4pt 4pt"> External Naming：使用非Oracle工具管理和解析Oracle服务名称 </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:.6673in; padding:4pt 4pt 4pt 4pt"> 3 </td> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:8.9145in; padding:4pt 4pt 4pt 4pt"> host naming：主机命名方法(客户端为windows xp,服务器端为linux+oracle 9i) 1、配置客户端的sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME) &nbsp; 2、配置服务器端的listener.ora LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle)(PORT = 1521)) #注意HOST配置为主机名 ) &nbsp; SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = linuxoracle) #注意GLOBAL_DBNAME为主机名 (ORACLE_HOME = /u01/app/oracle/product/9.2.0) (SID_NAME = dg1) ) (SID_DESC = (GLOBAL_DBNAME = linuxoracle) (ORACLE_HOME = /u01/app/oracle/product/9.2.0) (SID_NAME = OEMREP) ) ) 3、链接： &nbsp;C:Documents and Settings ew&gt;sqlplus system/lijie123@linuxoracle 注： 1、如果没有正确配置GLOBAL_DBNAME,sqlplus连接时，会报如下错误: &nbsp;ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 2、ORA-12154: TNS: 无法解析指定的连接标识符。可能是客户端hosts或dns问题，打开hosts # 102.54.94.97 rhino.acme.com # source server # 38.25.63.10 x.acme.com # x client host 127.0.0.1 localhost 修该为: ............................................................... # 102.54.94.97 rhino.acme.com # source server # 38.25.63.10 x.acme.com # x client host 127.0.0.1 localhost 192.168.1.61 linuxoracle &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:.6673in; padding:4pt 4pt 4pt 4pt"> 4 </td> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:8.9145in; padding:4pt 4pt 4pt 4pt"> Oracle Easy Connect </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:.6673in; padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:8.9145in; padding:4pt 4pt 4pt 4pt"> 1、使用oracle easy connect naming必须满足以下要求 
 <ul style="margin-left:.375in; direction:ltr; unicode-bidi:embed; margin-top:0in; margin-bottom:0in"> 
 <li style="margin-top:0; margin-bottom:0; vertical-align:middle">Oracle 10g以上版本支持；</li> 
 <li style="margin-top:0; margin-bottom:0; vertical-align:middle">客户端及服务器端必须支持TCP/IP,并启用；</li> 
 <li style="margin-top:0; margin-bottom:0; vertical-align:middle">不允许高级连接描述符特性，如:连接池、外部过程调用；</li> 
 </ul> 2、配置oracle easy connect naming 在sqlnet.ora增加下面这行： NAMES.DIRECTORY_PATH=(EZCONNECT,TNSNAMES) #注意增加了EZCONNECT &nbsp; 3、oracle easy connect naming方法示例 eg: connect scott/tiger@hostname:port/servicesname connect scott/tiger@//hostname/servicesname &nbsp; 解释： 语法构件 描述 // 任选：通过URL连接时使用 hostname 必选： 主机名或IP port 任选：端口号 servicesname 必选：oracle服务的名称 &nbsp; plsql developer使用easy connect的方式连接,如下图: <img src="https://img-blog.csdn.net/20140923175454531?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbGl1eGlhbzcyMzg0Ng==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt=""> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:.6673in; padding:4pt 4pt 4pt 4pt"> 5 </td> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:8.9145in; padding:4pt 4pt 4pt 4pt"> 本地命名法，也叫tnsnames.ora方法 </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:.6673in; padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 <td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:8.9145in; padding:4pt 4pt 4pt 4pt"> 客户端tnsnames.ora中添加如下内容： TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.61)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dg1) ) </td> 
 </tr> 
 </tbody> 
</table>