Oracle8i and Developer6i need to run in different ORACLE_HOME directories. This is a requirement of those two pieces of software. Your ORACLE_HOME is probably set to the 8i RDBMS home directory. This is why SQL*Plus works just fine for you. But your Dev6i software runs in a different ORACLE_HOME. In the ORACLE_HOME directory is a network/admin subdirectory. In this subdirectory should be a file called TNSNAMES.ORA. You'll have to add an alias in that file to point to the 8i database even though it is on the same machine. Startup the Net Assistant that was installed with your 6i software and configure an alias. When you try to connect to the 8i database with the 6i software, you'll need the username, password and the alias you just created.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.