Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
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
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";
    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 making s'mores by the fire in the courtyard of the Monastery: (6)
As of 2015-08-04 01:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The oldest computer book still on my shelves (or on my digital media) is ...













    Results (59 votes), past polls