User`s guide

Troubleshooting Oracle Net Services
9-10 Oracle Database Installation and Administration Guide
■ Check the naming service if the host name returned by the listener is well
known in the TCP/IP network.
■ If you do not want to use the BCAM host name of the computer in the TCP/IP
network, then define a sockets-host-name as described in the
BCAM
documentation and register this name in the name service.
■ Ensure that the BCAM Leight Weight Resolver LWRESD is properly configured
and running.
4. A client reports ORA-12535
■ If you use the IPC protocol, then check the Connection Timeout parameter of
BCAM (use the BCSHOW command). This parameter should be set to at least 600
seconds.
5. A client reports ORA-03113
■ Check if the SQLNET.EXPIRE_TIME parameter is set for the server. If the
parameter is set, then check the
BCAM LETTER-TIMER using the BCSHOW
command. If the
LETTER-TIME is less than the SQLNET.EXPIRE_TIME , then data
which are sent by the server to see if the client is running may not be read
during their lifetime, which is limited by the
LETTER-TIME . As a result, the
client logs a broken pipe in the
SQLNET.LOG file:
ns main err code: 12547
ns (2) err code: 12560
nt main err code: 517
nt (2) err code: 32
nt OS err code: 0x0040002c
You can solve this problem by setting the LETTER-TIMER to infinite.