Do i have to reinstall DBD::Oracle within my 11g environment to get it to work?
Could this affect the numerous other test systems on this server that are using perl to connect to their oracle databases?

Thanks
Phil

10-27-2010, 01:50 PM

PAVB

Wild guess... are you pointing to the right ORACLE_HOME?

Can you connect sqlplus using the same environmentals?

10-28-2010, 03:10 AM

philthee

Quote:

Originally Posted by PAVB

Wild guess... are you pointing to the right ORACLE_HOME?

Can you connect sqlplus using the same environmentals?

Yeah, sqlplus works fine, just using perl dbi.

I am assuming i have to install DBD::Oracle against this database. I am confused as to how many DBD::Oracle drivers you can have. I was thinking you just had one in your perl installation that would connect to all your databases but perhaps this is not the case.

10-29-2010, 10:10 AM

lesstjm

Path

in your PATH for 10g you are pointing to you ORACLE 10g bin , lib and lib32. You are not pointing to all of those things in your 11g PATH

10-29-2010, 10:17 AM

philthee

Quote:

Originally Posted by lesstjm

in your PATH for 10g you are pointing to you ORACLE 10g bin , lib and lib32. You are not pointing to all of those things in your 11g PATH

Hi, yeah i have since put these in my PATH but same error.
Although there is no lib32 in the 11g home

11-01-2010, 09:34 AM

Thomasps

may be you can use 'truss' command and see where the script is failing.