This discussion is archived
12 Replies Latest reply: Jun 8, 2010 6:09 PM by wwdxwl RSS

TNS-12537: TNS: connection closed

wwdxwl Newbie
Currently Being Moderated
lsnrctl start No error occurs,The client connect to database listener log error


tnsping vis

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-6月 -
2010 14:55:54

Copyright (c) 1997, 2005, Oracle. All rights reserved.

已使用的参数文件:
d:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora


已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.
102.205)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = VIS) (INSTANCE_NAME = VIS
)))
TNS-12537: TNS: connection closed


Listener.log

TNSLSNR for Linux: Version 9.2.0.6.0 - Production on 07-JUN-2010 09:10:36

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is /ora/visdb/9.2.0/network/admin/VIS_erpsun/listener.ora
Log messages written to /ora/visdb/9.2.0/network/log/listener.log
Trace information written to /ora/visdb/9.2.0/network/trace/listener.trc
Trace level is currently 0

Started with pid=26851
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpsun.sunits.net)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
07-JUN-2010 09:10:36 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=erpsun.sunits.net)(USER=oraprod))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093632)) * status * 0

07-JUN-2010 09:11:29 * 12546
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied

08-JUN-2010 09:01:39 * 12546
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points