DBD::Oracle on HPUX (was: help me ,please!)

DBD::Oracle on HPUX (was: help me ,please!)

am 18.11.2005 14:06:41 von Tim.Bunce

----- Forwarded message from liu liu -----

X-Pobox-Antispam: dnsbl/blackholes.five-ten-sg.com returned deny: for 65.54.168.32(bay113-f22.bay113.hotmail.com)
X-Originating-IP: [211.94.130.232]
X-Originating-Email: [logagain@hotmail.com]
From: "liu liu"
To: Tim.Bunce@pobox.com
Subject: help me ,please!
Date: Fri, 18 Nov 2005 16:38:40 +0800

dear,tim.Bunce:
how are you!i come from chinese.my english is very poor.i have some
problems about installing dbd-oracle.
all steps of the build:
1.perl Makefile.PL
2.cat Makefile | sed 's/PERL_DL_NONLAZY=1/PERL_DL_NONLAZY=0/g' >
Makefile.tmp
3.mv Makefile.tmp Makefile
4.make
5.make test
at the sencodly step and thirdly ,there is no problem.at the first step and
fourthly , there are some hints.
***********************
some hints at the firstly:

# perl Makefile.PL
Using DBI 1.48 (for perl 5.008 on PA-RISC1.1-thread-multi) installed in
/opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto/D BI/

Configuring DBD::Oracle ...

>>> Remember to actually *READ* the README file!
Especially if you have any problems.

Using Oracle in /opt/oracle/product/9.2.0
DEFINE _SQLPLUS_RELEASE = "902000600" (CHAR)
Oracle version 9.2.0.6 (9.2)
Found /opt/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk
Found /opt/oracle/product/9.2.0/otrace/demo/atmoci.mk
Found /opt/oracle/product/9.2.0/precomp/demo/proc/demo_proc.mk
Using /opt/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/product/9.2.0/rdbms/lib/env_rdbms.mk

