Mark,
I have tried that and it doesn't work in this case. It seems that the env vars
must be set before the loading of the perl interpreter (e.g. through a wrapper
script?).
Regards,
Agamemnon
Mark Vandenbroeck wrote:
>
> Agamemnon,
>
> What I usually do (because I have no control over the environment passed to me by
>the webserver) is set all my Oracle-related env vars in the CGI script itself.
>
> Like
>
> $ENV{ORACLE_SID} = 'MYSID';
> $ENV{ORACLE_HOME} = '/u01/app/oracle/product/8.1.7';
> $ENV{LD_LIBRARY_PATH} = "$ENV{ORACLE_HOME}/lib:$ENV{LD_LIBRARY_PATH}";
> $ENV{TNS_ADMIN} = '/u01/app/oracle/tns/admin';
>
> and so on ..
>
> Brgds,
>
> Mark
>
> Agamemnon Kaimakis wrote:
>
> > 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
>
> --
> Mark Vandenbroeck Mobile : +32-495-59.55.62
> EMEA Support Information Systems Email : [EMAIL PROTECTED]
> AIM : markvdb
