Serious problems using Oracle 10g 10.2.0 Client with DBD-Oracle module loaded on Windows!
Hi: I'm not sure if this is a right place to ask this question so please forward to whom it may concern. I had installed ActiveState Perl 5.8.8 on WinXP and installed latest DBI and DBD-Oracle using their ppm3. The DBD-Oracle seemed to work fine, but see this link for exact problems I was having with Oracle Client software throwing errors and not working: http://forums.oracle.com/forums/thread.jspa?threadID=307903&tstart=0 DBD-Oracle installed "oraociei10.dll" version 10.1.0.4.0 and it conflicts with the newer Oracle 10.2.0 Client installation. I replaced the "c:\perl\bin\oraociei10.dll" with newer version 10.2.0.1.0 from "C:\oracle\product\10.2.0\client_1\instantclient\oraociei10.dll" which can be found by installing latest 10g client from http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip The DBD-Oracle still works and now my Oracle client software (Oracle Enterprise Manager and sqlplus both work! How do we get this newer Oracle instantclient dll to be the one that gets installed with DBD-Oracle on Windows platforms? Is this an ActiveState issue only or does it possibly affect other win32 installs of perl on Windows? How can we avoid this problem in the future by keeping the "instantclient\oraociei10.dll" file that gets installed during the DBD-Oracle install UP-TO-DATE? My problem is solved, unless this newer file adds some "voodoo" to how DBD-Oracle should work. It seems to work fine in my testing, but I thought I should ask here to make sure dropping in this newer dll is kosher. Thanks, Lawrence K. Hixson Oracle DBA National Weather Service HQ and Donor Relations Chair TPF Steering Committee
|
0 |
|
Lawrence
7/10/2006 6:31:52 PM
perl.dbi.dev
1960 articles. 
0 followers.
0 Replies
714 Views
Similar Artilces:
how to implement login module using Oracle 10g database (logic & Oracle 10g Queries) and how can i use membership and roles with Oracle 10g & VS 2.0
Hi all, Can any one tell me how to implement login module using Oracle 10g database (logic & Oracle 10g Queries) and how can I use membership and roles with Oracle 10g & vs 2.0. , for implement this is it compulsory to install oracle 10g server on the same machine on which I'm implementing this task or otherwise i can use other system as a server (like remote login or client server) Hi,You should have the Oracle 10g Server or Client In your machine.In Case Client is in your Machine then Server Must be somewhere,that is enough to use.I hope then we ...
PB 10.2.1 build 9004 vs Oracle client 10G (10.1.0.2.0)
Hi all, We are having an issue with Oracle 10G using SP's in RPC... Seems we cannot disable unicode in DBParm if we use DBMS=O10. Not even with DBMS=O90 The only way we can disable it is using DBMS=O84. Which is documented... The problem is that our sp's get extra garbage because of unicode. Any thoughts anyone ? GQ They shouldn't get 'extra garbage', the character translation is the responsibility of the driver. That said, there was an issue, where data binding could cause a problem. Check out the latest EBF and the DBParm ncharbind and se...
EAServer 5.3.0, Oracle 8.1.7 Database with Oracle 10.1.0.2 client VARCHAR2(4000) problem
Hello! I'm having some problems in this configuration on Windows XP. I am developing websites on an Oracle database (8.1.7), with EAServer 5.3.0 (build 53016), Java objects using JSP as a front end. Here is my problem, I have a table with 2 VARCHAR2(4000), and when I access the webpage, the they are displayed as '?????????????'. If I debug the PB component, when I affect the DW field to a variable, it displays it as it doesn't "understand" a thing (each character is replaced by a square). The codeset of EAServer is UTF8, and on my client, it is AM...
Connection Problem using ADOConnection to Oracle 10g Express Edition Release 10.2.0.1.0
Hello, I am using Delphi 2007 with the ADOConnection and ADOQuery objects to read and write data to an Oracle 10g Express Edition Release 10.2.0.1.0 database. Reading and writing all goes fine when running from the IDE. On a random basis however, when the ADO connection is first attempted to the remote Oracle server, the IDE will stop (event though no break points were assigned) at the following location: ntdll.DbgBreakPoint: 77337DFE CC int 3 --> 77337DFF C3 ret ntdll.RtlInitString: 77337E00 57 push...
Problems (and solution) compiling DBD::Oracle with Oracle 10.2.0 on Linux
Trying to compile DBD::Oracle I run into trouble because the Makefile kept failing to find the libraries. I figured out after a while that the problem was that somehow in the library path that he was using a 'lib32' kept being used instead of 'lib'. Can't see where that 'lib32' came from, probably is adding the architecture of the syste to the lib name somewhere. To quickly solve the problem I simply created a couple of symlinks named 'lib32' pointing to 'lib', one for $ORA_HOME/lib and one for $ORA_HOME/rdbms/lib This made him happy. ...
[dbd-oracle-1.19] Problem with Makefile.PL & Oracle XE 10.2.0
Hello, I got errors when compiling dbd-oracle-1.19. My server is running Linux Mandriva 2007 + Oracle Database 10g Express Edition with Perl 5.8.8 and DBI 1.52. Bellow you will find some more informations : * uname -a * perl -V * perl Makefile.PL * make * make test * make install Thanks for your help, Guillaume =================== uname -a =================== [root@oranux DBD-Oracle-1.19]# uname -a Linux oranux 2.6.17-5mdv #1 SMP Wed Sep 13 14:32:31 EDT 2006 i686 Intel(R) Pentium(R) M processor 2.00GHz GNU/Linux =================== perl -V ===============...
Did Solaris Oracle patch 9.2.0.3 eliminate DBD::Oracle 8i -vs- 9i client problem?
Has anyone noticed if Oracle's recent patch 9.2.0.3 (SunOS 5.8 sun4u) made it unnecessary to have a separate DBD::Oracle for Oracle 8i and for Oracle 9i client environments? Here's a fragment that used to fail: use Oraperl; my $lda = &ora_login( "", "nm", "pw" ); It failed when the DBD::Oracle (admittedly a pretty old version) we used was built with Oracle 8i client libraries, but was run in an environment (ORACLE_HOME, LD_LIBRARY_PATH) pointing at Oracle 9i client libraries. At the &ora_login, $ora_errno=-1, $ora_errstr=&qu...
DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install
--------------090703000606090406010703 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit Hi, I am having a problem setting up DBD::Oracle version 1.19 on a Debian Etch. I am running perl 5.8.8 and have dbi 1.53 (I believe) installed. I have instantclient-basic, instantclient-devel, and sqlplus installed. I can, without a problem, connect to my external DB Server via sqlplus. I have ORACLE_HOME and LD_LIB path set everything works great, and I am user root. I have several times installed DBD::Oracle 1.19 on Debian Etch without an...
Fixes for DBD::Oracle 1.14 Makefile.PL using Oracle 9.2.0.0.0 on HP-UX
------_=_NextPart_001_01C367AC.DC7002F0 Content-Type: text/plain; charset="iso-8859-1" Hi, When running 'perl Makefile.PL' "out of the box", perl complained that the version of Oracle was a string, but was being compared as a number. This is because the program assumes that the version has only 3 parts, when in fact it has 5. This was fixed by: Line 182: ($inspdver{rdbms_ver} = $inspdver{RDBMS}) =~ s/^(\d+\.\d+)\.(\d+)/${1}0$2/; # Added the following two lines $inspdver{rdbms_ver} =~ s/^(\d+\.\d+)\.(\d+)/${1}0$2/; $inspdver{rdbms_ver} =~ s/^...
RE: Fixes for DBD::Oracle 1.14 Makefile.PL using Oracle 9.2.0.0.0 on HP-UX
Hi Tim, Thanks. As expected, your changes are a bit more elegant. This is what I got from the new Makefile.PL after running 'make': LD_RUN_PATH="/apps/oracle/Ora920/lib32:/apps/oracle/Ora920/rdbms/lib32" /usr/bin/ld -b -s -a shared Oracle.o dbdimp.o oci7.o oci8.o -o build -L/apps/oracle/Ora920/rdbms/lib32/ -L/apps/oracle/Ora920/lib32/ /apps/cobol2010/coblib:/psoft/HE76DM/bin:/apps/pt76/tux65j12/lib32:/apps/ora cle/Ora920/lib32 -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -l:libcl.sl ...
Make error: DBD-Oracle-1.14 , DBI-1.39, Oracle rdbms 9.2.0.0.0 , solaris 9
------=_NextPart_000_0025_01C3BE5A.4F6A0C70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, When I make DBD-Oracle 1.14 , Makefile.PL generates a Makefile with "-o build" in the compiler string before blib/arch/auto/DBD/Oracle/Oracle.so and prevents Oracle.so from being built correctly. demo_rdbms.mk appears to be to supplying this: Attempting to discover Oracle OCI build rules^M gcc -B/usr/ccs/bin/ -c DBD_ORA_OBJ.c^M by executing: (make -f /export/home/oracle/ora9idbms/rdbms/demo/demo_rdbms.mk bu ild ECHODO=echo EC...
building DBD-Oracle-1.14 on Windows 2000 with Oracle 9.2.0.1.0
--------------000909050500020007070606 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi, I'm trying to build DBD-Oracle-1.14 on a Windows 2000 machine with Oracle 9.2.0.1.0 Standard installed. I should also point out that I'm working within a unix environment (a product called Microsoft Windows Services for Unix) which runs under Windows and I'm trying to install DBD into the perl that came with the unix environment. I don't believe the unix environment under Windows has anything to do with my problems building...
PB 10.5 - ORACLE 10.0.2
I have the following situation: 1) Executable created with PB 10.5.build 6684 2) Windows 2003 Server 3) Oracle 10.0.1 The PB application starts correcly, but when i use the follwing syntax the application is instantly closed without any error message or dump message displayed. datastore lds_localds < other scripts> lds_localds = CREATE datastore The same machine work fine with the following script (datawindow in place of datastore) datawindow lds_localds < other scripts> lds_localds = CREATE datawindow The "datastore syntax" works fine on the same ...
Oracle 10.1.0.2, RedHat AS, and DBD::Oracle
We got a fancy new RedHat AS server here at work, and our Sys Admin installed the Oracle 10.1.0.2 client on it (although the Oracle server is running version "Oracle8i Release 8.1.7.4.0"). SQL*Plus seems to work fine for connecting to our Oracle servers, despite the version difference. I was attempting to install DBD::Oracle on this machine and, as you might expect, ran into a few problems. I guess my first question is: Should I even try to install DBD::Oracle (v 1.15) with Oracle 10.1.0.2 on RedHat AS? My sense of the situation is that this version of Oracle is too re...
Hi all, Can any one tell me how to implement login module using Oracle 10g database (logic & Oracle 10g Queries) and how can I use membership and roles with Oracle 10g & vs 2.0. , for implement this is it compulsory to install oracle 10g server on the same machine on which I'm implementing this task or otherwise i can use other system as a server (like remote login or client server) Hi,You should have the Oracle 10g Server or Client In your machine.In Case Client is in your Machine then Server Must be somewhere,that is enough to use.I hope then we ...
PB 10.2.1 build 9004 vs Oracle client 10G (10.1.0.2.0)
Hi all, We are having an issue with Oracle 10G using SP's in RPC... Seems we cannot disable unicode in DBParm if we use DBMS=O10. Not even with DBMS=O90 The only way we can disable it is using DBMS=O84. Which is documented... The problem is that our sp's get extra garbage because of unicode. Any thoughts anyone ? GQ They shouldn't get 'extra garbage', the character translation is the responsibility of the driver. That said, there was an issue, where data binding could cause a problem. Check out the latest EBF and the DBParm ncharbind and se...
EAServer 5.3.0, Oracle 8.1.7 Database with Oracle 10.1.0.2 client VARCHAR2(4000) problem
Hello! I'm having some problems in this configuration on Windows XP. I am developing websites on an Oracle database (8.1.7), with EAServer 5.3.0 (build 53016), Java objects using JSP as a front end. Here is my problem, I have a table with 2 VARCHAR2(4000), and when I access the webpage, the they are displayed as '?????????????'. If I debug the PB component, when I affect the DW field to a variable, it displays it as it doesn't "understand" a thing (each character is replaced by a square). The codeset of EAServer is UTF8, and on my client, it is AM...
Connection Problem using ADOConnection to Oracle 10g Express Edition Release 10.2.0.1.0
Hello, I am using Delphi 2007 with the ADOConnection and ADOQuery objects to read and write data to an Oracle 10g Express Edition Release 10.2.0.1.0 database. Reading and writing all goes fine when running from the IDE. On a random basis however, when the ADO connection is first attempted to the remote Oracle server, the IDE will stop (event though no break points were assigned) at the following location: ntdll.DbgBreakPoint: 77337DFE CC int 3 --> 77337DFF C3 ret ntdll.RtlInitString: 77337E00 57 push...
Problems (and solution) compiling DBD::Oracle with Oracle 10.2.0 on Linux
Trying to compile DBD::Oracle I run into trouble because the Makefile kept failing to find the libraries. I figured out after a while that the problem was that somehow in the library path that he was using a 'lib32' kept being used instead of 'lib'. Can't see where that 'lib32' came from, probably is adding the architecture of the syste to the lib name somewhere. To quickly solve the problem I simply created a couple of symlinks named 'lib32' pointing to 'lib', one for $ORA_HOME/lib and one for $ORA_HOME/rdbms/lib This made him happy. ...
[dbd-oracle-1.19] Problem with Makefile.PL & Oracle XE 10.2.0
Hello, I got errors when compiling dbd-oracle-1.19. My server is running Linux Mandriva 2007 + Oracle Database 10g Express Edition with Perl 5.8.8 and DBI 1.52. Bellow you will find some more informations : * uname -a * perl -V * perl Makefile.PL * make * make test * make install Thanks for your help, Guillaume =================== uname -a =================== [root@oranux DBD-Oracle-1.19]# uname -a Linux oranux 2.6.17-5mdv #1 SMP Wed Sep 13 14:32:31 EDT 2006 i686 Intel(R) Pentium(R) M processor 2.00GHz GNU/Linux =================== perl -V ===============...
Did Solaris Oracle patch 9.2.0.3 eliminate DBD::Oracle 8i -vs- 9i client problem?
Has anyone noticed if Oracle's recent patch 9.2.0.3 (SunOS 5.8 sun4u) made it unnecessary to have a separate DBD::Oracle for Oracle 8i and for Oracle 9i client environments? Here's a fragment that used to fail: use Oraperl; my $lda = &ora_login( "", "nm", "pw" ); It failed when the DBD::Oracle (admittedly a pretty old version) we used was built with Oracle 8i client libraries, but was run in an environment (ORACLE_HOME, LD_LIBRARY_PATH) pointing at Oracle 9i client libraries. At the &ora_login, $ora_errno=-1, $ora_errstr=&qu...
DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install
--------------090703000606090406010703 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit Hi, I am having a problem setting up DBD::Oracle version 1.19 on a Debian Etch. I am running perl 5.8.8 and have dbi 1.53 (I believe) installed. I have instantclient-basic, instantclient-devel, and sqlplus installed. I can, without a problem, connect to my external DB Server via sqlplus. I have ORACLE_HOME and LD_LIB path set everything works great, and I am user root. I have several times installed DBD::Oracle 1.19 on Debian Etch without an...
Fixes for DBD::Oracle 1.14 Makefile.PL using Oracle 9.2.0.0.0 on HP-UX
------_=_NextPart_001_01C367AC.DC7002F0 Content-Type: text/plain; charset="iso-8859-1" Hi, When running 'perl Makefile.PL' "out of the box", perl complained that the version of Oracle was a string, but was being compared as a number. This is because the program assumes that the version has only 3 parts, when in fact it has 5. This was fixed by: Line 182: ($inspdver{rdbms_ver} = $inspdver{RDBMS}) =~ s/^(\d+\.\d+)\.(\d+)/${1}0$2/; # Added the following two lines $inspdver{rdbms_ver} =~ s/^(\d+\.\d+)\.(\d+)/${1}0$2/; $inspdver{rdbms_ver} =~ s/^...
RE: Fixes for DBD::Oracle 1.14 Makefile.PL using Oracle 9.2.0.0.0 on HP-UX
Hi Tim, Thanks. As expected, your changes are a bit more elegant. This is what I got from the new Makefile.PL after running 'make': LD_RUN_PATH="/apps/oracle/Ora920/lib32:/apps/oracle/Ora920/rdbms/lib32" /usr/bin/ld -b -s -a shared Oracle.o dbdimp.o oci7.o oci8.o -o build -L/apps/oracle/Ora920/rdbms/lib32/ -L/apps/oracle/Ora920/lib32/ /apps/cobol2010/coblib:/psoft/HE76DM/bin:/apps/pt76/tux65j12/lib32:/apps/ora cle/Ora920/lib32 -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -l:libcl.sl ...
Make error: DBD-Oracle-1.14 , DBI-1.39, Oracle rdbms 9.2.0.0.0 , solaris 9
------=_NextPart_000_0025_01C3BE5A.4F6A0C70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, When I make DBD-Oracle 1.14 , Makefile.PL generates a Makefile with "-o build" in the compiler string before blib/arch/auto/DBD/Oracle/Oracle.so and prevents Oracle.so from being built correctly. demo_rdbms.mk appears to be to supplying this: Attempting to discover Oracle OCI build rules^M gcc -B/usr/ccs/bin/ -c DBD_ORA_OBJ.c^M by executing: (make -f /export/home/oracle/ora9idbms/rdbms/demo/demo_rdbms.mk bu ild ECHODO=echo EC...
building DBD-Oracle-1.14 on Windows 2000 with Oracle 9.2.0.1.0
--------------000909050500020007070606 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi, I'm trying to build DBD-Oracle-1.14 on a Windows 2000 machine with Oracle 9.2.0.1.0 Standard installed. I should also point out that I'm working within a unix environment (a product called Microsoft Windows Services for Unix) which runs under Windows and I'm trying to install DBD into the perl that came with the unix environment. I don't believe the unix environment under Windows has anything to do with my problems building...
PB 10.5 - ORACLE 10.0.2
I have the following situation: 1) Executable created with PB 10.5.build 6684 2) Windows 2003 Server 3) Oracle 10.0.1 The PB application starts correcly, but when i use the follwing syntax the application is instantly closed without any error message or dump message displayed. datastore lds_localds < other scripts> lds_localds = CREATE datastore The same machine work fine with the following script (datawindow in place of datastore) datawindow lds_localds < other scripts> lds_localds = CREATE datawindow The "datastore syntax" works fine on the same ...
Oracle 10.1.0.2, RedHat AS, and DBD::Oracle
We got a fancy new RedHat AS server here at work, and our Sys Admin installed the Oracle 10.1.0.2 client on it (although the Oracle server is running version "Oracle8i Release 8.1.7.4.0"). SQL*Plus seems to work fine for connecting to our Oracle servers, despite the version difference. I was attempting to install DBD::Oracle on this machine and, as you might expect, ran into a few problems. I guess my first question is: Should I even try to install DBD::Oracle (v 1.15) with Oracle 10.1.0.2 on RedHat AS? My sense of the situation is that this version of Oracle is too re...
Web resources about - Serious problems using Oracle 10g 10.2.0 Client with DBD-Oracle module loaded on Windows! - perl.dbi.devResources last updated: 1/2/2016 6:11:52 AM