Hello
While doing "make test" of DBI:Oracle it gave a connect() failed:
ORA-12560: TNS:protocol adapter error.
Can any one help me.
the Oracle version is oracle 8.1.7
The complete log of all steps of the build are included.
-----------------------------------------------------------------------------
----------
<---------------------perl Makefile.pl---------------->
Using DBI 1.201 installed in E:/Perl/site/lib/auto/DBI
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in E:/oracle/ora81
Found rdbms/demo/oratypes.h
Found header files in rdbms/demo.
Found oci directory
Using OCI directory 'oci'
Found oci/lib/MSVC/oci.lib library
Found oci/lib/MSVC/ociw32.lib library
Using oci/lib/MSVC/OCI.lib
System: perl5.006
Compiler: cl -O1 -MD -DNDEBUG -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE
-DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DPERL_MSVCRT_READFIX
Linker: <ld not found>
Sysliblist:
MakeMaker (v5.45)
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce ( <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED])]
DEFINE => q[]
DIR => []
EXE_FILES => [q[ora_explain]]
INC => q[-IE:/oracle/ora81/oci/include -IE:/oracle/ora81/rdbms/demo
-IE:/Perl/site/lib/auto/DBI]
LIBS => [q[-LE:/oracle/ora81/oci/LIB/MSVC OCI]]
NAME => q[DBD::Oracle]
OBJECT => q[$(O_FILES)]
PREREQ_PM => { DBI=>q[0] }
VERSION_FROM => q[Oracle.pm]
clean => { FILES=>q[Oracle.xsi dll.base dll.exp sqlnet.log libOracle.def
ora_explain mk.pm] }
dist => { DIST_DEFAULT=>q[clean distcheck disttest ci tardist],
PREOP=>q[$(MAKE) -f Makefile.old distdir], COMPRESS=>q[gzip -v9],
SUFFIX=>q[gz] }
Using PERL=E:\Perl\bin\Perl.exe
------------------ some text removed to reduce size -------------
LD_RUN_PATH=E:/oracle/ora81/lib:E:/oracle/ora81/rdbms/lib
Using DBD::Oracle 1.12.
Using DBI 1.201 installed in E:/Perl/site/lib/auto/DBI
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
(in cleanup) Can't call method "FETCH" on an undefined value at
E:/Perl/site/lib/Win32/TieRegistry.pm line 1486 during global destruction.
<-----------------make----------------------->
Microsoft (R) Program Maintenance Utility Version 6.00.8168.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
Skip blib\lib/oraperl.ph (unchanged)
Skip blib\lib\DBD\Oracle.pm (unchanged)
Skip blib\arch\auto\DBD\Oracle/mk.pm (unchanged)
Skip blib\arch\auto\DBD\Oracle/dbdimp.h (unchanged)
Skip blib\arch\auto\DBD\Oracle/ocitrace.h (unchanged)
Skip blib\arch\auto\DBD\Oracle/Oracle.h (unchanged)
Skip blib\lib/Oraperl.pm (unchanged)
cl -c -IE:/oracle/ora81/oci/include -IE:/oracle/ora81/rdbms/demo
-IE:/Perl/site/lib/auto/DBI -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT
-DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DPERL_MSVCRT_READFIX -O1 -MD -DNDEBUG -DVERSION=\"1.12\"
-DXS_VERSION=\"1.12\" -IE:\Perl\lib\CORE Oracle.c
Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 12.00.8168 for 80x86
Copyright (C) Microsoft Corp 1984-1998. All rights reserved.
Oracle.c
Oracle.xs(69) : warning C4133: 'function' : incompatible types - from 'struct
_PerlIO *' to 'struct _iobuf *'
Oracle.xs(79) : warning C4133: 'function' : incompatible types - from 'struct
_PerlIO *' to 'struct _iobuf *'
Oracle.xs(83) : warning C4133: 'function' : incompatible types - from 'struct
_PerlIO *' to 'struct _iobuf *'
Oracle.xs(86) : warning C4133: 'function' : incompatible types - from 'struct
_PerlIO *' to 'struct _iobuf *'
cl -c -IE:/oracle/ora81/oci/include -IE:/oracle/ora81/rdbms/demo
-IE:/Perl/site/lib/auto/DBI -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT
-DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DPERL_MSVCRT_READFIX -O1 -MD -DNDEBUG -DVERSION=\"1.12\"
-DXS_VERSION=\"1.12\" -IE:\Perl\lib\CORE dbdimp.c
Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 12.00.8168 for 80x86
Copyright (C) Microsoft Corp 1984-1998. All rights reserved.
dbdimp.c
----------- all warnings removed -----------------
cl -c -IE:/oracle/ora81/oci/include -IE:/oracle/ora81/rdbms/demo
-IE:/Perl/site/lib/auto/DBI -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT
-DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DPERL_MSVCRT_READFIX -O1 -MD -DNDEBUG -DVERSION=\"1.12\"
-DXS_VERSION=\"1.12\" -IE:\Perl\lib\CORE oci7.c
Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 12.00.8168 for 80x86
Copyright (C) Microsoft Corp 1984-1998. All rights reserved.
oci7.c
cl -c -IE:/oracle/ora81/oci/include -IE:/oracle/ora81/rdbms/demo
-IE:/Perl/site/lib/auto/DBI -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT
-DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DPERL_MSVCRT_READFIX -O1 -MD -DNDEBUG -DVERSION=\"1.12\"
-DXS_VERSION=\"1.12\" -IE:\Perl\lib\CORE oci8.c
Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 12.00.8168 for 80x86
Copyright (C) Microsoft Corp 1984-1998. All rights reserved.
oci8.c
------------------ all warnings removed ----------------
"Running Mkbootstrap for DBD::Oracle ()"
E:\Perl\bin\Perl.exe -IE:\Perl\lib -IE:\Perl\lib -MExtUtils::Command -e
chmod 644 Oracle.bs
link -out:blib\arch\auto\DBD\Oracle\Oracle.dll -dll -nologo -nodefaultlib
-release -libpath:"E:\Perl\lib\CORE" -machine:x86 Oracle.obj dbdimp.obj
oci7.obj oci8.obj E:\Perl\lib\CORE\perl56.lib
E:\oracle\ora81\oci\LIB\MSVC\OCI.lib c:\util\Lib\oldnames.lib
c:\util\Lib\kernel32.lib c:\util\Lib\user32.lib c:\util\Lib\gdi32.lib
c:\util\Lib\winspool.lib c:\util\Lib\comdlg32.lib c:\util\Lib\advapi32.lib
c:\util\Lib\shell32.lib c:\util\Lib\ole32.lib c:\util\Lib\oleaut32.lib
c:\util\Lib\netapi32.lib c:\util\Lib\uuid.lib c:\util\Lib\wsock32.lib
c:\util\Lib\mpr.lib c:\util\Lib\winmm.lib c:\util\Lib\version.lib
c:\util\Lib\odbc32.lib c:\util\Lib\odbccp32.lib c:\util\Lib\msvcrt.lib
-def:Oracle.def
Creating library blib\arch\auto\DBD\Oracle\Oracle.lib and object
blib\arch\auto\DBD\Oracle\Oracle.exp
E:\Perl\bin\Perl.exe -IE:\Perl\lib -IE:\Perl\lib -MExtUtils::Command -e
chmod 755 blib\arch\auto\DBD\Oracle\Oracle.dll
E:\Perl\bin\Perl.exe -IE:\Perl\lib -IE:\Perl\lib -MExtUtils::Command -e cp
Oracle.bs blib\arch\auto\DBD\Oracle\Oracle.bs
E:\Perl\bin\Perl.exe -IE:\Perl\lib -IE:\Perl\lib -MExtUtils::Command -e
chmod 644 blib\arch\auto\DBD\Oracle\Oracle.bs
E:\Perl\bin\Perl.exe -IE:\Perl\lib -IE:\Perl\lib -MExtUtils::Command -e cp
ora_explain blib\script\ora_explain
E:\Perl\bin\Perl.exe -IE:\Perl\lib -IE:\Perl\lib -e "system qq[pl2bat.bat
].shift" blib\script\ora_explain
<----------------make test-------------->
Microsoft (R) Program Maintenance Utility Version 6.00.8168.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
E:\Perl\bin\Perl.exe -IE:\Perl\lib -IE:\Perl\lib -MExtUtils::Command -e cp
ora_explain blib\script\ora_explain
E:\Perl\bin\Perl.exe -IE:\Perl\lib -IE:\Perl\lib -e "system qq[pl2bat.bat
].shift" blib\script\ora_explain
E:\Perl\bin\Perl.exe -Mblib -IE:\Perl\lib -IE:\Perl\lib -e "use
Test::Harness qw(&runtests $verbose); $verbose=1; runtests @ARGV;" t\base.t
t\general.t t\long.t t\ph_type.t t\plsql.t t\reauth.t
Using C:/Perl/DB/DBD-Oracle-1.12/blib
t\base..............1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t\general...........DBI->connect() failed: ORA-12560: TNS:protocol adapter
error (DBD ERROR: OCIServerAttach) at t\general.t line 20
Unable to connect to Oracle (ORA-12560: TNS:protocol adapter error (DBD
ERROR: OCIServerAttach))
Tests skiped.
1..0
skipped test on this platform
t\long..............Unable to connect to Oracle (ORA-12560: TNS:protocol
adapter error (DBD ERROR: OCIServerAttach))
Tests skiped.
1..0
skipped test on this platform
t\ph_type...........DBI->connect() failed: ORA-12560: TNS:protocol adapter
error (DBD ERROR: OCIServerAttach) at t\ph_type.t line 24
Unable to connect to Oracle (ORA-12560: TNS:protocol adapter error (DBD
ERROR: OCIServerAttach))
Tests skipped.
1..0
skipped test on this platform
t\plsql.............Unable to connect to Oracle (ORA-12560: TNS:protocol
adapter error (DBD ERROR: OCIServerAttach))
Tests skiped.
1..0
skipped test on this platform
t\reauth............ORACLE_USERID_2 not defined.
Tests skiped.
1..0
skipped test on this platform
All tests successful, 5 tests skipped.
Files=6, Tests=5, 4 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU)
E:\Perl\bin\Perl.exe -Iblib\arch -Iblib\lib -IE:\Perl\lib -IE:\Perl\lib
test.pl
Oraperl test application $Revision: 1.4 $
Oraperl emulation interface version 1.41
DBD::Oracle 1.12 using OCI8 by Tim Bunce
DBI 1.201 by Tim Bunce
Data sources:
dbi:Oracle:HTP.MINDTREE.COM
dbi:Oracle:HTWORK.MINDTREE.COM
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as 'scott/tiger' (via ORACLE_USERID env var or default - recommend
name/passwd@dbname)
(ORACLE_SID='', TWO_TASK='')
(LOCAL='', REMOTE='')
ora_login: 12560: ORA-12560: TNS:protocol adapter error (DBD ERROR:
OCIServerAttach)
Generally set TWO_TASK or ORACLE_SID but not both at the same time.
Try to connect to the database using an oracle tool like sqlplus
only if that works should you suspect problems with DBD::Oracle.
Try leaving dbname value empty and set dbuser to name/passwd@dbname.
Test aborted.
(in cleanup) Can't call method "FETCH" on an undefined value at
E:/Perl/site/lib/Win32/TieRegistry.pm line 1486 during global destruction.
NMAKE : fatal error U1077: 'E:\Perl\bin\Perl.exe' : return code '0xff'
Stop.
<------------ perl -V ----------------->
Summary of my perl5 (revision 5 version 6 subversion 0) configuration:
Platform:
osname=MSWin32, osvers=4.0, archname=MSWin32-x86-multi-thread
uname=''
config_args='undef'
hint=recommended, useposix=true, d_sigaction=undef
usethreads=undef use5005threads=undef useithreads=define
usemultiplicity=define
useperlio=undef d_sfio=undef uselargefiles=undef
use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef
Compiler:
cc='cl', optimize='-O1 -MD -DNDEBUG', gccversion=
cppflags='-DWIN32'
ccflags ='-O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT
-DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
-DPERL_MSVCRT_READFIX'
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=10
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=4
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='link', ldflags ='-nologo -nodefaultlib -release
-libpath:"E:\Perl\lib\CORE" -machine:x86'
libpth="E:\Perl\lib\CORE"
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 wsock32.lib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib
msvcrt.lib
libc=msvcrt.lib, so=dll, useshrplib=yes, libperl=perl56.lib
Dynamic Linking:
dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '
cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -release
-libpath:"E:\Perl\lib\CORE" -machine:x86'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS PERL_IMPLICIT_CONTEXT
PERL_IMPLICIT_SYS
Locally applied patches:
ActivePerl Build 616
Built under MSWin32
Compiled at Jul 14 2000 13:47:17
@INC:
E:/Perl/lib
E:/Perl/site/lib
.
