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

Which version of Oracle will I connect to?

I have Oracle 7i and Oracle 9i installed on my PCs under C:/ORANT and C:/ORA9 respectively. When I try to connect to Oracle through any front-end application, which Oracle will it connect to? Does it take the tnsnames.ora from the path corresponding to the Oracle version specified in the Home Selector?

I have Oracle 7i and Oracle 9i installed on my PCs under C:/ORANT and C:/ORA9 respectively. When I try to connect to Oracle through any front-end application, which Oracle will it connect to? Does it take the tnsnames.ora from the path corresponding to the Oracle version specified in the Home Selector?
The tnsnames.ora file on the client defines a service name and host for which an application will connect to. When the connection is attempted, the client will go to the host that the database resides on and the listener will enable the connection. In the listener.ora file on the database server, if a static SID list is provided, you should see the SID listed as well as its associated ORACLE_HOME.

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