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
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."
I'm getting errors while installing the Database Configuration Assistant.
Can I use /var/opt/oracle/oratab to specify listener information?