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

With

$dsn = "dbi:Oracle:DS8CC2";
[download]

$dsn = "dbi:Oracle:DS8CC2.ORACLEOUTSOURCING.COM";
[download]

the error becomes

DBI connect('DS8CC2','',...) failed: ORA-01031: insufficient privilege
+s (DBD ERROR: OCISessionBegin)
[download]

and

DBI connect('DS8CC2.ORACLEOUTSOURCING.COM','',...) failed: ORA-01031: 
+insufficient privileges (DBD ERROR: OCISessionBegin)
[download]

respectively.

But as I mentioned, there's no issue while connecting directly using sqlplus '/as sysdba' and $TNS_ADMIN/sqlnet.ora does have the entry:

NAMES.DEFAULT_DOMAIN = ORACLEOUTSOURCING.COM
[download]

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

Replies are listed 'Best First'.
Re^3: Connecting 'as sysdba' using DBD::Oracle by tweetiepooh (Hermit) on Aug 06, 2009 at 10:12 UTC
Your original post gave error 12545 which is often related to naming. Now you are getting permission errors. So getting closer since you are now reaching the database. Oracle docs indicate that error 1031 "insufficient privileges" is when you try to change username or password without appropriate privilege. As other have mentioned check you are in the correct groups to use the sysdba permission and that the user also is granted that in Oracle.	[reply]

Replies are listed 'Best First'.

Re^3: Connecting 'as sysdba' using DBD::Oracle
by tweetiepooh (Hermit) on Aug 06, 2009 at 10:12 UTC

Oracle docs indicate that error 1031 "insufficient privileges" is when you try to change username or password without appropriate privilege. As other have mentioned check you are in the correct groups to use the sysdba permission and that the user also is granted that in Oracle.

[reply]