You may encounter problems connecting with an Oracle 7 client to an Oracle9i database (this is no longer supported),...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
but the Oracle9i client should be able to connect to the Oracle9i database if configured correctly.
To connect from a client to a remote database, you will need the following components:
- A current tnsnames.ora file on the client -- this usually resides in the network/admin folder under wherever you have installed the Oracle client software. The tnsnames.ora file contains descriptor information for the service name of your remote database. This includes host name or IP address of the server where the database resides.
- You may also require a sqlnet.ora file.
- On the remote database server, a listener must be running and listening for connections to your database. The listener will enable connections to the database from the client, provided the correct username and password are used.
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.