Oracle双监听器的配置(二)
s 0 hr. 24 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/water.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.113)(PORT=1522)))
Services Summary...
Service "emrep.us.oracle.com" has 1 instance(s).
Instance "emrep", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
㈢ 测试
① tnsping
[sql]
[oracle@localhost admin]$ tnsping water
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2012 21:53:13
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS=(PROTOCOL= tcp)(HOST= 192.168.1.113)(PORT= 1522)) (CONNECT_DATA=(SERVICE_NAME= emrep.us.oracle.com)))
OK (10 msec)
② netstat
[sql]
[oracle@localhost admin]$ netstat -lntp| grep :15
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 8524/tnslsnr
tcp 0 0 192.168.1.113:1522 0.0.0.0:* LISTEN 9826/tnslsnr
③ conn
[sql]
sys@EMREP> conn u1/u1@water
Connected.