Hello,
I'm really desperate for a solution to this problem so I'll be eternally
grateful to anyone who can help me.
My setup is as follows:
perl 5.6.1, DBD and DBI using Oracle 9i and connecting to a 9i database
I cannot connect as the 'sys' user
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
I get the following error:
DBI->connect(planet6d) failed: ORA-01031: insufficient privileges (DBD
ERROR:(OCISessionBegin) at DB_ASSIST line 458
I'd be really grateful for any advice or to anybody who can suggest a reason
as to why I cannot connect.
Thanks,
Tony
