You may need to verify which ORACLE_HOME is set. It may be looking at the wrong tnsnames.ora file entry depending on if ORACLE_HOME is 8i or 9i.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.