ASM login fails with error ORA-01017 on windows (Doc ID 1994865.1)

Last updated on JANUARY 03, 2020

Applies to:

Symptoms

On : 11.2.0.4 version, STORAGE

Not able to login to ASM Instance

Getting ORA-01017 error when trying to login to ASM instance.
But we are able to login with blank password. Due to this we are not able to login to DB console for ASM monitoring.


Enter user-name: sys as sysasm
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
 

==

Can able to connect without giving password as below

sqlplus '/as sysasm'

but fail to connect with password

Changes

1. Check if the sys user is having proper privileges.

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  TRUE
ASMSNMP                        TRUE  FALSE FALSE

2. Check the servers are up

C:\Users\HMO1SQLCLU>sc query state= all | findstr OracleService | findstr SERVICE_NAME
SERVICE_NAME: OracleServiceFMOPICSP1
SERVICE_NAME: OracleServiceSAASTSPR1

3. Check if remote_login_passwordfile is EXCLUSIVE on ASM. if NONE, then need to set EXCLUSIVE or SHARED.

SQL> show parameter remote_login_passwordfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE

4. Check SQLNET.AUTHENTICATION_SERVICES in file in GRID_HOME/network/admin/sqlnet.ora. value should be NTS. The value for this parameter should NOT be NONE.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.