Q

Cannot connect to 9i server from another Windows machine

I have installed Oracle Server 9i on a Windows XP machine. It works well when connected to from the same machine. It is not possible to connect to from another machine (Win 2000) using Client 7i or Client 9i, as though the listener wouldn't work. Is there any known issue with 9i Server and XP Pro? Is there a workaround?

I have installed Oracle Server 9i on a Windows XP machine. It works well when connected to from the same machine. It is not possible to connect to from another machine (Win 2000) using Client 7i or Client 9i, as though the listener wouldn't work. Is there any known issue with 9i Server and XP Pro? Is there a workaround?

You may encounter problems connecting with an Oracle 7 client to an Oracle9i database (this is no longer supported),

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.
This was first published in April 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close