Try adding these lines to your httpd.conf:
SetEnv ORACLE_HOME /your/oracle/home
SetEnv TNS_ADMIN /your/oracle/home/network/admin
If you don't have access/priviledges to httpd.conf, you can, I believe set
these in a BEGIN block within your script.
jeff
*******************************
Jeff Seger
Data Warehouse Engineer
Fairchild Semiconductor
[EMAIL PROTECTED]
*******************************
Barbara
Lindsey To: [EMAIL PROTECTED]
<blindsey@ufl. cc:
edu> Subject: Linux/perl/Oracle connect
question
Sent by:
[EMAIL PROTECTED]
fl.edu
05/01/2002
04:04 PM
Perl 5.00503 (site_perl 5.005)
Linux 2.2.14
Oracle 7.4.3
Apache, but not mod_perl
DBI.pm v.1.13
I am getting an error at my DBI->connect statement.
The original error in the log was 'DBI->connect failed: ORA-12154:
TNS:could not resolve service na...'
Then I tried adding DBI->connect_test_perf prior to the connect
statement.
It prints:
DBI:Oracle:DBNAME: testing 5 sets of 1 connections: Connecting... 1
and then the error logged is 'ORA-06401: NETCMN: invalid driver
designator...'
I also added DBI->available_drivers()
and that gives me:
ADO, ExampleP, Oracle, Proxy
The part I cannot figure out is that in the log, it says:
DBI::connect_test_perf('DBI', 'DBI:Oracle:DBNAME', 'DBNAMESCHEMA',
'PASSWD', 'HASH(0x837f440)')
However, in my actual call to the connect_test_perf, I am using:
DBI->connect_test_perf('DBI:Oracle:DBNAME', 'DBNAMESCHEMA',
'PASSWD',\%attr);
For some reason it is inserting the extra 'DBI' at the beginning of the
parameter list.
I tried checking the environments being keyed with the DBI.pm module
from my program, but the only one
I found to be set from my program level is:
$ENV{GATEWAY_INTERFACE} which is set to CGI/1.1
Any suggestions for tracking down the problem would be greatly
appreciated.
Barb
--
Barbara E. Lindsey,
Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162
"The road goes ever on and on. "
- Bilbo Baggins
