According to Metalink:
Symptoms
This problem occurs when a statically defined service handler of a 10.2
listener is used to connect to a 10.1 (or other version) database. The
same clients connecting through dynamic service handlers work properly.
[mseibt]/u01/app/oracle/product/10.1.0> sqlplus scott/[Email Address Removed] Release 10.1.0.4.0 - Production on Tue Dec 6 14:40:44 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12537: TNS:connection closed
--------------------------------------
Cause
With a dynamically registered service handler, the 10.1 database
supplies the 10.2 listener with its local environment variables
including the path to (10.1) libraries that the client must use to make
the connection.
In a situation where the service handler is statically defined, the
listener may not have the appropriate library path needed for the
connection.
Solution
Provide the library path of the target database home in the static
handler definition of the listener.ora.
To do this, use the listener parameter ENVS parameter to specify
environment variables for the listener to set prior to executing
(as a child process) a dedicated server process.
Usage: (ENVS="variable=value")
Example (Solaris):
(SID_DESC =
(GLOBAL_DBNAME = N101.us.oracle.com)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0)
(SID_NAME = N101)
(ENVS = "LD_LIBRARY_PATH=/u01/app/oracle/product/10.1.0/lib")
)
-----Original Message-----
From: Jennifer
[mailto:oracledba-ezmlmshield-x28325230.[Email address protected]
Sent: Friday, February 29, 2008 2:04 PM
To: LazyDBA Discussion
Subject: ORA-12537: TNS:connection closed
Can someone help solve this problem:
VCS monitor cluster database:
signon error shutdown database:
Error from VCS log:
Connected to:Oracle9i Enterprise Edition Release 9.2.0.4.0 -
ProductionWith the Partitioning, OLAP and Oracle Data Mining
optionsJServer Release 9.2.0.4.0 - Production
SQL> ERROR:ORA-12537: TNS:connection closed
TAG_D 2008/02/25 18:49:52 (springer) VCS:13067:Agent is calling clean
for resource(PortlPrdDBOracle_vcs) because the resource became OFFLINE
unexpectedly, on its own.TAG_C 2008/02/25 18:49:53 (springer)
VCS:154206:Oracle:PortlPrdDBOracle_vcs:clean:returned the following
output:LD_LIBRARY_PATH -
/usr/lib:/u01/app/oracle/product/9.2.0.4/lib:/usr/lib:/usr/local/lib:/us
r/openwin/lib:/usr/ucb/lib:/usr/dt/lib
Listener and SQLNET log
:25-FEB-2008 18:49:51 *
(CONNECT_DATA=(SID=PORTLPRD)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=sprin
ger)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=xxxx)(PORT=41960)) * establish * PORTLPRD
* 025-FEB-2008 18:49:53 * service_died * PORTLPRD * 1253725-FEB-2008
18:49:54 *
(CONNECT_DATA=(SID=PORTLPRD)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))
)
* (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=45076)) * establish *
PORTLPRD *
0Fatal NI connect error 12170, connecting to: (LOCAL=NO) VERSION
INFORMATION: TNS for Solaris: Version 9.2.0.4.0 -
Production Oracle Bequeath NT Protocol Adapter for Solaris:
Version 9.2.0.4.0 - Production TCP/IP NT Protocol Adapter for
Solaris: Version 9.2.0.4.0 - Production Time: 25-FEB-2008 18:49:51
Tracing not turned on. Tns error struct: nr err code: 0 ns main
err code: 12604 TNS-12604: TNS: Application timeout occurred ns
secondary err code: 0 nt main err code: 0 nt secondary err code:
0 nt OS err code: 0 Client address:
Listener: 10.2.0 10g database on server parm:
INBOUND_CONNECT_TIMEOUT_LISTENER=240
SQLNET.ora
SQLNET.INBOUND_CONNECT_TIMEOUT=240
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
******************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, Alltel requests
that you immediately notify the sender and asks that you do not read the message or its
attachments, and that you delete them without copying or sending them to anyone else.
Oracle LazyDBA home page