ORA-12542: TNS:address already in use when Opening Numerous Connections to DB (Doc ID 2230924.1)

Last updated on FEBRUARY 10, 2017

Applies to:

Siebel CRM - Version 8.1.1 [21112] and later
Information in this document applies to any platform.

Symptoms

When attempting to run concurrent Workflows tasks the below error shows up randomly

ERROR
-----------------------

GenericLog GenericError 1 000edc23579f10ec:0 2016-08-02 20:04:37 (secmgr.cpp (2768) err=4597538 sys=0) SBL-SEC-10018: An Oracle database error has occurred. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00107) ORA-12542: TNS:address already in use.


STEPS
-----------------------
The issue can be reproduced only in customer environment on Windows OS at will with the following steps:

1) design a workflow (or BS) with EAI BeginTransaction method - as this creates new connections/login to DB.
2) run this spawning lot of tasks in parallel.

On the client side(Siebel Server machine) transport stack is reporting the error:

nt (2) err code: 48

WSAEADDRINUSE 48 10048

 

nameserver_audit.log:

2016-10-24 11:55:45 FailedLogin XXXXXX 7176 siebmtshmw.exe XXXXXX

2016-10-25 09:17:08 FailedLogin XXXXXX2260 siebmtshmw.exe sadmin

2016-10-25 09:17:09 FailedLogin XXXXXX 2260 siebmtshmw.exe sadmin

2016-10-25 09:17:12 FailedLogin XXXXXX 3816 siebmtshmw.exe sadmin

2016-10-25 09:17:39 FailedLogin XXXXXX 3816 siebmtshmw.exe sadmin

2016-10-25 09:20:05 FailedLogin XXXXXX 10760 siebmtshmw.exe sadmin

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms