DBD-Oracle Problems.

[Patrick Ware_1]

I am having some DBD problmes and need some help. I compiled DBD-Oracle-1.15, and was going through the make test, and the following errors occured:

# make test
make -f Makefile.aperl perl
`perl' is up to date.
PERL_DL_NONLAZY=1 ./perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base.......ok
t/cursor.....Unable to connect to Oracle as perltest/perltest (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/general....DBI connect('','perltest/perltest',...) 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/general.t line 21
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/long.......DBI connect('','perltest/perltest',...) 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/long.t line 22
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/meta.......Unable to connect to Oracle as perltest/perltest (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/ph_type....DBI connect('','perltest/perltest',...) 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/ph_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/plsql......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/reauth.....skipped
all skipped: no reason given
t/select.....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
All tests successful, 8 tests skipped.
Files=9, Tests=5, 5 wallclock secs ( 2.74 cusr + 0.68 csys = 3.42 CPU)
PERL_DL_NONLAZY=1 ./perl "-Iblib/lib" "-Iblib/arch" test.pl
Oraperl test application $Revision: 1.8 $


Extra tests. These are less formal and you need to read the output
to see if it looks reasonable and matches what the tests says is expected.

Oraperl emulation interface version 1.44
DBD::Oracle 1.15 using OCI8 by Tim Bunce
DBI 1.46 by Tim Bunce

Data sources:
dbi:Oracle:EXTPROC_CONNECTION_DATA.ENTP.ATTWS.COM
dbi:Oracle:medciber


Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as 'perltest/perltest' (via ORACLE_USERID env var or default - recommend name/passwd@dbname)
(ORACLE_SID='medciber', TWO_TASK='')
DBI connect('','perltest/perltest',...) 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 /tmp/DBD-Oracle-1.15/blib/lib/Oraperl.pm line 97
ora_login: 1034: 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)

ORACLE_SID or TWO_TASK possibly not right, or server not running.

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.
*** Error exit code 255

Stop.


Since the make was good, I went ahead with the make install anyhow.

/tmp/DBD-Oracle-1.15
# perl test.pl
Oraperl test application $Revision: 1.8 $
install_driver(Oracle) failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: /tmp/DBD-Oracle-1.15/blib/arch /tmp/DBD-Oracle-1.15/blib/lib /opt/perl-5.8.6/lib/5.8.6/PA-RISC2.0-thread-multi-LP64 /opt/perl-5.8.6/lib/5.8.6 /opt/perl-5.8.6/lib/site_perl/5.8.6/PA-RISC2.0-thread-multi-LP64 /opt/perl-5.8.6/lib/site_perl/5.8.6 /opt/perl-5.8.6/lib/site_perl .) at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully installed
at /tmp/DBD-Oracle-1.15/blib/lib/Oraperl.pm line 58
Compilation failed in require at (eval 2) line 1.
BEGIN failed--compilation aborted at (eval 2) line 1.

[TwoProc]

Patrick,
"Shared memory Realm" does not exist - means that Oracle is not up. Bring up your database,
set your ORACLE_HOME and your ORACLE_SID in the environment that's trying to connect to Oracle.

[Scott Tinsley]

Yea, there are several env. variables that should be set ahead of running the test cycle as pointed out the earlier post. Beside ORACLE_HOME and ORACLE_SID, I think there are also variables for user and passwords used to make the DB connection

[Patrick Ware_1]

All those environment variables were set, but for some reason the database was not recognized.

[TwoProc]

Did you install this tool into the SAME Oracle_HOME as the database ??? Or, is the tool installed on a remotely connected system.

This info would help me tell what your problem is.

I'm wondering if you're on a remote system and trying to use the Bequeath protocol when you should be using TCP. I'm also wondering if you set the TWO_TASK variable. Can you run "tnsping " to make a sqlnet connection?