分类： Oracle
2006-08-30 18:39:03
| oracle@blueice:~/product/9.2.0/network/admin$ lsnrctl stat LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 30-AUG-2006 23:16:34 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=blueice.blueice.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production Start Date 30-AUG-2006 20:21:51 Uptime 0 days 2 hr. 54 min. 43 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /home/oracle/product/9.2.0/network/admin/listener.ora Listener Log File /home/oracle/product/9.2.0/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=1521))) Services Summary... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orcl.blueice.com" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully oracle@blueice:~/product/9.2.0/network/admin$ lsnrctl stat LISTENERB LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 30-AUG-2006 23:16:41 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=blueice.blueice.com)(PORT=1531))) STATUS of the LISTENER ------------------------ Alias LISTENERB Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production Start Date 30-AUG-2006 23:14:14 Uptime 0 days 0 hr. 2 min. 27 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /home/oracle/product/9.2.0/network/admin/listener.ora Listener Log File /home/oracle/product/9.2.0/network/log/listenerb.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=1531))) Services Summary... Service "orcl.blueice.com" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully |
| LISTENERS_BLUEICE = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = BLUEICE)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = BLUEICE)(PORT = 1531)) ) |
| racle@blueice:~/product/9.2.0/network/admin$ sqlplus /nolog SQL*Plus: Release 9.2.0.4.0 - Production on Wed Aug 30 23:18:02 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> conn / as sysdba Connected. SQL> show parameter local NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string SQL> alter system set local_listener="LISTENERS_BLUEICE"; System altered. SQL> alter system register 2 ; System altered. SQL> host lsnrctl stat LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 30-AUG-2006 23:18:41 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=blueice.blueice.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production Start Date 30-AUG-2006 20:21:51 Uptime 0 days 2 hr. 56 min. 50 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /home/oracle/product/9.2.0/network/admin/listener.ora Listener Log File /home/oracle/product/9.2.0/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=1521))) Services Summary... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orcl.blueice.com" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully SQL> host lsnrctl stat LISTENERB LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 30-AUG-2006 23:18:54 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=blueice.blueice.com)(PORT=1531))) STATUS of the LISTENER ------------------------ Alias LISTENERB Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production Start Date 30-AUG-2006 23:14:14 Uptime 0 days 0 hr. 4 min. 40 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /home/oracle/product/9.2.0/network/admin/listener.ora Listener Log File /home/oracle/product/9.2.0/network/log/listenerb.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=1531))) Services Summary... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orcl.blueice.com" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production |
| blueice:~# netstat -lnp|grep \:15 tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 4716/tnslsnr tcp 0 0 0.0.0.0:1531 0.0.0.0:* LISTEN 10237/tnslsnr |
