...[@more@]

Subject:	Repca: Error -Sqlexception On Getting Sid And Systemname Information
	Doc ID:	Note:388445.1	Type:	PROBLEM
	Last Revision Date:	29-JAN-2007	Status:	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-12535 TNS:operation timed out
ORA-3136 null common code generated

---