oracle 监听设置

一   静态监听设置：
在设置文件中加入,必要添加sid监听的设置
(SID_DESC =
    (SID_NAME = AIX)
    (GLOBAL_DBNAME = AIX)
     (ORACLE_HOME = /orabin/app/oracle/product/19c/db_1)
    )

1. LISTENER =
2.   (DESCRIPTION_LIST =
3.     (DESCRIPTION =
4.       (ADDRESS = (PROTOCOL = TCP)(HOST = 10.216.x.xxx)(PORT = 1521))
5.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
6.     )
7.   )
9. SID_LIST_LISTENER =
10.   (SID_LIST =
11.    (SID_DESC =
12.     (SID_NAME = AIX)
13.     (GLOBAL_DBNAME = AIX)
14.      (ORACLE_HOME = /orabin/app/oracle/product/19c/db_1)
15.     )
16.    )

复制代码

静态监听注册成功，下方出现unkown的标识（表现静态监听注册成功），静态注册时，listener.ora中的GLOBAL_DBNAME向外提供服务名，listener.ora中的SID_NAME提供注册的实例名，实例状态为UNKNOWN值时表明此服务是静态注册的设置。这时监听器用来表明它不知道关于该实例的任何信息，只有当客户发出连接请求时，它才查抄该实例是否存在

二   动态监听设置：
动态注册默认只注册到默认的监听器上(名称是LISTENER、端口是1521、协议是TCP)，因为pmon只会动态注册port等于1521的监听，否则pmon不能动态注册listener，如果必要向非默认监听注册，则必要设置local_listener参数！

• local_listener参数的利用
  
  To have PMON register with a local listener that does not use TCP/IP, port 1521, configure the LOCAL_LISTENER parameter in the initialization parameter file to locate the local listener.
  如果要利用PMON注册本地的监听，而且不适用TCP/IP，不利用默认端口1521，利用参数LOCAL_LISTENER来确定本地监听。
  For a shared server environment, you can use the LISTENER attribute of the DISPATCHERS parameter in the initialization parameter file to register the dispatchers with a nondefault local listener. Because the LOCAL_LISTENER parameter and the LISTENER attribute enable PMON to register dispatcher information with the listener, it is not necessary to specify both the parameter and the attribute if the listener values are the same.
  对于共享服务的环境下，你也可以利用初始化参数DISPATCHER参数的LISTENER参数属性，来给分发器注册一个非默认的端口，由于上述两个参数目的都是使PMON历程完成动态注册，当两个参数的值一样时，就不必要分别设置，只必要设置一个即可。
  LOCAL_LISTENER is a comma-delimited list parameter. If a comma appears in the string, then the entire string must be enclosed in double quotation marks. Set the LOCAL_LISTENER parameter as follows:
  ALTER SYSTEM SET LOCAL LISTENER=[“]listener_address[“][,…];
  For example, if the listener address “ab,cd” is entered, then it resolves to one listener address. If the address is entered as ab,cd, then it resolves to two listener addresses, ab and cd.
  For shared server connections, set the LISTENER attribute as follows:
  ALTER SYSTEM SET DISPATCHERS=”(PROTOCOL=tcp)(LISTENER=listener_address)”;
  In the preceding command, listener_address is resolved to the listener protocol addresses through a naming method, such as a tnsnames.ora file on the database server.
  

增加设置文件，此处肯定要去掉上方拷贝的IPC协议，alter system set local_listener=LISTENER_ORCL,LISTENER_ORCL1， 此中LISTENER_ORCL,LISTENER_ORCL1的值必须在tnsnames.ora声明

1. SID_LIST_LISTENER1 =
2.   (SID_LIST =
3.     (SID_DESC =
4.       (SID_NAME = CLRExtProc)
5.       (ORACLE_HOME = C:\app\Dyj\product\11.2.0\dbhome_1)
6.       (PROGRAM = extproc)
7.       (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Dyj\product\11.2.0\dbhome_1\bin\oraclr11.dll")
8.     )
9.   )
11. LISTENER1 =
12.   (DESCRIPTION_LIST =
13.     (DESCRIPTION =
14.       (ADDRESS = (PROTOCOL = TCP)(HOST = dongyj)(PORT = 1522))
15.     )
16.   )

复制代码

修改设置文件tnsnames.ora

1. LISTENER_ORCL1 =
2.   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

复制代码

设置数据库参数值：local_listener

1. SQL> alter system set local_listener=LISTENER_ORCL,LISTENER_ORCL1;
3. 系统已更改。
5. SQL> show parameters local_listener;
7. NAME                                 TYPE        VALUE
8. ------------------------------------ ----------- ------------------------------
9. local_listener                       string      LISTENER_ORCL, LISTENER_ORCL1

复制代码

启动监听，并完成动态注册

启动监听：listener

启动监听：listener1

实行动态注册下令：alter system register

listener动态监听成功

listener1动态监听成功

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。