Post suddenly stopped with "Poster: 12032 - OCIServerAttach failed with ORA-12542". Upon restarting post it was up and running without any issue.
The docs note this on the ORA-12542 error:
ORA-12542: TNS:address already in use
Cause: Specified listener address is already being used.
Action: Start your listener with a unique address.
In UNIX, the ORA-12542 error can be fix by just re-set the listener to run on a different port or add to the queue size for the listener in your listener.ora file.
listener=(address=
(protocol=tcp)
(host=myhost)
(port=2241)
(queuesize=60))
In Windows, [The ORA-12542 TNS address in use error] is caused due to the fact that the free ports in the windows client has been exhausted and it is trying to make use of a port which is in TIME_WAIT state which gives the error TNS-12542: Address already in use.
1.) Increase the free port range
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
On the Edit menu, click Add Value, and then add the following registry value:
Value Name: MaxUserPort Data Type: REG_DWORD Value: 65534
Valid Range: 5000-65534 (decimal) Default: 0x1388 (5000 decimal)
2.) Decrease the value for TIME_WAIT state:
TcpTimedWaitDelay
Key: Tcpip\Parameters
Value Type: REG_DWORD - Time in seconds
Valid Range: 30-300 (decimal)
Default: 0xF0 (240 decimal)
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center