I've rebuilt perl, DBD, and DBI for use with an Oracle 9i database and all
seemed to be ok until I tried to connect to the database as user 'sys'
It won't allow me to connect because it requires the 'as sys dba' syntax.
So I searched the net and found the following info: ora_session_mode
attribute can be used to connect with SYSDBA authorization
$mode = 2; # SYSDBA
DBI->connect ($dsn, $user, $passwd, {ora_session_mode => $mode})
My current syntax is as follows:
my $dbh=DBI->connect("DBI:Oracle:$SID", "$UserName", "$Password",
{ora_session_mode => 2}) or die {&DBConnect};
where $Username = sys and $Password = sys_password
Now I get the following error:
DBI->connect(planet6d) failed: ORA-01031: insufficient privileges (DBD
ERROR:(OCISessionBegin) at DB_ASSIST line 458
Any help would be much appreciated
Thanks,
Tony
