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
