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:/usr/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=springer)(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


Oracle LazyDBA home page