Coskan’s Approach to Oracle

April 27, 2007

ORA-01031: insufficient privileges

Filed under: Tips — coskan @ 8:23 am

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

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 193 other followers