Solved

ODP.NET installed but now I think there might be two oracle homes? cannot connect anyway....

Posted on 2011-03-16
8
721 Views
Last Modified: 2012-05-11
Hi,

I was trying to install ODP.NET there, and that went ok. It installed to E:\oracle\product\10.2.0\client_1... But, the thing is I already have an oracle home under E:\oracle\ora92

So, I can connect OK using the ODACHome1 using TOAD and I can connect to the original home ORAHome92 ok. However, when I try it through code I get an error 'ORA-12154: TNS:could not resolve the connect identifier specified'.

I think this is probably because the default home is ORAHome92 and probably I need to set it to ODACHome1. Or, somehow I need to specify that the ODP.NET code should use ODACHome1. Well, I'm just guessing there really. What should I do to fix this? (I'm using VS 2005; VB.NET)

Thanks Aiden
0
Comment
Question by:AidenA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
8 Comments
 
LVL 35

Accepted Solution

by:
johnsone earned 250 total points
ID: 35147759
Within the original home, there should be a tnsnames.ora file.  If you copy that file to the new home, in the same place (the network\admin directory), that should let you use either home directory.
0
 

Author Comment

by:AidenA
ID: 35147840
Hi thanks, yes i tried that but it didn't work. Are you sure that the default home being the wrong one isn't a problem?
0
 
LVL 35

Expert Comment

by:johnsone
ID: 35148200
The ORA-12154 error would indicate that something is incorrect with the tnsnames.ora file, or the connect string.

You should be able to change the default home with the home selector utility.
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

Author Comment

by:AidenA
ID: 35148343
ok but tnsnames.ora was working fine absolutely no problems until i just installed ODP.NET. so clearly that changed something. Now, even if I try and use my previous method of connecting (OraOLEDB.Oracle) it is producing this error. I'll have a check about this home selector but if i look at the environmental variables they show:

E:\oracle\product\10.2.0\client_1\bin;E:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;

as the first few environmental variables... I tried to remove the first one just to see if i could connect as i did before the installation... but no luck...
0
 

Author Comment

by:AidenA
ID: 35149007
ok this is starting to get bad. still trying to just get my original connections working and now getting a The 'OraOLEDB.Oracle' provider is not registered on the local machine

think i'm just going to try and uninstall ODP.NET...
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 35149104
Oledb error is like a PATH issue.  Put the old home in the path first.

For the tns error: set an environment variable TNS_ADMIN pointing to the folder with the correct tnsnames.ora file.

I would suggest the env var as a test.  Once you get it working we can get the file in the proper place.
0
 

Author Comment

by:AidenA
ID: 35275101
i was busy on something else there... but will start back on this on friday i think... and I think also i'll have to go with ODP.NET after all since I inadvertently convinced others to go with it to!

the OraOLEDB.Oracle started working by itself i think just after i turned off the machine and came in the next day... so I just need to get ODP.NET working again... i'll let you know how I go on that and check your suggestions
0
 

Author Comment

by:AidenA
ID: 35727549
actually i managed to solve this issue but can't remember how exactly... i think it might have just been a coding issue. Either way I'll just close off this question and won't add to knowledge base...

thanks for help...
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

724 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