Prasanna,
The error messages :
ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment.
SVR4 Error: 2: No such file or directory
Usually mean that either your database isn't started or your ORACLE_HOME or ORACLE_SID
environment variable is not set correctly.
Also: if you are still using Oracle 8.0.3, I strongly advise to upgrade to at least
8.0.6, and better to 8.1.7. 8.0.3 is since long desupported. The upgrade is free if
you have a valid support contract.
Hope this helps,
Mark
Prasanna Gopalakrishna wrote:
> 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
> >
> >
> >
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
EMEA Support Information Systems Email : [EMAIL PROTECTED]
AIM : markvdb
