Mark,
thanks for the suggestion. It is useful for managing the environment and helped
me to build DBD without the OAS libs. But my GGI scripts which use DBI and are
served by the OAS listener do not work. They hang just before the $dbh =
DBI->connect.
The OAS listener's LD_LIBRARY_PATH points to its own libs, but it seems that
these libs are incompatible with the DBD.
If that's true then how can I use DBI in a perl script served by the OAS
listener?
The LD_LIBRARY_PATH of the CGI script is reported as:
LD_LIBRARY_PATH =
/opt/ext/oracle/product/oas/ows/4.0/lib:/opt/ext/oracle/product/oas/lib:/opt/ext/oracle/product/oas/orb/4.0/lib
thus pointing to OAS home.
I tried to set it as '/opt/ext/oracle/product/8.1.6/lib' inside the CGI perl
script but it does not work.
Am I missing something?
Regards,
Agamemnon
Mark Vandenbroeck wrote:
>
> Agamemnon,
>
> This hasn't anything to do with DBI or DBD anymore, but here it is :
> Yes, you shouldn't mix both sets of libraries in your LD_LIBRARY_PATH. What I
>usually do is modify oraenv (there's a place provided for custom code near the end of
>the script) to set LD_LIBRARY_PATH so that it only contains directories from the
>ORACLE_HOME belonging to the ORACLE_SID given as arguments.
>
> Then you run oraenv each time you change environment (which is the purpose of oraenv
>anyway).
>
> Hope this helps,
>
> Mark
>
> Agamemnon Kaimakis wrote:
>
> > Mark,
> >
> > thanks for the reply.
> > Indeed, I use different ORACLE_HOMEs for the various products. Also, before
> > installing the DBD I use oraenv to set ORACLE_HOME to the RDBMS.
> > I've noticed that my problem is with the LD_LIBRARY_PATH as follows:
> > 1- If I remove the OAS lib paths -> DBD works, OAS won't start
> > 2- If I place the OAS lib paths at the end -> the same
> > 3- If I put the OAS lib paths at the beginning -> OAS is ok, DBD won't work!
> >
> > The 3rd is the default cause the LD_LIBRARY_PATH is set as follows in the
> > profile:
> > export
> >
>LD_LIBRARY_PATH=/opt/ext/oracle/product/8.1.6/lib:/opt/ext/oracle/product/8.1.6/jdbc/lib:/opt/ext/oracle/product/dev6i/lib:/usr/lib:/usr/openwin/lib:/usr/dt/lib:/usr/ucblib
> > and then OAS and Dev add to it through the scripts:
> > source /opt/ext/oracle/product/oas/ows/4.0/install/owsenv_bsh.sh
> > source /opt/ext/oracle/product/dev6i/dev6i.sh
> >
> > Is there a way to overcome this problem? It seems that there is some kind of
> > incompatibility among the RDBMS and OAS4 libs.
> >
> > Regards,
> > Agamemnon
> >
> > Mark Vandenbroeck wrote:
> > >
> > > Agamemnon,
> > >
> > > The solution to your problem (and the recommended way of installing, regardless
>of DBD stuff) is to install your RDBMS and OAS in a separate ORACLE_HOME. When you
>install DBD, your ORACLE_HOME should be pointing to the RDBMS.
> > >
> > > If you don't install in separate ORACLE_HOMEs, you will run into problems sooner
>or later, even if you manage to get DBD working.
> > >
> > > Hope this helps,
> > >
> > > Mark
> > >
> > > Agamemnon Kaimakis wrote:
> > >
> > > > Hi dbi-users,
> > > >
> > > > I have problems building DBD 1.06 with Oracle 8.1.6 and Oracle Application
> > > > Server 4.0.8.2
> > > > I upgraded Oracle from 8.0.4 -> 8.1.6 and OAS from 3.0.2 -> 4.0.8.2
> > > > (configuration: Solaris 2.6, Perl 5.005_03, DBI 1.15 and DBD 1.06).
> > > > Make test returns the message "You must install a Solaris patch to run this
> > > > version of the Java runtime."
> > > > Full outcome of make and make test is at the end of the message.
> > > >
> > > > Any help would be really appreciated.
> > > > I've searched extensively the archives of dbi-users and clp.modules newsgroup
> > > > and I've tried several workarounds.
> > > > My problem is not with the RDBMS because during the installation I followed
> > > > custom installation and chose NOT to install the Advanced Security option. This
> > > > option (with its java components) is causing the problems to the DBD. But I
> > > > couldn't do the same with OAS.
> > > >
> > > > I tried 2 of the suggestions of README.java with no success:
> > > > 1) OAS won't work without the java stuff.
> > > > 2) LD_PRELOAD produces core dumps in shell commands
> > > > I haven't tried re-building Perl with thread support cause it's a production
> > > > system and (according to the readme file) it's still experimental.
> > > >
> > > > Any other ideas?
> > > > Is the solution of this problem planned for the next DBD release?
> > > >
> > > > Thanks and regards,
> > > > Agamemnon
> > > >
> > > > ---------------------------------------------------------------------
> > > > perl -V
> > > > ---------
> > > > Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
> > > > Platform:
> > > > osname=solaris, osvers=2.6, archname=sun4-solaris
> > > > uname='sunos beavis 5.6 generic_105181-20 sun4u sparc sunw,ultra-250 '
> > > > hint=recommended, useposix=true, d_sigaction=define
> > > > usethreads=undef useperlio=undef d_sfio=undef
> > > > Compiler:
> > > > cc='gcc', optimize='-O', gccversion=2.8.1
> > > > cppflags='-I/usr/local/include'
> > > > ccflags ='-I/usr/local/include'
> > > > stdchar='unsigned char', d_stdstdio=define, usevfork=false
> > > > intsize=4, longsize=4, ptrsize=4, doublesize=8
> > > > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
> > > > alignbytes=8, usemymalloc=y, prototype=define
> > > > Linker and Libraries:
> > > > ld='gcc', ldflags =' -L/usr/local/lib'
> > > > libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
> > > > libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
> > > > libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
> > > > Dynamic Linking:
> > > > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
> > > > cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
> > > >
> > > > Characteristics of this binary (from libperl):
> > > > Built under solaris
> > > > Compiled at Jul 3 2000 12:07:04
> > > > @INC:
> > > > /opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris
> > > > /opt/ojs/u01/ojs2/perl5/lib/5.00503
> > > > /opt/ojs/u01/ojs2/perl5/lib/site_perl/5.005/sun4-solaris
> > > > /opt/ojs/u01/ojs2/perl5/lib/site_perl/5.005
> > > > .
> > > >
> > > > -----------------------------------------------------------------
> > > > env | grep LD
> > > > -------------
> > > >
>LD_LIBRARY_PATH=/opt/ext/oracle/product/oas/orb/4.0/lib:/opt/ext/oracle/product/oas/ows/4.0/lib:/opt/ext/oracle/product/oas/ows/4.0/jdk/jre/lib/sparc:/opt/ext/oracle/product/oas/ots/1.0/lib:/opt/ext/oracle/product/oas/lib:/opt/ext/oracle/product/8.1.6/lib:/opt/ext/oracle/product/8.1.6/jdbc/lib:/opt/ext/oracle/product/dev6i/lib:/usr/lib:/usr/openwin/lib:/usr/dt/lib:/usr/ucblib
> > > >
> > > > ------------------------------------------------------------------
> > > > make
> > > > --------
> > > > gcc -c -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/public
> > > > -I/opt/ext/oracle/product/8.1.6/plsql/public
> > > > -I/opt/ext/oracle/product/8.1.6/network/public
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/site_perl/5.005/sun4-solaris/auto/DBI
> > > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fPIC
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE -Wall -Wno-comment
> > > > Oracle.c
> > > > /opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE/patchlevel.h:41: warning:
> > > > `local_patches' defined but not used
> > > > gcc -c -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/public
> > > > -I/opt/ext/oracle/product/8.1.6/plsql/public
> > > > -I/opt/ext/oracle/product/8.1.6/network/public
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/site_perl/5.005/sun4-solaris/auto/DBI
> > > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fPIC
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE -Wall -Wno-comment
> > > > dbdimp.c
> > > > dbdimp.c: In function `ora_st_blob_read':
> > > > dbdimp.c:1494: warning: long int format, int arg (arg 8)
> > > > dbdimp.c: In function `ora_st_destroy':
> > > > dbdimp.c:1624: warning: unused variable `imp_dbh'
> > > > /opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE/patchlevel.h: At top
> > > > level:
> > > > /opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE/patchlevel.h:41: warning:
> > > > `local_patches' defined but not used
> > > > gcc -c -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/public
> > > > -I/opt/ext/oracle/product/8.1.6/plsql/public
> > > > -I/opt/ext/oracle/product/8.1.6/network/public
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/site_perl/5.005/sun4-solaris/auto/DBI
> > > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fPIC
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE -Wall -Wno-comment
> > > > oci7.c
> > > > /opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE/patchlevel.h:41: warning:
> > > > `local_patches' defined but not used
> > > > gcc -c -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/public
> > > > -I/opt/ext/oracle/product/8.1.6/plsql/public
> > > > -I/opt/ext/oracle/product/8.1.6/network/public
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ext/oracle/product/8.1.6/rdbms/demo
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/site_perl/5.005/sun4-solaris/auto/DBI
> > > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fPIC
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE -Wall -Wno-comment
> > > > oci8.c
> > > > oci8.c: In function `dbd_rebind_ph_rset':
> > > > oci8.c:414: warning: implicit declaration of function `pp_rebind_ph_rset_in'
> > > > oci8.c: In function `init_lob_refetch':
> > > > oci8.c:1214: warning: value computed is not used
> > > > /opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE/patchlevel.h: At top
> > > > level:
> > > > /opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris/CORE/patchlevel.h:41: warning:
> > > > `local_patches' defined but not used
> > > > Running Mkbootstrap for DBD::Oracle ()
> > > > chmod 644 Oracle.bs
> > > > LD_RUN_PATH="" gcc -o blib/arch/auto/DBD/Oracle/Oracle.so -G -L/usr/local/lib
> > > > Oracle.o dbdimp.o oci7.o oci8.o -L/opt/ext/oracle/product/8.1.6/lib/
> > > > -L/opt/ext/oracle/product/8.1.6/rdbms/lib -lclntsh `sed -e 's/-ljava//g'
> > > > /opt/ext/oracle/product/8.1.6/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8
>-lnro8
> > > > `sed -e 's/-ljava//g' /opt/ext/oracle/product/8.1.6/lib/ldflags` -lnsgr8
> > > > -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm
> > > > -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g'
> > > > /opt/ext/oracle/product/8.1.6/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8
>-lnro8
> > > > `sed -e 's/-ljava//g' /opt/ext/oracle/product/8.1.6/lib/ldflags` -lnsgr8
> > > > -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8
> > > > -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8
> > > > -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `cat
> > > > /opt/ext/oracle/product/8.1.6/lib/sysliblist` `if [ -f /usr/lib/libsched.so ] ;
> > > > then echo -lsched ; else true; fi` -R/opt/ext/oracle/product/8.1.6/lib -laio
> > > > -lposix4 -lkstat -lm -lthread
> > > > chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
> > > > cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
> > > > chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
> > > > /opt/ojs/u01/ojs2/perl5/bin/perl -Iblib/arch -Iblib/lib
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503 ora_explain.PL ora_explain
> > > > Extracted ora_explain from ora_explain.PL with variable substitutions.
> > > > mkdir blib/script
> > > > cp ora_explain blib/script/ora_explain
> > > > /opt/ojs/u01/ojs2/perl5/bin/perl
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503 -MExtUtils::MakeMaker -e
> > > > "MY->fixin(shift)" blib/script/ora_explain
> > > > Manifying blib/man3/DBD::Oraperl.3
> > > > Manifying blib/man3/DBD::Oracle.3
> > > > Manifying blib/man1/ora_explain.1
> > > >
> > > > --------------------------------------------------------
> > > > make test
> > > > -----------
> > > > PERL_DL_NONLAZY=1 /opt/ojs/u01/ojs2/perl5/bin/perl -Iblib/arch -Iblib/lib
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503/sun4-solaris
> > > > -I/opt/ojs/u01/ojs2/perl5/lib/5.00503 -e 'use Test::Harness qw(&runtests
> > > > $verbose); $verbose=0; runtests @ARGV;' t/*.t
> > > > t/base..............You must install a Solaris patch to run this version of the
> > > > Java runtime.
> > > > Please see the README and release notes for more information.
> > > > Exiting.
> > > > dubious
> > > > Test returned status 1 (wstat 256, 0x100)
> > > > DIED. FAILED tests 4-5
> > > > Failed 2/5 tests, 60.00% okay
> > > > t/general...........You must install a Solaris patch to run this version of the
> > > > Java runtime.
> > > > Please see the README and release notes for more information.
> > > > Exiting.
> > > > dubious
> > > > Test returned status 1 (wstat 256, 0x100)
> > > > t/long..............You must install a Solaris patch to run this version of the
> > > > Java runtime.
> > > > Please see the README and release notes for more information.
> > > > Exiting.
> > > > dubious
> > > > Test returned status 1 (wstat 256, 0x100)
> > > > t/plsql.............You must install a Solaris patch to run this version of the
> > > > Java runtime.
> > > > Please see the README and release notes for more information.
> > > > Exiting.
> > > > dubious
> > > > Test returned status 1 (wstat 256, 0x100)
> > > > t/reauth............skipping test on this platform
> > > > Failed Test Status Wstat Total Fail Failed List of failed
> > > > -------------------------------------------------------------------------------
> > > > t/base.t 1 256 5 2 40.00% 4-5
> > > > t/general.t 1 256 ?? ?? % ??
> > > > t/long.t 1 256 ?? ?? % ??
> > > > t/plsql.t 1 256 ?? ?? % ??
> > > > 1 test skipped.
> > > > Failed 4/5 test scripts, 20.00% okay. 2/5 subtests failed, 60.00% okay.
> > > > *** Error code 29
> > > > make: Fatal error: Command failed for target `test_dynamic'
> > >
> > > --
> > > Mark Vandenbroeck Mobile : +32-495-59.55.62
> > > EMEA Support Information Systems Email : [EMAIL PROTECTED]
> > > AIM : markvdb
>
> --
> Mark Vandenbroeck Mobile : +32-495-59.55.62
> EMEA Support Information Systems Email : [EMAIL PROTECTED]
> AIM : markvdb
