Connecting different versions of Developer and the database

Connecting different versions of Developer and the database

I had installed Oracle 8i on Win2000, and after that I installed my old Developer. It made a different Oracle home, and now there is no connection between them. What should I do so that my Developer gets connected to Oracle?

    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.

You will need to use Net8/SQL*Net to connect Developer to the database as the products are two different versions.

You'll setup and configure the Oracle8i listener using the configuration files in $ORACLE_HOME\network\admin (Oracle home for the Oracle8i instance). You can use the Oracle Home Selector tool to set your default Oracle home to the database. You'll be setting up the listener.ora. Once you have the sqlnet listener running, you'll be ready for the next step.

Use the Oracle Home selector now to set the default Oracle Home to the Developer Oracle home. You would now setup the tnsnames.ora file in the oracle_home\net80\admin (not network\admin, but net80\admin). You'll have this point to the Oracle8i instance on your machine. You can use the tnsping tool to test this connection. Now you are ready to run Developer and connect to the 8i instance.

For More Information


This was first published in June 2002

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

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