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

Last updated on MAY 11, 2015

Applies to:

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

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. it should not be NONE.

 

Cause

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 hundreds of Community platforms