connect as sysdba

Hi,
I am unable to connect to the database as sysdba using DBI, however I
am able to when I use sqlplus.

Here are my results:
sqlplus abc/xyz -----> OK
using DBI abc/xyz -----> OK
sqlplus 'abc/xyz as sysdba' -----> OK
using DBI abc/xyz with ora_session_mode => ORA_SYSDBA -----> Not
connecting

All the above four scenarios are executed as the same unix user, and
that user belongs to the dba group.

I am using DBI and DBD::Oracle qw(:ora_session_mode)
and am also setting ORACLE_SID before connecting.

The error I am getting is:
Error returned:ORA-01031: insufficient privileges (DBD ERROR:
OCISessionBegin)

Went through this previous thread
http://groups.google.com/group/perl.dbi.users/browse_frm/thread/cf65d6f6b7ada22d/e155fb6cbc6bb49d?hl=en&lr=&ie=UTF-8&oe=UTF-8&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D023301c32b45%25244eabb700%25248403010a%2540afd.dir.muenchen.de#e155fb6cbc6bb49d
but it is not working for me.

Any help is really appreciated.

Thanks,
Ani

.

Relevant Pages

  • Re: connect as sysdba
    ... Add the following entry in $ORACLE_HOME/dbs/initSID.ora ... I am unable to connect to the database as sysdba using DBI, ... All the above four scenarios are executed as the same unix user, ... and am also setting ORACLE_SID before connecting. ...
    (perl.dbi.users)
  • Re: Using the DBI to connect to an Oracle server w/o connecting to a database
    ... DBI (and DBD::Oracle) to connect to an Oracle server without ... connecting to a database? ... x> /nolog turns sqlplus into something unusual and highly specific ...
    (comp.lang.perl.misc)
  • Re: HELP!! DBI Error!!
    ... I tired initially using ppm; but then it couldnt even connect ... When I tried ppm3, it connected and also listed the DBI I wanted. ... > connecting to a database. ...
    (perl.dbi.users)
  • Re: small dbi help
    ... > am repeatedly evoking sqlplus, ... > connecting to the database and can do SQL queries but how much will it ... Yes - use DBI and DBD::Oracle ... Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org ...
    (comp.lang.perl.misc)
  • Re: How to set a variable using ssh in a while loop?
    ... Which command are you getting the exit code from? ... I'm connecting to an appserver using ssh, then I run sqlplus on the ... Did you try printing $directly? ...
    (comp.unix.shell)