OK - I'm a dummy.
I was able to log in with SQLPlus, and when I figured out what I had to
do for that,
I found I was using the wrong service name in my perl script...
Thanks for your help.
[EMAIL PROTECTED] wrote:
>
> 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
--
Barbara E. Lindsey,
Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162
"The road goes ever on and on. "
- Bilbo Baggins
