gcc64 error when compiling DBI

[Patrick Ware_1]

Hello,

I used the following command to attempt a Bundle::DBI install:

/opt/perl64/bin/perl -MCPAN -e "install Bundle::DBI"

After getting thru the questions, and prompts, the problem starts below:

gcc64 -c -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.46\" -DXS_VERSION=\"1.46\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DDBI_NO_THREADS Perl.c
sh: gcc64: not found.
*** Error exit code 127

Stop.
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
make had returned bad status, install seems impossible Running install for module DBI::Shell Running make for T/TL/TLOWERY/DBI-Shell-11.93.tar.gz
Fetching with LWP:

I am running procura's pre-built perl-5.8.5-gcc-3.4.0-11.11-elf64
Do I need a 64-bit version of gcc to make this work, and how do I recover properly from this error. This is my 1st attempt EVER at installing perl modules. Thanks for your help to a new Sys Admin.

[H.Merijn Brand (procura]

Ahhhhhrg. Don't do that. Why should you?!
DBI is already bundled in my perl's

# /opt/perl64/bin -MV=DBI

And for the gcc error, asuming you use my gcc, make sure /usr/local/pa20_64/bin is in your $PATH

# cd /usr/local/pa20_64/bin
# ln -s gcc gcc64

if that link does not exist yet

Enjoy, Have FUN! H.Merijn

[H.Merijn Brand (procura · Accepted solution]

And for your second question, yes, you need gcc/64 for extending perl with XS modules (modules that use C code and need to be compiled)

Enjoy, Have FUN! H.Merijn

[Patrick Ware_1]

Thanks! So basically, I should be ready to install the oracle module?

[H.Merijn Brand (procura]

Yes

# cd /work
# wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.16.tar.gz
# gzip2 -d # cd DBD-Oracle-1.16
# /opt/perl64/bin/perl Makefile.PL
# make
# make test
# make install

And DBD-Oracle-1.16 is also an XS modules, so you need to install gcc/64 first

# cd /tmp
# wget http://mirrors.develooper.com/hpux/gcc-3.4.3-64-11.11-elf64.tbz
# cd /opt
# bzip2 -d # perl -pi -e's,$,:/opt/perl64/bin:/usr/local/pa20_64/bin,' /etc/PATH

Enjoy, Have FUN! H.Merijn

[Patrick Ware_1]

Thanks! The wget http://mirrors.develooper.com/hpux/gcc-3.4.3-64-11.11-elf64.tbz
keeps timing out. Any other options I could try? I just installed wget tonight. I had to install openssl to get wget to work.

[Patrick Ware_1]

Ok, I thought outside the box and opened a netscape window on my VNC session, and got the file that way.

[Patrick Ware_1]

Ok, so here's the next problem:
# /opt/perl64/bin/perl Makefile.PL
Using DBI 1.43 (for perl 5.008005 on PA-RISC2.0-LP64) installed in /opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI

Configuring DBD::Oracle ...

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

The ORACLE_HOME environment variable must be set.
It must be set to hold the path to an Oracle installation directory
on this machine (or a machine with a compatible architecture).
See the README.clients file for more information.
ABORTED!

I thought I'd put this one out here while I do some research. If I'm lucky, I will beat you with the answer..LOL!!

[Patrick Ware_1]

Found my answer in the README.hpux file:

It is critical to setup your Oracle environmental variables. Many people
do this incorrectly and spend days trying to get a working version of
DBD-Oracle. Below are examples of a local database and a remote database
(i.e. the database is on a different machine than your Perl/DBI/DBD
installation) environmental variable setup.

Example (local database):

export ORACLE_USERID=
export ORACLE_HOME=
export ORACLE_SID=
export SHLIB_PATH=$ORACLE_HOME/lib #for 32bit HP
export LD_LIBRARY_PATH=$ORACLE_HOME/lib #for 64bit HP (I defined them both)

Example ( if remote database):

export ORACLE_USERID=
export ORACLE_HOME=
export ORACLE_SID=@
export SHLIB_PATH=$ORACLE_HOME/lib #for 32bit HP
export LD_LIBRARY_PATH=$ORACLE_HOME/lib #for 64bit HP (I defined them both)

[H.Merijn Brand (procura]

I was on the road, so you did get yourself another hour to solve things and it worked out.

If there are *any* parts in the README's or things you missed, please let me know. I can have them added

Enjoy, Have FUN! H.Merijn

[Patrick Ware_1]

Ok, I was able to get the make file created. When I ran the make test, 3 tests failed:

/tmp/DBD-Oracle-1.16
medct1# make test
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
/opt/perl64/bin/perl -p -e "s/~DRIVER~/Oracle/g" /opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI/Driver.xst > Oracle.xsi
/opt/perl64/bin/perl /opt/perl64/lib/5.8.5/ExtUtils/xsubpp -typemap /opt/perl64/lib/5.8.5/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc64 -c -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/plsql/public -I/apps/oracle/product/8.1.7/network/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" Oracle.c
gcc64 -c -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/plsql/public -I/apps/oracle/product/8.1.7/network/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:385: warning: unused variable `rsize'
gcc64 -c -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/plsql/public -I/apps/oracle/product/8.1.7/network/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" oci8.c
oci8.c: In function `ora_blob_read_mb_piece':
oci8.c:695: warning: comparison is always false due to limited range of data type
oci8.c: In function `ora_describe':
oci8.c:1088: warning: comparison is always false due to limited range of data type
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
/usr/bin/ld +b "/apps/oracle/product/8.1.7/lib64:/apps/oracle/product/8.1.7/rdbms/lib64" -b -L/usr/local/pa20_64/lib -L/lib/pa20_64 Oracle.o dbdimp.o oci8.o +s +n -L/apps/oracle/product/8.1.7/lib64/ -L/apps/oracle/product/8.1.7/rdbms/lib64/ /apps/oracle/product/8.1.7/rdbms/lib64/kpudfo.o /apps/oracle/product/8.1.7/lib64/nautab.o /apps/oracle/product/8.1.7/lib64/naeet.o /apps/oracle/product/8.1.7/lib64/naect.o /apps/oracle/product/8.1.7/lib64/naedhs.o -lclntsh /apps/oracle/product/8.1.7/rdbms/lib64/kpuadef.o `sed -e 's/-ljava//g' /apps/oracle/product/8.1.7/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /apps/oracle/product/8.1.7/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /apps/oracle/product/8.1.7/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /apps/oracle/product/8.1.7/lib64/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 -lm -lpls8 -lsql8 -o blib/arch/auto/DBD/Oracle/Oracle.sl
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/opt/perl64/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/opt/perl64/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
PERL_DL_NONLAZY=1 /opt/perl64/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/10general.t line 12
Undefined subroutine &main::BAILOUT called at t/10general.t line 15.
# Looks like your test died before it could output anything.
t/10general.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-31
Failed 31/31 tests, 0.00% okay
t/15nls.................DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/15nls.t line 15
t/15nls.................ok
9/9 skipped: Unable to connect to Oracle (ORA-01034: ORACLE not available
t/20select..............Unable to connect to Oracle (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skiped.
skipped
all skipped: no reason given
t/21nchar...............DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/nchar_test_lib.pl line 148
skipped
all skipped: Not connected to oracle
t/22nchar_al32utf8......skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/22nchar_utf8..........skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db.............skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db_8bit........skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db_al32utf8....skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/24implicit_utf8.......skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/25plsql...............Unable to connect to Oracle (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skiped.
skipped
all skipped: no reason given
t/30long................DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/nchar_test_lib.pl line 148
Can't connect to database: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)
# Looks like your test died before it could output anything.
t/30long................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-376
Failed 376/376 tests, 0.00% okay
t/31lob.................DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/nchar_test_lib.pl line 148
You tried to plan twice! Second plan at t/31lob.t line 16
# Looks like your test died before it could output anything.
t/31lob.................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-2
Failed 2/2 tests, 0.00% okay
t/40ph_type.............DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/40ph_type.t line 26
Unable to connect to Oracle (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
t/50cursor..............Unable to connect to Oracle as scott/tiger (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................Unable to connect to Oracle as scott/tiger (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
Failed Test Stat Wstat Total Fail Failed List of Failed
---------------------------------------------------------------------------------------------------------------------------
t/10general.t 255 65280 31 62 200.00% 1-31
t/30long.t 255 65280 376 752 200.00% 1-376
t/31lob.t 255 65280 2 4 200.00% 1-2
13 tests and 9 subtests skipped.
Failed 3/18 test scripts, 83.33% okay. 409/423 subtests failed, 3.31% okay.
*** Error exit code 2

Stop.

Any input?

[Patrick Ware_1]

Ok, I was able to get the make file created. When I ran the make test, 3 tests failed:

/tmp/DBD-Oracle-1.16
# make test
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
/opt/perl64/bin/perl -p -e "s/~DRIVER~/Oracle/g" /opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI/Driver.xst > Oracle.xsi
/opt/perl64/bin/perl /opt/perl64/lib/5.8.5/ExtUtils/xsubpp -typemap /opt/perl64/lib/5.8.5/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc64 -c -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/plsql/public -I/apps/oracle/product/8.1.7/network/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" Oracle.c
gcc64 -c -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/plsql/public -I/apps/oracle/product/8.1.7/network/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:385: warning: unused variable `rsize'
gcc64 -c -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/plsql/public -I/apps/oracle/product/8.1.7/network/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/apps/oracle/product/8.1.7/rdbms/public -I/apps/oracle/product/8.1.7/rdbms/demo -I/opt/perl64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBI -mpa-risc-2-0 -D_HPUX_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/pa20_64/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC "-I/opt/perl64/lib/5.8.5/PA-RISC2.0-LP64/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" oci8.c
oci8.c: In function `ora_blob_read_mb_piece':
oci8.c:695: warning: comparison is always false due to limited range of data type
oci8.c: In function `ora_describe':
oci8.c:1088: warning: comparison is always false due to limited range of data type
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
/usr/bin/ld +b "/apps/oracle/product/8.1.7/lib64:/apps/oracle/product/8.1.7/rdbms/lib64" -b -L/usr/local/pa20_64/lib -L/lib/pa20_64 Oracle.o dbdimp.o oci8.o +s +n -L/apps/oracle/product/8.1.7/lib64/ -L/apps/oracle/product/8.1.7/rdbms/lib64/ /apps/oracle/product/8.1.7/rdbms/lib64/kpudfo.o /apps/oracle/product/8.1.7/lib64/nautab.o /apps/oracle/product/8.1.7/lib64/naeet.o /apps/oracle/product/8.1.7/lib64/naect.o /apps/oracle/product/8.1.7/lib64/naedhs.o -lclntsh /apps/oracle/product/8.1.7/rdbms/lib64/kpuadef.o `sed -e 's/-ljava//g' /apps/oracle/product/8.1.7/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /apps/oracle/product/8.1.7/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /apps/oracle/product/8.1.7/lib64/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g' /apps/oracle/product/8.1.7/lib64/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 -lm -lpls8 -lsql8 -o blib/arch/auto/DBD/Oracle/Oracle.sl
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/opt/perl64/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/opt/perl64/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
PERL_DL_NONLAZY=1 /opt/perl64/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/10general.t line 12
Undefined subroutine &main::BAILOUT called at t/10general.t line 15.
# Looks like your test died before it could output anything.
t/10general.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-31
Failed 31/31 tests, 0.00% okay
t/15nls.................DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/15nls.t line 15
t/15nls.................ok
9/9 skipped: Unable to connect to Oracle (ORA-01034: ORACLE not available
t/20select..............Unable to connect to Oracle (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skiped.
skipped
all skipped: no reason given
t/21nchar...............DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/nchar_test_lib.pl line 148
skipped
all skipped: Not connected to oracle
t/22nchar_al32utf8......skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/22nchar_utf8..........skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db.............skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db_8bit........skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db_al32utf8....skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/24implicit_utf8.......skipped
all skipped: Oracle charset tests unreliable for Oracle 8 client
t/25plsql...............Unable to connect to Oracle (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skiped.
skipped
all skipped: no reason given
t/30long................DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/nchar_test_lib.pl line 148
Can't connect to database: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)
# Looks like your test died before it could output anything.
t/30long................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-376
Failed 376/376 tests, 0.00% okay
t/31lob.................DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/nchar_test_lib.pl line 148
You tried to plan twice! Second plan at t/31lob.t line 16
# Looks like your test died before it could output anything.
t/31lob.................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-2
Failed 2/2 tests, 0.00% okay
t/40ph_type.............DBI connect('','scott/tiger',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/40ph_type.t line 26
Unable to connect to Oracle (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
t/50cursor..............Unable to connect to Oracle as scott/tiger (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................Unable to connect to Oracle as scott/tiger (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skipped.
skipped
all skipped: no reason given
Failed Test Stat Wstat Total Fail Failed List of Failed
---------------------------------------------------------------------------------------------------------------------------
t/10general.t 255 65280 31 62 200.00% 1-31
t/30long.t 255 65280 376 752 200.00% 1-376
t/31lob.t 255 65280 2 4 200.00% 1-2
13 tests and 9 subtests skipped.
Failed 3/18 test scripts, 83.33% okay. 409/423 subtests failed, 3.31% okay.
*** Error exit code 2

Stop.

Any input?

[Patrick Ware_1]

Ok,
I need a a moderator to delete the post before my previous one, as it is a duplicate, and has a system name in it.

[H.Merijn Brand (procura]

That message suggests that the database is down.

Are you sure you can access it?
And scott/tiger is the default user/pass, so you either set the $ORACLE_USERID wrong, or the database is down

Enjoy, Have FUN! H.Merijn

[Patrick Ware_1]

Yeah, I deduced as much. The person I am doing this for hasn't given me the right variable for ORACLE_USERID. :( I'll see if I can get it from him.