Requires Free Membership to View
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
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in June 2002
Join the conversationComment
Share
Comments
Results
Contribute to the conversation