ORA-12542 or TNS-12542 could occur in few situations.
More info:
TNS:address already in use
TNS:protocol adapter error
Case 1: While starting the listener.
- Change the port number, in case another listener is running on same port.
- Delete the .oracle subdirectory under /tmp to repopulate the hung TCP/IP socket.
Case 2: While connecting from Application/Client Server
- Bounce the Application Services as maximum port limit has reached.
- Increase the free port limit on the server.
More Troubleshooting Steps
Have a question or comment? Post it below!
2 Comments:
TNS Names probleb
Normally, ephemeral (that is, short-lived) ports are allocated between the values 1024 and 5000 inclusive.
What would be impect of increasing the port ?
What is the maximum no of ports we can increase ?
Post a Comment