My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Standard Edition - Version and later
Microsoft Windows x64 (64-bit)


On : 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:
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


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


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;

------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE


4. Check SQLNET.AUTHENTICATION_SERVICES in file in GRID_HOME/network/admin/sqlnet.ora. value should be NTS. it should not be NONE.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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