Attempting to discover Oracle OCI build rules
gcc -c -I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/plsql/public
-I/opt/oracle/product/9.2.0/network/public
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/plsql/public
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto /DBI/
-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -fPIC -mpa-risc-1-1
-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.6\" DBD_ORA_OBJ.c
by executing: [make -f /opt/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk
build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true OPTIMIZE=
CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
[ true -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o build
-L/opt/oracle/product/9.2.0/rdbms/lib/ -L/opt/oracle/product/9.2.0/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/opt/oracle/product/9.2.0/lib/ldflags` `cat
/opt/oracle/product/9.2.0/lib/sysliblist` -lm ]

Warning: Oracle is built with multi-threading libraries
You will most likely need to rebuild perl from sources
with the following libraries: -lcl -lpthread
Warning: Stripping `cat /opt/oracle/product/9.2.0/lib32/ldflags` `cat
/opt/oracle/product/9.2.0/lib32/sysliblist`
from link command, because it contains libraries not
compiled with +z or +Z (PIC) causing link to fail.
Furthermore, we should have already grabbed these libraries
Found header files in plsql/public rdbms/public rdbms/demo.
***
*** Warning: If you have trouble, see README.hpux...
you may have to build your own perl, or go hunting for libraries
*** Warning: If you have trouble, try perl Makefile.PL -l
***

Checking for functioning wait.ph


System: perl5.008 hp-ux bertha b.11.00 u 9000800 136901587 unlimited-user
license
Compiler: gcc -O -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -lrt -lpthread -l:libnss_dns.1
Oracle makefiles would have used these definitions but we override them:
CC: cc

CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) $(OPTIMIZE) $(CDEBUG) +DA2.0W +DS2.0 -DSS_64BIT_SERVER
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/plsql/public
-I/opt/oracle/product/9.2.0/network/public $(SPFLAGS) $(LPFLAGS)
$(SHARED_CFLAG) $(USRFLAGS)]

LDFLAGS: -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o $@ -L$(PRODLIBHOME)
-L$(LIBHOME)
[-Wl,+s -Wl,+n +DA2.0W +DS2.0 -o $@
-L/opt/oracle/product/9.2.0/rdbms/lib/ -L$(LIBHOME)]


Linking with OTHERLDFLAGS = +s +n
-L/opt/oracle/product/9.2.0/rdbms/lib32/ -L/opt/oracle/product/9.2.0/lib32/
-lclntsh -lm [from 'build' rule]


LD_RUN_PATH=/opt/oracle/product/9.2.0/lib32:/opt/oracle/prod uct/9.2.0/rdbms/lib32

Using DBD::Oracle 1.16.
Using DBD::Oracle 1.16.
Using DBI 1.48 (for perl 5.008 on PA-RISC1.1-thread-multi) installed in
/opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto/D BI/
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?)

#
some hints at the fourthly:
# cat Makefile | sed 's/PERL_DL_NONLAZY=1/PERL_DL_NONLAZY=0/g' >
Makefile.tmp
# mv Makefile.tmp Makefile
# make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c -I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/plsql/public
-I/opt/oracle/product/9.2.0/network/public
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/plsql/public
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto /DBI/
-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -fPIC -mpa-risc-1-1
-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.6\" Oracle.c
Oracle.c: In function `XS_DBD__Oracle_constant':
Oracle.c:24: warning: 'RETVAL' might be used uninitialized in this function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_write':
Oracle.c:1197: warning: 'locator' might be used uninitialized in this
function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_append':
Oracle.xs:191: warning: unused variable `startp'
Oracle.c:1268: warning: 'locator' might be used uninitialized in this
function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_read':
Oracle.c:1362: warning: 'locator' might be used uninitialized in this
function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_trim':
Oracle.c:1429: warning: 'locator' might be used uninitialized in this
function
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_length':
Oracle.c:1464: warning: 'locator' might be used uninitialized in this
function
gcc -c -I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/plsql/public
-I/opt/oracle/product/9.2.0/network/public
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/plsql/public
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto /DBI/
-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -fPIC -mpa-risc-1-1
-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.6\" dbdimp.c
dbdimp.c: In function `dbd_discon_all':
dbdimp.c:121: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_db_login6':
dbdimp.c:282: warning: unused variable `o'
dbdimp.c:283: warning: unused variable `l'
dbdimp.c:239: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_db_disconnect':
dbdimp.c:689: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_db_destroy':
dbdimp.c:726: warning: unused variable `my_perl'
dbdimp.c: In function `pp_exec_rset':
dbdimp.c:1228: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_st_execute':
dbdimp.c:1600: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_st_finish':
dbdimp.c:1798: warning: unused variable `Perl___notused'
dbdimp.c: In function `ora_st_destroy':
dbdimp.c:1885: warning: unused variable `my_perl'
gcc -c -I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/plsql/public
-I/opt/oracle/product/9.2.0/network/public
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/plsql/public
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto /DBI/
-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -fPIC -mpa-risc-1-1
-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.6\" oci8.c
oci8.c: In function `ora_st_fetch':
oci8.c:1382: warning: unused variable `Perl___notused'
oci8.c:1389: warning: unused variable `Perl___notused'
oci8.c: At top level:
oci8.c:566: warning: 'fetch_func_nty' defined but not used
oci8.c:1012: warning: 'fbh_setup_getrefpv' defined but not used
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
gcc +b
"/opt/oracle/product/9.2.0/lib32:/opt/oracle/product/9.2.0/r dbms/lib32"
-shared -static-libgcc -fPIC Oracle.o dbdimp.o oci8.o +s +n
-L/opt/oracle/product/9.2.0/rdbms/lib32/ -L/opt/oracle/product/9.2.0/lib32/
-lclntsh -lm -o blib/arch/auto/DBD/Oracle/Oracle.sl
gcc: +b: No such file or directory
gcc: /opt/oracle/product/9.2.0/lib32:/opt/oracle/product/9.2.0/rd bms/lib32:
No such file or directory
gcc: +s: No such file or directory
gcc: +n: No such file or directory
*** Error exit code 1

Stop.
#
i don't konw what can i do,can you help me?

system inveronment:
os :hpux b 11.11
oracle :9201+9206patch
root:
..profile:
# @(#)B.11.11_LR

# Default (example of) super-user's .profile file


# Do not put "." in PATH; it is a potential security breach.
# Do not put "/usr/local/bin" in PATH; it is a potential security breach.
# Example assumes /home/root exists.
set +u

PATH=/usr/sbin:$PATH:/sbin:/home/root:/usr/local/bin:/opt/aC C/bin
export PATH
# Be sure that VUE does not invoke tty commands

if [ ! "$VUE" ]; then

# Set up the terminal:
if [ "$TERM" = "" ]
then
eval ` tset -s -Q -m ':?hp' `
else
eval ` tset -s -Q `
fi
stty erase "^H" kill "^U" intr "^C" eof "^D"
stty hupcl ixon ixoff
tabs

echo
echo "Value of TERM has been set to \"$TERM\". "
export TERM

EDITOR=vi
export EDITOR

fi # if !VUE


# Set up shell environment:

set -u # error if undefined
variable.
trap "echo 'logout root'" 0 # what to do on exit.


# Set up shell variables:

MAIL=/var/mail/root
# don't export, so only login shell checks.

echo "WARNING: YOU ARE SUPERUSER !!\n"
SHLIB_PATH=/opt/gnome/lib:/usr/local/bin
export SHLIB_PATH
LD_LIBRARY_PATH=/opt/gnome/lib:/usr/local/bin
export LD_LIBRARY_PATH
#PATH=$PATH:/opt/OV/bin/:/opt/OV/bin/OpC

# setup odb-oracle need environment
export MANPATH=$MANPATH:/opt/OV/man
export
PATH=$PATH:/opt/OV/bin:/opt/OV/bin/OpC:/opt/OV/bin/OpC/insta ll:/usr/local/bin:/usr/ccs/bi

n:/usr/bin:/opt/oracle/product/9.2.0/bin:/opt/java1.4/bin:/u sr/bin:/bin:/usr/sbin:/usr/ccs/bin:/

sbin:/usr/local:/usr/local/perl5/bin
export ORACLE_USERID=ipnms/ipadmin@openview
ODBCINI=/opt/odbc/odbc.ini
export ODBCINI
ORACLE_BASE=/opt/oracle
export ORACLE_BASE
ORACLE_HOME=/opt/oracle/product/9.2.0
export ORACLE_HOME
ORACLE_SID=openview
export ORACLE_SID
ORACLE_TERM=hp
export ORACLE_TERM
NLS_LANG=american_america.WE8ISO8859P15
export NLS_LANG
LD_LIBRARY_PATH=/opt/oracle/product/9.2.0/lib:/opt/oracle/pr oduct/9.2.0/lib32

export LD_LIBRARY_PATH
SHLIB_PATH=/opt/gnome/lib:/opt/oracle/product/9.2.0/lib32:/o pt/odbc/lib:/usr/lib:/opt/mqm/lib:/l

ib:/usr/local/lib:/bea/tuxedo8.1/lib:/opt/oracle/product/9.2 .0/lib:/opt/OV/lib:/opt/oracle/produ

ct/9.2.0/rdbms/lib:/opt/oracle/product/9.2.0/rdbms/lib32
export SHLIB_PATH

____________________________________________________________ _____
???????? MSN Explorer: http://explorer.msn.com/lccn/


----- End forwarded message -----