Oracle DBI and Multiple homes

Lrdtalon has asked for the wisdom of the Perl Monks concerning the following question:

I beseech thee to help with my problem (sorry the formatting sucks)...
I am using oracle grid control to run a perl script against an oracle database, as such i am using the oracle dbi driver in the script, but there are multiple homes on the server.

One home knows about the instance the other doesn't when i try and connect i get the following error:
DBI connect('capt7','asm',...) failed: ORA-12557: TNS:protocol adapter not loadable (DBD ERROR: OCIServerAttach) at \\ogc\dba\scripts\imagecomp\process_blob_tables.pl line 66
Database connection not made: ORA-12557: TNS:protocol adapter not loadable (DBD ERROR: OCIServerAttach) at \\ogc\dba\scripts\imagecomp\process_blob_tables.pl line 66.

I believe this has to do with the wrong home trying to make the connection, is there any way to specify which home to use? Or how do i check which home i am actually using?

Comment on Oracle DBI and Multiple homes

Replies are listed 'Best First'.
Re: Oracle DBI and Multiple homes by sflitman (Hermit) on Oct 17, 2008 at 06:18 UTC
I think this is a good explanation for your problem: Oracle Forums Perhaps the multiple homes on the servers are separate installations, which Oracle doesn't handle well on Win2K (registry conflict with key ORACLE_SID) SSF	[reply]