Hi there
Really stuck on this. Needed to complete windows updates on all my vm's. No issues on other oracle vm boxes, except this one.
After proper shutdown of database and asm, restarted server.
Checked status
E:\app\oraservice\product\12.2.0.1\grid\bin>crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE OFFLINE win2019ora3 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE win2019ora3 STABLE
ora.asm
ONLINE OFFLINE win2019ora3 STABLE
ora.ons
ONLINE ONLINE win2019ora3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE win2019ora3 STABLE
ora.evmd
1 ONLINE ONLINE win2019ora3 STABLE
ora.orcl4.db
1 ONLINE OFFLINE Instance Shutdown,ST
ABLE
--------------------------------------------------------------------------------
Tried
E:\app\oraservice\product\12.2.0.1\grid\bin>SET ORA_CRS_HOME=E:\app\oraservice\product\12.2.0.1\grid
E:\app\oraservice\product\12.2.0.1\grid\bin>SET ORACLE_SID=+ASM
E:\app\oraservice\product\12.2.0.1\grid\bin>sqlplus sys/pwd as sysasm
SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 27 16:54:22 2025
Copyright (c) 1982, 2016, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Tried
E:\app\oraservice\product\12.2.0.1\grid\bin>crsctl stop res -all
CRS-2673: Attempting to stop 'ora.cssd' on 'win2019ora3'
CRS-2673: Attempting to stop 'ora.ons' on 'win2019ora3'
CRS-2673: Attempting to stop 'ora.evmd' on 'win2019ora3'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'win2019ora3'
CRS-2677: Stop of 'ora.cssd' on 'win2019ora3' succeeded
CRS-2677: Stop of 'ora.evmd' on 'win2019ora3' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'win2019ora3' succeeded
CRS-2677: Stop of 'ora.ons' on 'win2019ora3' succeeded
E:\app\oraservice\product\12.2.0.1\grid\bin>crsctl start res -all
CRS-2672: Attempting to start 'ora.evmd' on 'win2019ora3'
CRS-2672: Attempting to start 'ora.ons' on 'win2019ora3'
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'win2019ora3'
CRS-2672: Attempting to start 'ora.cssd' on 'win2019ora3'
CRS-2676: Start of 'ora.evmd' on 'win2019ora3' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'win2019ora3' succeeded
CRS-2676: Start of 'ora.ons' on 'win2019ora3' succeeded
CRS-2676: Start of 'ora.cssd' on 'win2019ora3' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'win2019ora3'
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "E:\app\oraservice\product\12.2.0.1\diag\crs\win2019ora3\crs\trace\ohasd_oraagent_system.trc".
CRS-2674: Start of 'ora.asm' on 'win2019ora3' failed
CRS-2679: Attempting to clean 'ora.asm' on 'win2019ora3'
ORA-01017: invalid username/password; logon denied
CRS-2681: Clean of 'ora.asm' on 'win2019ora3' succeeded
CRS-4000: Command Start failed, or completed with errors.
Tried
E:\app\oraservice\product\12.2.0.1\grid\bin>asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
Tried startup, login failure
So, tried to create new password file for +ASM on file system,
orapwd file=E:\app\oraservice\product\12.2.0\dbhome_1\dbs\orapw+ASM password=<new_password>
creates file.
Try to login
set ORACLE_HOME, SID, set sqlplus /nolog
startup passwordfile=as above
not connected
very frustrating…
Any suggestions most welcome….