We have a setup here where you cannot connect as sysdba via SQL*Net. Maybe that's your problem.
-----Original Message----- From: Baras, Gal [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 September 2003 7:44 AM To: 'Gold, Samuel (Contractor)' Cc: '[EMAIL PROTECTED]' Subject: RE: ORA-01031 when trying to connect as sysdba. sqlplus works Thanks for the quick response, but this was not the solution. In my subject line and body of message I mentioned that sqlplus works for me with the same UNIX user. Just to prove the point, I've added the following line to my code: $opt_d && print `id`; Here's what perl prints: uid=105(psoft) gid=101(dba) groups=1004(cobol) Thanks, Gal -----Original Message----- From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] Sent: Monday, 8 September 2003 9:07 PM To: 'Baras, Gal'; '[EMAIL PROTECTED]' Subject: RE: ORA-01031 when trying to connect as sysdba. sqlplus works This is caused by the user executing the script not being part of the dba group. ORA-01031 is insufficient privileges. Who ever is executing the script needs to be part of the dba group or osdba group. HTH. Thanks, Sam Gold -----Original Message----- From: Baras, Gal [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 3:59 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: ORA-01031 when trying to connect as sysdba. sqlplus works Hello, I'm getting an ORA-01031 error when trying to use the ORA_SYSDBA or ORA_SYSOPER modes. When using sqlplus, I can use '/ as sysdba' and '/ as sysoper' as the same UNIX user(s). This is on HP-UX 11i, Oracle 9.20, perl 5.8.0, DBI 1.37 and DBD::Oracle 1.14. Thanks, Gal
