Does anyone have ideas why we would get this error periodically after our
system has been running for about 20 minutes?
thanks,
-tom
[Wed Jan 10 16:22:45 2001] [error] DBI->connect(RSPD1) failed: ORA-12154:
TNS:could not resolve service name (DBD ERROR: OCIServerAttach) at
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI.pm line 411
DBI::connect('DBI', 'dbi:Oracle:RSPD1', 'username', 'password',
'HASH(0x192fb60)') called at /data/www/racesearch/htdocs/CGI/LIB/RSDBI.pm
line 323
RSDBI::connect('RSDBI') called at
/data/www/racesearch/htdocs/CGI/search_modules/SBPN.pm line 72
SBPN::main('SBPN', 'HASH(0x191d284)') called at
/data/www/racesearch/htdocs/CGImp/mhp line 132
Apache::ROOTwww_2eracesearch_2ecom::CGImp::mhp::mode_sbpn('HASH(0x191d284)')
called at /data/www/racesearch/htdocs/CGImp/mhp line 63
Apache::ROOTwww_2eracesearch_2ecom::CGImp::mhp::handler('Apache=SCALAR(0x237
cd74)') called at
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Apache/Registry.pm line
143
require 0 called at
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Apache/Registry.pm line
143
Apache::Registry::handler('Apache=SCALAR(0x237cd74)') called at
/dev/null line 0
require 0 called at /dev/null line 0
> Everything works fine for about 1/2 an hour and then we start getting the
> message below. We used to get an error that Oracle home was not found, so
we
> hard-coded it in and now we just get the message below.
was the ORACLE_HOME an error or just a warning? if your oratab is
set up properly it shouldn't need ORACLE_HOME once the instance is
found.
> Does anyone have any suggestions? If our code produces an oracle error,
does
> that corrupt the mod_perl process and therefore give any future users who
> connect to that particular process the error below?
>
> perl version 5.6.0
> Oracle 8.1.5
> mod_perl 1.21
> apache 1.3.12
i have a similar setup (5.6.0, 8.1.6, 1.21_1, 1.3.14) w/o any
problems IFF tnslsnr is set up properly and started. otherwise
there is chaos.
connecting via:
my @dbinfo =
qw(
dbi:Oracle:host=somehost;sid=foo
username
password
);
my $dbh = DBI->connect( @dbinfo ) or croak "Roadkill: $!";
the ORA-12154 gives me a freudian feeling that your tnslsnr is
not set up properly.
quick check:
. oraenv
lsnrctl;
> stop
> start
should tell you about stopping and starting properly. if it doesn't
then fix this before worrying about DBD::Oracle (or dump oracle for
a database that isn't living hell to set up).
note: i've just had to go through this in order to set up a demo
for one of our clients. i can haul my system in on monday and
we can go over the setup steps if anyone else is interested in this.
--
Steven Lembark 2930 W. Palmer St.
Chicago, IL 60647
[EMAIL PROTECTED] 800-762-1582