RE: ORA-12154 (DBD ERROR: OCIServerAttach)


>
>
> Greetings.
>
> Context:
>
> Windows XP client
>
> Perl
> This is perl, v5.8.7 built for MSWin32-x86-multi-thread
> (with 7 registered patches, see perl -V for more detail)
> Binary build 813 [148120] provided by ActiveState
> http://www.ActiveState.com
> Built Jun 6 2005 13:36:37
>
> Note: perl -V output below
>
> DBI
> DBI version 1.48
> DBD-ODBC version 1.13
> DBD-Oracle version 1.16
>
> Installed via (a varient of) this:
> ppm install -force -follow
> ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBI.ppd
> ppm install -force -follow
> ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBD-Oracle.ppd
> ppm install -force -follow
> ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBD-ODBC.ppd
>
> Oracle server (remote)
> Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit
> Production
> With the Partitioning option
> JServer Release 8.1.7.4.0 - 64bit Production
>
> ORACLE_HOME is set both in the registry (via Oracle client-side
> installation process) and also in the system environment variables
> (by me, for good measure?).

Chances are something is wrong in the registry or environment. Is there
a TNS_ADMIN set anywhere? Are you running under a web server when it's
not working?

Jeff

>
> Symptoms:
> SqlPlus connection works fine.
>
> A perl script attempting connection works fine ONLY when the
> script is run from \orant\net80\admin.
>
> When the script is run from anywhere else, I get this error:
>
> ORA-12154: TNS:could not resolve the connect identifier specified
> (DBD ERROR: OCIServerAttach)
>
> Note that printf("%s\n", $ENV{'ORACLE_HOME'});
> displays c:\orant (as expected).
>
> Help!
> And Thanks!
> - C Seelig =====================================================
> C:\Documents and Settings\SeeligC\Start Menu>perl -V
> Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
> Platform:
> osname=MSWin32, osvers=5.0, archname=MSWin32-x86-multi-thread
> uname=''
> config_args='undef'
> hint=recommended, useposix=true, d_sigaction=undef
> 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='cl', ccflags ='-nologo -Gf -W3 -MD -Zi -DNDEBUG -O1 -DWIN32
> -D_CONSOLE
> -DNO_STRICT -DHAVE_DES_FCRYPT -DBUILT_BY_ACTIVESTATE
> -DNO_HASH_SEED
> -DUSE_SITECUSTOMIZE
> -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
> -DPERL_MSVCRT_READFIX',
> optimize='-MD -Zi -DNDEBUG -O1',
> cppflags='-DWIN32'
> ccversion='12.00.8804', gccversion='', gccosandvers=''
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
> d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=10
> ivtype='long', ivsize=4, nvtype='double', nvsize=8,
> Off_t='__int64',
> lseeksize=8
> alignbytes=8, prototype=define
> Linker and Libraries:
> ld='link', ldflags ='-nologo -nodefaultlib -debug -opt:ref,icf
> -libpath:"C:\Perl\lib\CORE" -machine:x86'
> libpth=\lib
> libs= oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib
> comdlg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib
> netapi32.lib uuid.lib
> ws2_32.lib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib
> msvcrt.lib
> perllibs= oldnames.lib kernel32.lib user32.lib gdi32.lib
> winspool.lib
> comdlg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib
> netapi32.lib uuid.lib
> ws2_32.lib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib
> msvcrt.lib
> libc=msvcrt.lib, so=dll, useshrplib=yes, libperl=perl58.lib
> gnulibc_version='undef'
> Dynamic Linking:
> dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '
> cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -debug
> -opt:ref,icf
> -libpath:"C:\Perl\lib\CORE" -machine:x86'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
> USE_SITECUSTOMIZE PERL_IMPLICIT_CONTEXT
> PERL_IMPLICIT_SYS
> Locally applied patches:
> ActivePerl Build 813 [148120]
> Iin_load_module moved for compatibility with build 806
> PerlEx hacks for CGI::Carp
> Less verbose ExtUtils::Install and Pod::Find
> instmodsh upgraded from ExtUtils-MakeMaker-6.25
> 24699 ICMP_UNREACHABLE handling in Net::Ping
> 21540 Fix backward-compatibility issues in if.pm
> Built under MSWin32
> Compiled at Jun 6 2005 13:36:37
> @INC:
> C:/Perl/lib
> C:/Perl/site/lib
> .
>
>
.

Relevant Pages

  • Re: Unable to install the standard client using login scripts
    ... What are you using in the logon script to do installs? ... configured your client push installation account and also any client ... > I have SMS 2003 in AD on Windows 2003 Servers. ... > client installation based on group memberships in the login scripts. ...
    (microsoft.public.sms.setup)
  • texlive font installation perl script
    ... follow two installation instructions on the web, ... logically, if I understand the font installation inputs, it would seem ... like to volunteer to create a perl script that does this for me and ...
    (comp.text.tex)
  • Re: How (best) to use web-from entry of an OTP/OPIE password to control a PF-firewall?
    ... A perl script witch uses Auth::opie cpan. ... PHP talks to the perl executable. ... I understand how to set up OpenVPN passthrough from a remote client ...
    (Security-Basics)
  • Re: Dynamic content and search engines
    ... Winston Kotzan wrote: ... Is it possible to pass a parameter to my dynamic page script ... I have various sites, all in Perl. ... Apache passes various environment variables & it differs from installation ...
    (comp.lang.perl.misc)
  • RE: New on Mail::Send
    ... The remote is very strictly managed, ... > where perl is going. ... The script appears to be OK. ...
    (perl.beginners)