ORA-01031: insufficient privileges on Windows

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ORA-01031: insufficient privileges on Windows
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



LOGON even if you changed the SYS user password on ORACLE database

C:\Windows\system32>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 2 17:15:06 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

sqlplus / as sysdba   does not works (ORA-01031: insufficient privileges),
But " sqlplus sys/sys as sysdba "    works fine.



SQL> show parameter remote

NAME TYPE VALUE
———————————— ———– ——————————
remote_dependencies_mode string TIMESTAMP
remote_listener string
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
result_cache_remote_expiration integer 0



sqlnet.ora Network Configuration File: C:\Oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


c:\Oracle>echo %username%
Uday

c:\Oracle>NET LOCALGROUP ORA_DBA
Alias name     ORA_DBA
Comment        Oracle DBA Group

Members
——————————————————–
NT AUTHORITY\SYSTEM
The command completed successfully.


Start => All Programs => oracle – oraDB11g_home1 => Configuration and Migration Tools => Administration Assistant for Windows
=> expand Oracle Managed Objects => Computers => <UR Hostname> => Right Click on OS Database Administrators – computer => right click and select ----Add/remove
=> Under Domain Drop down Select your hostname => Select your username => click Add => OK
finally Close your MMMc ( microsoft management console) => save it while closing.


Check wherther your user is added to ORA_DBA group or not
c:\Oracle>NET LOCALGROUP ORA_DBA
Alias name     ORA_DBA
Comment        Oracle DBA Group

Members
——————————————————–
Uday
NT AUTHORITY\SYSTEM
The command completed successfully.


Close the command prompt if already open and re-open command prompt as administrator.
c:\Oracle>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 2 19:11:09 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>