Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
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 meditating upon the Monastery: (5)
As of 2014-08-23 08:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (172 votes), past polls