I have Oracle 9i Client and Oracle 10g Client on my machine. Through these clients I am able to connect to the server database which has only Oracle 9i Database. When I tried to connect to Oracle 9i through SQL*Plus on my machine, it directly connects to Oracle 10g. If I want to connect to Oracle 9i what should I do?
I'm not sure I understand exactly what the issue is. You have two releases of Oracle client software on your local workstation/laptop. You wish to connect to an Oracle9i database on a server (not on your local workstation). When you invoke SQL*Plus, it connects to the database but it is using the 10g client. Correct? If this is the case, I'm not sure there is a problem. You are establishing a successful connection to the database, albeit with the Oracle 10g client software. This should not matter as the Oracle 10g client is backward-compatible with the Oracle9i database. Are you experiencing specific problems using the Oracle 10g client software?
Dig Deeper on Oracle database installation, upgrades and patches
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.