Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem connecting to orcl with Perl DBD:Oracle

588551Aug 12 2007 — edited Aug 14 2007
Hi all,
I'm new to perl and oracle.
I have Oracle 10g R2 installed (not XE) on Win XP. I also installed Perl 5.6.1 from AS. Then downloaded DBI and DBD:Oracle and installed them using PPM. Now, I want to test dbd:oracle. I used to following (that I got from some source online):

$ORACLE_SID = "orcl";
$ORACLE_USERID = "system";
$ORACLE_PASSWORD = "...."; (the actual password will be here)

$ENV{'ORACLE_SID'} = "$ORACLE_SID";
$ENV{'ORACLE_HOME'} = "c:\\oracle";
....
....
....
local ($oracle_sid, $username, $password) = @_;
local ($temp_dbh);
local($tempID, $tempPassword, $tempKey);

print " (*) Attempting Oracle Login ...\n";


unless ( $temp_dbh = DBI->connect("dbi:Oracle:$oracle_sid", "$username", $password, {AutoCommit => 0}) ) {
&programError("Oracle Login Failed as $username", "", "$DBI::errstr", "dba-mail", "dba-pager");
exit;
}

print " OK\n\n";

The output I got is:
Oracle login failed
ORA-01017: invalid username/password; logon denied <DBD: login failed>
The system cannot find the path specified.
The system cannot find the path specified.

First when I got this error there was no Oracle_HOME as an environment variable. I added that to C:\Oracle and rebooted the system. Also, the Perl that came with Oracle 10g R2 was 5.8.3. So, I renamed that folder (in Oracle home) from perl to perl1. After doing these changes too I got the same error.
Can somebody please throw some light on this and tell me what I have to do ?

Thanks a lot
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2007
Added on Aug 12 2007
3 comments
695 views