Re: Connecting 'as sysdba' using DBD::Oracle

I have never used DBD::Oracle myself and I'm just an Oracle novice so this may be completely worthless, but did you actually use

my $dbh = DBI->connect($dsn, "", "", { ora_session_mode => ORA_SYSDBA 
+});
[download]

or did you just remove the username before posting? Try using the username "system" like so:

my $dbh = DBI->connect($dsn, "system", $sysdba_password, { ora_session
+_mode => ORA_SYSDBA });
[download]

with the proper $sysdba_password ofcourse.

-- Time flies when you don't know what you're doing

Comment on Re: Connecting 'as sysdba' using DBD::Oracle Select or Download Code

Replies are listed 'Best First'.
Re^2: Connecting 'as sysdba' using DBD::Oracle by laminee (Novice) on Aug 05, 2009 at 11:27 UTC
According to the DBD::Oracle documentation the username and password are supposed to be blank. Also the username and password should be empty, and the user executing the script needs to be part of the dba group or osdba group. Which according to me seems correct as while connecting `sqlplus '/as sysdba'` we do not provide any username/password.	[reply] [d/l]
Re^3: Connecting 'as sysdba' using DBD::Oracle by FloydATC (Deacon) on Aug 05, 2009 at 11:36 UTC
OK, timtowtdi I guess :-) `$ sqlplus SQL*Plus: Release 9.2.0.6.0 - Production on Wed Aug 5 13:29:01 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name: system as sysdba Enter password: Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production SQL>` [download] -- Time flies when you don't know what you're doing	[reply] [d/l]