First, check to see that SQL Net is installed on the client machine. If SQL Net is installed, ensure that the connect string used by the program is in the tnsnames.ora file on the client. For example, check to see if your program can connect with:
hr/hr@ORATST01Ensure that the service name ORATST01 is defined in the tnsnames.ora file. This file can usually be found in the network/admin subdirectory where the Oracle client software is installed.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.