Return
-
Title
Command server: 12032 - OCIServerAttach failed with ORA-12170 -
Description
The following messages are observed in event_log:
Error 2018-05-15 17:02:02.452532 29997 3533290256 Command server: 12032 - OCIServerAttach failed with ORA-12170. (connecting from <name>) [module osp]
Notice 2018-05-15 17:02:02.467354 29997 3533290256 Command server: logon() error() (connecting from <name>) [module cnc]
-
Cause
The listener is down during that period when the messages are seen. -
Resolution
When Post is configured to use listener (or sql*net), and if the listener is down at any time, the messages as above will occur. Once the listener is up again, the messages will stop occurring as SharePlex will then be able to connect to the database. There will not be any data loss accompanied by such event.
Here is the description of the Oracle error ORA-12170:
ORA-12170: TNS:Connect timeout occurredCause: The server shut down because connection establishment or communication with a client failed to complete within the allotted time interval. This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server.Action: If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (e.g. in TCP/IP). -
Additional Information
Similar messages can also occur when other SharePlex processes like Capture or Read make connections with the database and are configured to use listener.