?
Solved

Setting Oracle Home with 10g client install with 9i client previously installed

Posted on 2010-04-07
7
Medium Priority
?
485 Views
Last Modified: 2013-12-19
I have had oracle 9i installed for couple years where I was unable to connec t to an Oracle 10g database.  As a result I installed 10G client.  If I use TOAD and specifically select the home for 10g I can connect.  Otherwise, I cannot connect to the 10g database.  However, my problem is that my application uses whatever the default Oracle home is. As a result it tries to connect with 9i which does not work. Is there a way to change my default Oracle home to the 10 g home?  

FYI - When I installed 10 g client I used the defualt settings.  

Thanks
0
Comment
Question by:vandy02
  • 4
  • 3
7 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 30021446
What OS?

In windows you can set the default ORACLE_HOME in the registry. Going from memory I think it's HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE

For what it's worth a 9i client should be able to connect to 10g database.
0
 

Author Comment

by:vandy02
ID: 30027782
I thought it would to.   However it will not.
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1500 total points
ID: 30030810
did setting ORACLE_HOME to the 10g one work?

>>I thought it would to.   However it will not.

If you want to pursue the 9i to 10g issue:  What errors are you getting?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Comment

by:vandy02
ID: 30031664
TNS error each time
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 30033276
I'm afraid I'll need the error number (ex: TNS-12560).
0
 

Author Comment

by:vandy02
ID: 30096891
I got it to work.  I just backed up my tnsnames from 9i, uninstalled 9i and 10 g, and re-installed 10g.  All is working now.

Thanks
0
 

Author Closing Comment

by:vandy02
ID: 35753229
Worked
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question