Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

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

by tweetiepooh (Friar)
on Aug 05, 2009 at 11:08 UTC ( #786054=note: print w/ replies, xml ) Need Help??


in reply to Connecting 'as sysdba' using DBD::Oracle

Try

$dsn = "dbi:Oracle:ABCD12";
and make sure that sqlnet.ora has
NAMES.DEFAULT_DOMAIN = COMPANYDOMAIN.COM


Comment on Re: Connecting 'as sysdba' using DBD::Oracle
Select or Download Code
Re^2: Connecting 'as sysdba' using DBD::Oracle
by laminee (Novice) on Aug 05, 2009 at 11:38 UTC
    With
    $dsn = "dbi:Oracle:DS8CC2";
    or
    $dsn = "dbi:Oracle:DS8CC2.ORACLEOUTSOURCING.COM";
    the error becomes
    DBI connect('DS8CC2','',...) failed: ORA-01031: insufficient privilege +s (DBD ERROR: OCISessionBegin)
    and
    DBI connect('DS8CC2.ORACLEOUTSOURCING.COM','',...) failed: ORA-01031: +insufficient privileges (DBD ERROR: OCISessionBegin)
    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

      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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://786054]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (10)
As of 2014-10-20 21:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (92 votes), past polls