Q
Problem solve Get help with specific problems with your technologies, process and projects.

Connect to Oracle 9i through client

I have Oracle 9i Client and Oracle 10g Client on my machine. When I tried to connect to Oracle 9i through SQL*Plus on my machine, it directly connects to Oracle 10g.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

Hi,
1.I have both Oracle 9i and Oracle 10g client installed to my local machine.
2. I am accessing Oracle 10g (on Server) using tnsnames.ora. I am putting tnsnames.ora file inside C:\oracle\ora92\network\ADMIN.
3.If I delete tnsnames.ora from above mentioned path and put it to oracle10g client folder(C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN), My appliaction throwing exception
ORA-12154: TNS could not resolve service name
4. My need is to access Oracle 10g server db using oracle 10g client. Where might be the problem?
5. Why it is working when I am accesing server DB using oracle9i client?
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close