RE: Oracle::DBI module - Issues in connecting to Oracle 10G

2009-01-09 Thread Martin Gainty
Sri- Oracle connects via the TNS entry as seen in %ORACLE_HOME%/network/admin/tnsnames.ora Here the TNS Name DB1 is associated to Service IDentifier of DB 1 SID=DB1 which in this case is listening on localhost Port 1521 DB1= (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)

Oracle::DBI module - Issues in connecting to Oracle 10G

2009-01-09 Thread Srinu
Hello, Can someone help with me a DBI issue I'm having in connecting to an Oracle 10g DB server? We have production scripts that loads data into DB (oracle9i) using DBI module. We recently migrated our database to oracle 10g. Our DBA has implemented load balancing on this 10g server and gave u

Re: trouble installing DBD:Oracle on linux

2009-01-09 Thread Hendrik Schumacher
Am Fr, 9.01.2009, 16:43, schrieb Harsha Hegde: > Hi DBI users, > > I am trying to install DBD::Oracle on a x86 64bit machine running Ubuntu > Linux. I see the following error: > >>> > r...@devserver-165:~/.cpan/build/DBD-O

Re: DBD problem with knowing where Oracle is at.

2009-01-09 Thread Hendrik Schumacher
Am Fr, 9.01.2009, 21:40, schrieb Bruce Johnson: > > On Jan 9, 2009, at 1:19 PM, Kong, Alan wrote: > >> Chris, >> >> The LD_LIBRARY_PATH, LD_RUN_PATH, and SHLIB_PATH are normally set to >> $ORACLE_HOME/lib or $ORACLE_HOME/lib32 for 32 bit database depend on >> where your lib files located. But from

RE: DBD problem with knowing where Oracle is at.

2009-01-09 Thread Martin Gainty
Chris- Your TNS_ADMIN usually points to $ORACLE_HOME/network/admin where you find these files TNSNAMES.ORA listener.ora also..I generally set ORACLE_SID environment var to point to the SID I am using Martin __ Disclaimer and confidentiality note Ev

Re: DBD problem with knowing where Oracle is at.

2009-01-09 Thread Bruce Johnson
On Jan 9, 2009, at 1:19 PM, Kong, Alan wrote: Chris, The LD_LIBRARY_PATH, LD_RUN_PATH, and SHLIB_PATH are normally set to $ORACLE_HOME/lib or $ORACLE_HOME/lib32 for 32 bit database depend on where your lib files located. But from your first email, it set to the same value as $ORACLE_HOME.

Re: DBD problem with knowing where Oracle is at.

2009-01-09 Thread listmail
Koester, Chris wrote: Scripts ran from cron give this error. failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at /app/XOstats/prod/bin/util/check_user.pl line 43 Can't call method "disconnect" on an undefined value at /

RE: DBD problem with knowing where Oracle is at.

2009-01-09 Thread Kong, Alan
Chris, The LD_LIBRARY_PATH, LD_RUN_PATH, and SHLIB_PATH are normally set to $ORACLE_HOME/lib or $ORACLE_HOME/lib32 for 32 bit database depend on where your lib files located. But from your first email, it set to the same value as $ORACLE_HOME. Change the settings and see if it's working. Alan

RE: DBD problem with knowing where Oracle is at.

2009-01-09 Thread Koester, Chris
This still does not help. ORACLE_SID and LD_RUN_PATHwas already there. I added SHLIB_PATH and still no luck. --- Chris Koester -Original Message- From: Kong, Alan [mailto:ko...@coned.com] Sent: Friday, January 09, 2009 1:56 PM To: Koester, Chris; dbi-users@perl.org Su

RE: DBD problem with knowing where Oracle is at.

2009-01-09 Thread Kong, Alan
Chris, You have to set ORACLE_SID, SHLIB_PATH, and LD_RUN_PATH also in your perl script. Alan -Original Message- From: Koester, Chris [mailto:ckoes...@xo.com] Sent: Friday, January 09, 2009 2:45 PM To: dbi-users@perl.org Subject: DBD problem with knowing where Oracle is at. Scripts ran

DBD problem with knowing where Oracle is at.

2009-01-09 Thread Koester, Chris
Scripts ran from cron give this error. failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at /app/XOstats/prod/bin/util/check_user.pl line 43 Can't call method "disconnect" on an undefined value at /app/XOstats/prod/bin/uti

trouble installing DBD:Oracle on linux

2009-01-09 Thread Harsha Hegde
Hi DBI users, I am trying to install DBD::Oracle on a x86 64bit machine running Ubuntu Linux. I see the following error: >> r...@devserver-165:~/.cpan/build/DBD-Oracle-1.22-4sDScg# perl Makefile.PL Using DBI 1.607 (for p