RE: what to do ?

2006-08-16 Thread Reidy, Ron
Did you install the Oracle client (not too sure what you mean when you say you installed oic)? What Perl module are you trying to install? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 3:17 AM To: dbi-users@perl.org Subject: what

Re: Symbol Loading Failure for DBD::Oracle on OSX 10.4.7

2006-08-16 Thread Chris Sarnowski
On Aug 15, 2006, at 6:20 PM, Jeremy Smith wrote: I can't get DBD::Oracle past the make test stage. I've read the README.macosx.txt and though there isn't anything directly relevant to OSX 10.4.x, I've tried everything suggested in that file. After a lot of googling and hail mary attempts

RE: what to do ?

2006-08-16 Thread Loo, Peter # PHX
Hi Ron, Here are the results of sqlplus and Perl DBI connections: SQLPLUS CONNECTION: === $ sqlplus [EMAIL PROTECTED] SQL*Plus: Release 9.2.0.4.0 - Production on Wed Aug 16 10:26:54 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter password:

RE: what to do ?

2006-08-16 Thread Loo, Peter # PHX
Oops! Sorry folks. I replied to the wrong thread. I will resend. Peter -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 10:39 AM To: Reidy, Ron; [EMAIL PROTECTED]; dbi-users@perl.org Subject: RE: what to do ? Hi Ron, Here are

RE: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread Loo, Peter # PHX
Hi Ron, Here is the sqlplus connection: $ sqlplus [EMAIL PROTECTED] SQL*Plus: Release 10.2.0.2.0 - Production on Wed Aug 16 10:58:23 2006 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit

Re: Solaris 8, Perl 5.8.7, DBI 1.5.1, DBD::Oracle 1.18a, Instant Client (basic) 10.2.0.2 and NLS settings

2006-08-16 Thread Duncan Ferguson
For those that want to kno, I think I have managed to solve this problem with LIBS=-h ociei -L/usr/local/oracle -lclntsh -lnnz10 -lociei; which records an entry in the Oracle.so for ociei library, and hen link in the full path with the -lociei No idea if this should be included within the

Re: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread John D Groenveld
In message [EMAIL PROTECTED] m, Loo, Peter # PHX writes: $ ./testCon.pl Segmentation Fault(coredump) Lets see the output of pstack(1) for that core. You may have stumbled upon an Oracle bug in the client libraries. John [EMAIL PROTECTED]

RE: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread Loo, Peter # PHX
$ pstack core core 'core' of 13643: /usr/bin/perl ./testCon.pl fe6fbd6c gslufpFLog (1, feda0ba0, 0, 0, 0, 0) + 48 fe6eb0ac ldap_open (ffbfa96c, 185, ffbfa96c, 0, 1, 0) + 24 fe70f634 nnflilc (0, 0, 38daf0, 0, ffbfab34, ffbfab28) + e68 fe70e000 nnflrlc (0, 2000, 1be, fee0aa50, 1, 0) + 1e4

Re: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread John D Groenveld
In message [EMAIL PROTECTED] m, Loo, Peter # PHX writes: $ pstack core core 'core' of 13643: /usr/bin/perl ./testCon.pl fe6fbd6c gslufpFLog (1, feda0ba0, 0, 0, 0, 0) + 48 I'd wager that if you build the OCI demo, cdemo1, you'll core in the same place, which will be what your DBA will need to

RE: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread Loo, Peter # PHX
Hi John, If appears that Perl was built with 32-bit. I don't understand what you mean by OCI demo. $ file /usr/bin/perl /usr/bin/perl: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped Peter -Original Message- From: John D Groenveld [mailto:[EMAIL

Re: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread John D Groenveld
In message [EMAIL PROTECTED] m, Loo, Peter # PHX writes: If appears that Perl was built with 32-bit. I don't understand what you mean by OCI demo. Oracle ships a bunch of OCI demos for training. $ORACLE_HOME/rdbms/demo/ cdemo1 is very simple and if you can replicate the core dump with it,

Re: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread John D Groenveld
In message [EMAIL PROTECTED] m, Loo, Peter # PHX writes: It appears that OID configuration is working properly. I had used tnsping command to see what method it was using to resolve the INSTANCE. $ tnsping INSTANCE_NOT_IN_TNSNAMES_FILE tnsping and sqlplus are 64-bit in 10.2 for Solaris. I

RE: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread Loo, Peter # PHX
Hi, It appears that OID configuration is working properly. I had used tnsping command to see what method it was using to resolve the INSTANCE. $ tnsping INSTANCE_NOT_IN_TNSNAMES_FILE TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 16-AUG-2006 13:44:46 Copyright (c) 1997,

Re: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread Jeffrey Seger
On 8/16/06, Loo, Peter # PHX [EMAIL PROTECTED] wrote: Hi John, It turns out that the INSTANCE that I am trying to connect to is a 32-bit 9.2 Oracle database while my profile is pointing to Oracle 10.2 path. Once I changed the ORACLE_HOME to /opt/app/oracle/product/9.2, the connection worked.

RE: Using Oracle Internet Directory (OID) instead of TNS Names

2006-08-16 Thread Loo, Peter # PHX
Jeffrey, The problem is that I need to know the version of the INSTANCE before logging on to it. Peter -Original Message- From: Jeffrey Seger [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 3:19 PM To: Loo, Peter # PHX Cc: John D Groenveld; DBI-Users Subject: Re: Using