You don't need to connect as sysdba/internal for that. Try in sqlplus:

        ALTER USER your_user_name  DEFAULT ROLE DBA

and then try the perl script again. Could be your user has the right to be
DBA but has set that active. (if that makes sense, gotta run to a meeting,
sorry)

-----------------------------------
Frans Postma, (050-58) 81 852
ATOS Origin, Unix Support 
     "If at first you don't succeed, skydiving isn't for you"




> -----Oorspronkelijk bericht-----
> Van: Markham, Richard [mailto:[EMAIL PROTECTED]]
> Verzonden: dinsdag 18 februari 2003 20:48
> Aan: '[EMAIL PROTECTED]'
> Onderwerp: ora_session_mode
> 
> 
> I'm getting DBD::Oracle::st execute failed: ORA-01031: insufficient
> privileges (DBD: oexec error).
> I'm trying to send alter system kill session for example and 
> I'm using mode
> 2 during initial
> connection. I've verified that the user can connect as sysdba 
> from the OS as
> well as from a client
> pc in TOAD. The user is connecting but I don't believe its 
> making it in as
> sysdba.
> 
> Perl 5.6.1 Oracle 8.1.7.3
> 
> TIA
> 

Reply via email to