Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error in Oracle connection

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.

This was last published in March 2004

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close