ORA-01031: insufficient privileges

When you set SQLNET.AUTHENTICATION_SERVICES to NONE on SQLNET.ora file on windows you will get ORA-01031 when you try to connect with the strings belowfor SQL*Plus

C:\Documents and Settings\cgundogar>sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 – Production on Cum Nis 27 10:47:42 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR: ORA-01031: insufficient privileges C:\Documents and Settings\cgundogar>sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 – Production on Cum Nis 27 10:48:00 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. idle> connect / as sysdba ERROR: ORA-01031: insufficient privileges idle> connect “/ as sysdba” Enter password: ERROR: ORA-01017: invalid username/password; logon denied –password is not accepted Warning: You are no longer connected to ORACLE.

for RMAN

C:\Documents and Settings\cgundogar>rman target / Recovery Manager: Release 10.2.0.1.0 – Production on Cum Nis 27 10:58:09 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved.RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: ORA-01031: insufficient privileges C:\Documents and Settings\cgundogar>rman Recovery Manager: Release 10.2.0.1.0 – Production on Cum Nis 27 10:58:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. RMAN> connect target /RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-01031: insufficient privileges RMAN>

To solve this problem you can must connectby giving valid username username and password

for SQL*Plus

sys@XE> connect sys as sysdba Enter password: Connected. sys@XE> connect sys/passwd as sysdba Connected. sys@XE> connect sys@passwd as sysdba Enter password: Connected. sys@ORACOS> connect sys/passwd@oracos as sysdba –over listenerConnected. Connected. C:\Documents and Settings\cgundogar>sqlplus sys as sysdba SQL*Plus: Release 10.2.0.1.0 – Production on Cum Nis 27 11:08:57 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved.Enter password:Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 – Production sys@XE>exit C:\Documents and Settings\cgundogar>sqlplus sys/passwd as sysdba SQL*Plus: Release 10.2.0.1.0 – Production on Cum Nis 27 11:09:09 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to:Oracle Database 10g Express Edition Release 10.2.0.1.0 – Production C:\Documents and Settings\cgundogar>sqlplus sys/passwd@oracos as sysdba SQL*Plus: Release 10.2.0.1.0 – Production on Cum Nis 27 11:09:15 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 – Production With the Partitioning, OLAP and Data Mining options sys@ORACOS> exit

for RMAN

C:\Documents and Settings\cgundogar>rman Recovery Manager: Release 10.2.0.1.0 – Production on Cum Nis 27 10:56:17 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved.RMAN> connect target sys target database Password: connected to target database: XE (DBID=2496353564) RMAN> exit Recovery Manager complete. C:\Documents and Settings\cgundogar>rman Recovery Manager: Release 10.2.0.1.0 – Production on Cum Nis 27 10:56:17 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. RMAN> connect target sys/passwdconnected to target database: XE (DBID=2496353564) RMAN> exit Recovery Manager complete. C:\Documents and Settings\cgundogar>rman target sys Recovery Manager: Release 10.2.0.1.0 – Production on Cum Nis 27 10:56:28 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. target database Password: connected to target database: XE (DBID=2496353564)RMAN> exit Recovery Manager complete. C:\Documents and Settings\cgundogar>rman target sys/passwd Recovery Manager: Release 10.2.0.1.0 – Production on Cum Nis 27 10:56:38 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: XE (DBID=2496353564)

Edit (03/07/2009) : Check also
Metalink Note ID:730067.1
Metalink Note ID:114384.1