Re: ORA-12154: TNS:could not resolve service name with DBI under Apache

[Jeffrey W. Baker]

On Wed, 29 Mar 2000, Jerome MOUREAUX wrote:

> Hi All,
> 
> I experience a trouble with Perl script using DBI running under Mod_perl 
> and Registry
> If you have an idea from where the problem may come....
> 
> Here is the error :
> 
> DBI->connect failed: ORA-12154: TNS:could not resolve service name (DBD: 
> login f
> ailed) at /disc1/sherpa_a/indicators2/perl/activity/toto.pl line 5
> [Wed Mar 29 20:11:32 2000] [error] ORA-12154: TNS:could not resolve service 
> name
>   (DBD: login failed) at /disc1/sherpa_a/indicators2/perl/activity/toto.pl 
> line 5

> #Apache::DBI->connect_on_init("dbi:Oracle:indicators", "indic", "xxxx",
                                            ^^^^^^^^^^

> my $dbh = DBI->connect( 'DBI:Oracle:INDICATORS', 'indic', xxxx',
                                      ^^^^^^^^^^


Well, which is it?  indicators or INDICATORS?  Case may be important, use
the same case as the service name definition in tnsnames.ora.

-jwb