Repca: Error -Sqlexception On Getting Sid And Systemname Information

zhulch發表於2007-01-31
PCAErrorSQLExceptionORM
...[@more@]
Subject: Repca: Error -Sqlexception On Getting Sid And Systemname Information
Doc ID: Note:388445.1Type: PROBLEM
Last Revision Date: 29-JAN-2007Status: MODERATED

In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Application Server 10g Enterprise Edition - Version: 10.1.2.0.2
This problem can occur on any platform.

Symptoms

- MRCA 10.1.2.0.3 fails fails with errors connecting to target database (10.1.2.0.2)

- Errors in repca.log:

SpecifyDBConnectPage] DB User : SYS
[SpecifyDBConnectPage] DB Host(s) : hostname.domain,
[SpecifyDBConnectPage] DB Port(s) : 1526,
[SpecifyDBConnectPage] DB Service Name : PORTALD
[SpecifyDBConnectPage] Is Rac : false
[SpecifyDBConnectPage] DB REMOTE HOST NAME :hostname.domain
[SpecifyDBConnectPage] Is Remote Host :true
ERROR -SQLException on getting SID and SYSTEMNAME information
ERROR - SQLException :Io exception: There is no process to read data written to a pipe.

- Errors in sqlnet.log:

Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production
TCP/IP NT Proto Adapter for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production
Oracle Bequeath NT Proto Adapter for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

Cause

Bug 4677000 WARNING: INBOUND CONNECTION TIMED OUT (ORA-3136)

Solution

To implement the solution, execute the following steps::

1. In $ORACLE_HOME/network/admin/listener.ora, of the database where the Metadata Repoistory is to be loaded, add the line:
INBOUND_CONNECT_TIMEOUT_LISTENER = 0

2. In the Oracle Server 10g sqlnet.ora, add the line:
SQLNET.INBOUND_CONNECT_TIMEOUT = 0

3. Stop and restart the database and the listener for the changes to take effect
4. Rerun RepCA

References

Errors

TNS:operation timed out
null common code generated

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7318139/viewspace-896314/，如需轉載，請註明出處，否則將追究法律責任。

相關文章