I tried your proposition, then I tried the following:
my $dbh = DBI->connect(
'DBI:Oracle:host=myserver.rms.slb.com;sid=INDICATORS;port=1526',
'indic/xxx', '',
{ AutoCommit => 0, RaiseError => 0, PrintError => 1 } )
or die $DBI::errstr;
and now I get a new error:
DBI->connect failed
Jerome MOUREAUX <[EMAIL PROTECTED]> writes:
> David,
>
> The ORACLE_HOME is set in the httpd.conf with a PerlSetEnv directive.
> (it appears in the extract I sent). (I've checked that is OK in the scripts by
> printing out $ENV{ORACLE_HOME} )
> The SID is not case sensitive (I tried some combina
On Wed, 29 Mar 2000, Jerome MOUREAUX wrote:
> My scripts run well if I launch it from the command line.
Have you tried running them from the command line as the user who the
webserver runs as? There may be something in your user environment that
allows them to work which is not set up for this o
Write a small registry script to print %ENV and confirm ORACLE_HOME is set to
/disc1/sherpa/oracle.
In your shell,
# cat
A final effort... From the command line it works. Perhaps your ORACLE_USERID,
etc. is already set?
Within your Registry script, that's probably not the case unless you've
explicitly told it otherwise.
So let's change your DSN around a bit:
my $dbh = DBI->connect('dbi:Oracle:', 'indic/x
On Wed, 29 Mar 2000, Jerome MOUREAUX wrote:
> Alias /indicators2/perl "/disc1/sherpa_a/indicators2/perl"
[...]
> PerlSetEnv ORACLE_HOME /disc1/sherpa/oracle
Do you really have a /disc1/sherpa directory and a /disc1/sherpa_a
directory?
- Perrin
My mistake, Jerome.
PerlSetVar != PerlSetEnv
I read that as PerlSetVar. Sorry to confuse the issue.
I hope it's a simple permissions problem.
Good luck!
David S . Kenzik said...
> Jerome MOUREAUX said...
>
> > David,
> >
> > The ORACLE_HOME is set in the httpd.conf with a Perl
Jerome MOUREAUX said...
> David,
>
> The ORACLE_HOME is set in the httpd.conf with a PerlSetEnv directive.
> (it appears in the extract I sent). (I've checked that is OK in the scripts by
> printing out $ENV{ORACLE_HOME} )
Well I can pretty much guarantee you that the ORACLE_HOME environ
David,
The ORACLE_HOME is set in the httpd.conf with a PerlSetEnv directive.
(it appears in the extract I sent). (I've checked that is OK in the scripts by
printing out $ENV{ORACLE_HOME} )
The SID is not case sensitive (I tried some combination when I was trying to
figure out what happen) otherwi
Thanks Jeffrey but:
- the tnsname.ora is OK as tnsping works fine as well as the same script run
from the command line.
- the case is only important for Oracle in the string dbi:Oracle:SID
(the line in startup.pl in commented it was just a previous try)
I'm really running out of idea about th
The ORACLE_HOME ___environment___ variable is set where? I see no indication
of it being set in any of your examples or config.
I do see PerlSetVar setting it-- don't confuse that with the environment!
PerlSetVar is a specific way to set variables so mod_perl can read them via
the dir_config() me
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
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
13 matches
Mail list logo