DBI connect('','/',...) failed: ERROR OCIEnvInit

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 04/12/04

  • Next message: Henri Asseily: "Re: DBI->quote with DBD::Sysbase"
    Date: Mon, 12 Apr 2004 15:44:00 -0600
    To: <dbi-users@perl.org>
    
    

    All,

    I am getting the above error when attempting to connect to anOracle 9.2 instance (9.2.0.4.0). This instance was recently upgraded from Oracle 8.1.7.4.0

    perl -V output:

    Summary of my perl5 (revision 5.0 version 8 subversion 2) configuration:
      Platform:
        osname=linux, osvers=2.4.21-169-smp, archname=i686-linux-thread-multi
        uname='linux dbprod01bldr 2.4.21-169-smp #1 smp fri jan 2 19:10:04 utc 2004 i686 unknown
        config_args=''
        hint=recommended, useposix=true, d_sigaction=define
        usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
        useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
        use64bitint=undef use64bitall=undef uselongdouble=undef
        usemymalloc=n, bincompat5005=undef
      Compiler:
        cc='/usr/bin/gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-strict-
        optimize='-O3',
        cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-strict-aliasing -I/usr/loc
        ccversion='', gccversion='3.2.2', gccosandvers=''
        intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
        d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
        ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
        alignbytes=4, prototype=define
      Linker and Libraries:
        ld='/usr/bin/gcc', ldflags =' -L/usr/local/lib'
        libpth=/usr/local/lib /lib /usr/lib
        libs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
        perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
        libc=, so=so, useshrplib=false, libperl=libperl.a
        gnulibc_version='2.2.5'
      Dynamic Linking:
        dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
        cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'

    Characteristics of this binary (from libperl):
      Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
      Built under linux
      Compiled at Jan 8 2004 16:57:28
      @INC:
        /usr/local/lib/perl5/5.8.2/i686-linux-thread-multi
        /usr/local/lib/perl5/5.8.2
        /usr/local/lib/perl5/site_perl/5.8.2/i686-linux-thread-multi
        /usr/local/lib/perl5/site_perl/5.8.2
        /usr/local/lib/perl5/site_perl
        .

    DBD::Oracle version: 1.14 (also fails with v 1.15)
    DBI version: 1.39

    All of the above running on SLES 8 (SuSE); gcc version: 2.95.3

    Does anyone know what could possibly be the problem?

    Thanks in advance.

    -----------------
    Ron Reidy
    Senior DBA
    Array BioPharma, Inc.
    303.386.1480

    This electronic message transmission is a PRIVATE communication which contains
    information which may be confidential or privileged. The information is intended
    to be for the use of the individual or entity named above. If you are not the
    intended recipient, please be aware that any disclosure, copying, distribution
    or use of the contents of this information is prohibited. Please notify the
    sender of the delivery error by replying to this message, or notify us by
    telephone (877-633-2436, ext. 0), and then delete it from your system.


  • Next message: Henri Asseily: "Re: DBI->quote with DBD::Sysbase"

    Relevant Pages

    • Res: RE: RE: Problems changing from 1.30 to 1.42
      ... With DBI 1.30 it works just it is: ... >>This electronic message transmission is a PRIVATE communication which contains ... >>intended recipient, please be aware that any disclosure, copying, distribution ... >>sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • RE: How to perform JOINs with DBI
      ... How to perform JOINs with DBI ... This electronic message transmission is a PRIVATE communication which contains ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • RE: RE: Problems changing from 1.30 to 1.42
      ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • RE: RE: DBI->Connect returning UNDEF in cgi but not in standalone prog
      ... You are returning undef. ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • RE: RE: Problems changing from 1.30 to 1.42
      ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)