Q

ORA-12545 error when connecting to database via client

I loaded Oracle 9i Client on my machine, where I also have Oracle 8. I am able to connect to the database using the Oracle 8 client (SQL prompt), and I want to connect to the database using the Oracle 9i client. I get an ORA-12545 error.

I loaded Oracle 9i Client on my machine, where I also have Oracle 8. I am able to connect to the database using the Oracle 8 client (SQL prompt), and I want to connect to the database using the Oracle 9i client. I get an ORA-12545 error. Do I have to reconfigure the listener or the local net service name configuration? I wouldn't think so. I also tried accessing the database from a machine where only the Oracle 9i client is loaded. I configured the listener and the local net service name and I still can't connect to it. I must be entering something wrong. It does not recognize the host name either. I am most interested in connecting to my database using the Oracle 9i client.

Here's my info:
net service name ENG1.COMPANY.COM
HOST USDENS02

From the Oracle 9i Net Services Administrator's Guide, Chapter 17 "Troubleshooting Oracle Net Services," an ORA-12545 basically indicates that the listener on the remote node cannot be contacted.

One thing to verify is that the ADDRESS in the tnsnames.ora file and the listener.ora file is correct. If that still doesn't allow you to connect, edit the TNSNAMES.ORA file to change the host name to an IP address and try connecting again.

This was last published in August 2005

Dig Deeper on Oracle database installation, upgrades and patches

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