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?

    Requires Free Membership to View

    By submitting your registration information to SearchOracle.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchOracle.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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.

This was first published in January 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.