ORA-17503: ksfdopn:10 Failed to open file, ORA-01017: invalid username/password; logon denied while logging in as sysdba or sysasm (#ORA-01017 #ASM)

Issue:

The RAC environment has been migrated to new server with same ips and hostname; post migration, we are seeing below error messages while connecting to ASM instance and the CRS service was not coming up

[asmora@hostname dbs]$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jun 19 10:55:18 2017

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

ERROR:

ORA-01017: invalid username/password; logon denied

Resolution:

The OS groups (asmosadmin, asmdba) were not added to the user asmora. Post adding the groups, the issue was resolved.

Once the ASM issue was resolved, we were able to bring up CRS, but when trying to start the Database using “srvctl” we faced the below issue, which is also resolved by adding respective groups to Oracle Database OS user.

SQL> startup nomount

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file ‘+DATA/DEV/PARAMETERFILE/spfile.466.9323435433’

ORA-17503: ksfdopn:10 Failed to open file +DATA /DEV/PARAMETERFILE/ spfile.466.9323435433

ORA-01017: invalid username/password; logon denied

 

Advertisements
This entry was posted in Oracle Database, Oracle RAC. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s