Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Perl Oracle Connectivity problem
Hi,
Environment are as follows
I am using
1)Installed activeperl in windows 2000. 2)Oracle database in the solaris server 192.168.128.58 3)Installed Net8 in my system (windows 2000) & configured to oracleserver as service name "hpdb"
I set the environment variable TWO_TASK as (T:192.168.128.58:hpdb) in windows 2000.
I am able to connect using sqlplus <mailto:system/manager_at_hpdb>
system/manager_at_hpdb
< <mailto:system/manager_at_hpdb> mailto:system/manager_at_hpdb>
Here is my code for connecting to oracle.
#!perl
use CGI;
use DBI;
use DBD::Oracle;
BEGIN {
$ENV{ORACLE_HOME} = 'C:/ORACLE/ORA81';
$ENV{TWO_TASK} = 'T:192.168.128.58:hpdb';
}
print "content-type: text/html\n\n";
my $dbh=DBI->connect("dbi:Oracle:hpdb", "system", "manager"); unless (defined $dbh) {
print "Cannot connect to server: $DBI::errstr\n"; die;
I am getting "Cannot connect to server: ORA-12640: Authentication adapter initialization failed (DBD: login failed) "
What is the possible solution to resolve this issue? Where is the exact problem lies?
Thanks in advance.
With regards,
Priya
Received on Tue Dec 11 2001 - 20:47:30 CST
![]() |
![]() |