Re: connect as sysdba

Hi All,

Resolved the problem by following the steps:

1. Create a password file under $ORACLE_HOME/dbs like:
orapwd file=$ORACLE_HOME/dbs/orapwSID password=change_on_install
entries=5
2. Add the following entry in $ORACLE_HOME/dbs/initSID.ora
remote_login_passwordfile = exclusive
3. Restart the database

Ani

On Feb 20, 2:11 pm, "Ani" <call.anir...@xxxxxxxxx> wrote:
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 threadhttp://groups.google.com/group/perl.dbi.users/browse_frm/thread/cf65d...
but it is not working for me.

Any help is really appreciated.

Thanks,
Ani


.

Relevant Pages

  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.externaldata)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.dataaccess.pages)
  • RE: Problem with connecting to an Oracle database using Perl
    ... Problem with connecting to an Oracle database using Perl ... *IS* described in the DBD::Oracle perldocs - as the perldocs are included ... I do not have a problem connecting to the remote database using the Oracle ...
    (perl.dbi.users)
  • Re: Running SQL script through VB
    ... I am connecting through a default username and my ... The error I am getting while running a script (generated by SQL server ... "A use database statement is not allowed in a procedure or trigger" ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Compact Framework 2.0 to Sql Server 2000 -- cant Open() connectio
    ... I tried connecting to a different data source on another machine: ... datasource, again using a \IERP to get to the correct database, and it failed. ... > I have XP SP 2 on the machine w/ the sql server, ...
    (microsoft.public.dotnet.framework.compactframework)