多实例监听的配置
三种情况:
1、一个监听在一个IP一个端口上监听多个实例
2、一个监听在一个IP不同端口上监听多个实例
3、多个监听监听多个实例
情况1:
listener.ora文件:
<code># listener.ora Network Configuration File: E:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora</code>
<code># Generated by Oracle configuration tools.</code>
<code>SID_LIST_ORCL =</code>
<code> </code><code>(SID_LIST =</code>
<code> </code><code>(SID_DESC =</code>
<code> </code><code>(GLOBAL_DBNAME = ORCL)</code>
<code> </code><code>(SID_NAME = ORCL)</code>
<code> </code><code>)</code>
<code> </code><code>(GLOBAL_DBNAME = NHL)</code>
<code> </code><code>(SID_NAME = NHL)</code>
<code> </code><code>)</code>
<code>ORCL =</code>
<code> </code><code>(DESCRIPTION_LIST =</code>
<code> </code><code>(DESCRIPTION =</code>
<code> </code><code>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1521))</code>
<code> </code><code>(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))</code>
<a href="http://s3.51cto.com/wyfs02/M01/53/AE/wKioL1Rtmg3B1mfcAAHiMffyG2Y429.jpg" target="_blank"></a>
<a href="http://s3.51cto.com/wyfs02/M01/53/B0/wKiom1RtmZXQUCh5AAHQps7Bd4Q040.jpg" target="_blank"></a>
tnsnames.ora文件:
<code># tnsnames.ora Network Configuration File: E:\app\product\11.2.0\dbhome_1\network\admin\tnsnames.ora</code>
<code>NHL =</code>
<code> </code><code>(DESCRIPTION =</code>
<code> </code><code>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1521))</code>
<code> </code><code>(CONNECT_DATA =</code>
<code> </code><code>(SERVER = DEDICATED)</code>
<code> </code><code>(SERVICE_NAME = NHL)</code>
<code> </code><code>(SERVICE_NAME = orcl)</code>
<a href="http://s3.51cto.com/wyfs02/M02/53/AE/wKioL1RtmjuA3gtfAAGmnOLTyJI386.jpg" target="_blank"></a>
<a href="http://s3.51cto.com/wyfs02/M01/53/B0/wKiom1RtmcPgLo6EAAGmvHq-ocw883.jpg" target="_blank"></a>
情况2:
<code> </code><code>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1522))</code>
<code> </code><code>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1522))</code>
情况3:
<code>SID_LIST_TEST =</code>
<code> </code><code>(GLOBAL_DBNAME = TEST)</code>
<code> </code><code>(SID_NAME = TEST)</code>
<code>)</code>
<code>TEST =</code>
<code> </code><code>(DESCRIPTION =</code>
<code> </code><code>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1523))</code>
<code> </code><code>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.152.131)(PORT = 1523))</code>
<code> </code><code>(SERVICE_NAME = </code><code>test</code><code>)</code>
改完配置并启动。
本文转自ling118 51CTO博客,原文链接:http://blog.51cto.com/meiling/1580178,如需转载请自行联系原作者