I have a problem with an Oracle connection and getting error 12545. Nothing has changed in the environment for at least six months. SQL + connects. tnsping connects. IP address specified in tnsnames file. Every other Oracle connection works with the exception of this one, which just recently stopped working. Here is how it is defined in the tnsnames file. TMSgraphqa_hodbserver.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.5.22)(PORT = 1521)) (CONNECT_DATA = (SID = kkj)) )
Any help would be appreciated. Solutions in previous posts do not offer any solution. Oracle 8.0.5 client connecting to an 8.0.4 server.
Something had to have changed, otherwise it would continue to work. The ORA-12545 error occurs when the ADDRESS information in the TNSNAMES.ORA file does not match the address information in the server's LISTENER.ORA. Make sure that the SID is correct and that the port is correct for the host listed. You'll have to verify both the TNSNAMES.ORA and the LISTENER.ORA.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.