grid@acctdb1:/export/home/grid $crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE acctdb1 ONLINE ONLINE acctdb2 ora.LISTENER_CRM3EOP.lsnr ONLINE ONLINE acctdb1 ONLINE ONLINE acctdb2
4、修改local参数:
一节点:
SYS@crm3eop1> show parameter &name Enter value for name: local
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST= 135.32.61.12)(PORT=1522)) log_archive_local_first boolean TRUE parallel_force_local boolean TRUE SYS@crm3eop1> SYS@crm3eop1> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=135.32.61.12)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=135.32.61.12)(PORT=1722))))' sid='acctdb1';
System altered.
Elapsed: 00:00:00.04 SYS@crm3eop1> show parameter &name Enter value for name: local
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=TCP)(HOST=135. 32.61.12)(PORT=1522))(ADDRESS= (PROTOCOL=TCP)(HOST=135.32.61. 12)(PORT=1722)))) log_archive_local_first boolean TRUE parallel_force_local boolean TRUE SYS@crm3eop1>
二节点:
SYS@crm3eop2> show parameter &name Enter value for name: local
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST= 135.32.61.13)(PORT=1522)) log_archive_local_first boolean TRUE parallel_force_local boolean TRUE SYS@crm3eop2> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=135.32.61.13)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=135.32.61.13)(PORT=1722))))' sid='acctdb2';
System altered.
Elapsed: 00:00:00.03 SYS@crm3eop2> show parameter &name Enter value for name: local
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=TCP)(HOST=135. 32.61.13)(PORT=1522))(ADDRESS= (PROTOCOL=TCP)(HOST=135.32.61. 13)(PORT=1722)))) log_archive_local_first boolean TRUE parallel_force_local boolean TRUE SYS@crm3eop2>
5、注册监听:
SYS@crm3eop1> alter system register;
System altered.
Elapsed: 00:00:00.00 SYS@crm3eop1>
SYS@crm3eop2> alter system register;
System altered.
Elapsed: 00:00:00.00 SYS@crm3eop2>
6、查看监听:
grid@acctdb1:/export/home/grid $lsnrctl stat LISTENER_CRM3EOP
LSNRCTL for Solaris: Version 11.2.0.4.0 - Production on 30-OCT-2018 21:54:29
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_CRM3EOP))) STATUS of the LISTENER ------------------------ Alias LISTENER_CRM3EOP Version TNSLSNR for Solaris: Version 11.2.0.4.0 - Production Start Date 30-OCT-2018 21:43:24 Uptime 0 days 0 hr. 11 min. 6 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/acctdb1/listener_crm3eop/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_CRM3EOP))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=135.32.61.10)(PORT=1722))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=135.32.61.12)(PORT=1722))) Services Summary... Service "crm3eop" has 1 instance(s). Instance "crm3eop1", status READY, has 1 handler(s) for this service... Service "crm3eopXDB" has 1 instance(s). Instance "crm3eop1", status READY, has 1 handler(s) for this service... Service "crm3eop_taf" has 1 instance(s). Instance "crm3eop1", status READY, has 1 handler(s) for this service... The command completed successfully grid@acctdb1:/export/home/grid $