Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Perl Oracle Connectivity problem

Perl Oracle Connectivity problem

From: Priya <priyan_at_karna.net>
Date: 11 Dec 2001 18:47:30 -0800
Message-ID: <aef23f1d.0112111847.22101839@posting.google.com>


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 oracle
 server 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US