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

Try

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

and make sure that sqlnet.ora has

NAMES.DEFAULT_DOMAIN = COMPANYDOMAIN.COM
[download]

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:38 UTC
With `$dsn = "dbi:Oracle:DS8CC2";` [download] or `$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]	[reply] [d/l] [select]
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]