- 论坛徽章:
- 0
|
oralce 9 的连接问题 (两天没睡觉了,饭也只吃了两顿)
data1$lsnrctl status
LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 17-APR-2004 00:27:41
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=data)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
Start Date 17-APR-2004 00:25:36
Uptime 0 days 0 hr. 2 min. 4 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /export/oracle/product/network/admin/listener.ora
Listener Log File /export/oracle/product/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.192.1.90)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service " LSExtProc" has 1 instance(s).
Instance " LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
data1$tnsping 10.192.1.90
TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on 17-APR-2004 00:2
9:12
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=10.192.1.9
0))(ADDRESS=(PROTOCOL=TCP)(HOST=10.192.1.90)(PORT=1521)))
OK (0 msec) |
|