Thanks Mac,
I did find 'oraenv' files in two directories:
/home/oracle/app/oracle/product/8.0.3
/home/oracle
Initially I tried for /home/oracle now I tried for
/home/oracle/app/oracle/product/8.0.3
Sqlplus works from this directory also! But now I got the different error while 'make
test'.
Also I found an symbolic reerence in /home/oracle/app/oracle/product/8.0.3/lib
directory
lrwxrwxrwx 1 oracle 800 16 Oct 11 2000 libclntsh.so -> libclntsh.so.1.0
Error goes like this...
-----------------------------------------
# make test
PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib
-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
-I/home/iw-home/iw-perl/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base..............ok
t/general...........DBI->connect() failed: ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment.
SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/general.t
line 20
Unable to connect to Oracle (ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment.
SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skiped.
skipping test on this platform
t/long..............Unable to connect to Oracle (ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment.
SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skiped.
skipping test on this platform
t/plsql.............Unable to connect to Oracle (ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment.
SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin))
Tests skiped.
skipping test on this platform
t/reauth............skipping test on this platform
All tests successful, 4 tests skipped.
Files=5, Tests=5, 2 wallclock secs ( 1.05 cusr + 0.19 csys = 1.24 CPU)
PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib
-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris
-I/home/iw-home/iw-perl/lib/perl5/5.00503 test.pl
Oraperl test application $Revision: 1.2 $
Oraperl emulation interface version 1.39
DBD::Oracle 1.06 using OCI8 by Tim Bunce
DBI 1.15 by Tim Bunce
Data sources:
dbi:Oracle:CSPET101.WORLD
dbi:Oracle:DEV
dbi:Oracle:mts
dbi:Oracle:pandg1
dbi:Oracle:pandg2
dbi:Oracle:pandg2_new
dbi:Oracle:pgdb
dbi:Oracle:pgprod
dbi:Oracle:staging
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='CSPET101.WORLD', TWO_TASK='')
ora_login: 1034: ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment.
SVR4 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 code 255
make: Fatal error: Command failed for target `test_dynamic'
-----------------------------------------
> From: "Michael A. Chase" <[EMAIL PROTECTED]>
> Date: 2001/04/18 Wed AM 11:45:27 EDT
> To: "Prasanna Gopalakrishna" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> Subject: Re: Re: Error in DBD::Oracle Installation
>
> In UNIX, there should be a script called 'oraenv' you can source to set the
> necessary variables.
>
> In WinXx, the Oracle installer puts ORACLE_HOME directory names in the
> registry. Often software will work better if the environment variable
> ORACLE_HOME is set to the same directory.
>
> Note that the home directory of the OS user "oracle" is not the same thing
> as the directory pointed to by ORACLE_HOME.
> --
> Mac :})
> ** I normally forward private database questions to the DBI mail lists. **
> Give a hobbit a fish and he'll eat fish for a day.
> Give a hobbit a ring and he'll eat fish for an age.
> ----- Original Message -----
> From: "Prasanna Gopalakrishna" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, April 18, 2001 8:07 AM
> Subject: Re: Re: Error in DBD::Oracle Installation
>
>
> > * How do I find the home directory of the "oracle" user
> > * Oracle client installed and I connecting remotely to database using
> sqlplus
> > * is there any db driver mismatch
>
>
>
