ORA-01017: invalid username/password; logon denied . For details refer to "(:CLSN00107:)" when attempting to start the database for RSA Governance and Lifecycle
2 years ago
Originally Published: 2017-10-12
Article Number
000041047
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0
Platform: UNIX

 
Issue
When attempting to start Oracle on an RSA Governance and Lifecycle host the following error is shown:
 
 ORA-01017: invalid username/password; logon denied . For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/rsahost/crs/trace/ohasd_oraagent_oracle.trc". CRS-2674: Start of 'ora.asm' on 'rsahost' failed ORA-01017: invalid username/password; logon denied Database is not running.
Cause
This issue can be caused by unintentionally editing the sqlnet.ora file for Oracle Grid/ASM instance instead of the AVDB database instance's sqlnet.ora.

The path to the configuration file for the Grid/ASM instance is /u01/app/12.1.0/grid/network/admin/sqlnet.ora.

The path to the configuration file for the AVDB instance is /u01/app/oracle/product/12.1.0/db_1/network/admin/sqlnet.ora.

The sqlnet.ora under /u01/app/12.1.0/grid/network/admin/ should only contain one uncommented line: 
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

If it has a similar line that contains the following text, this will cause the error listed in the summary and issue description above: 
SQLNET.AUTHENTICATION_SERVICES


 
Resolution
  1. Update /u01/app/12.1.0/grid/network/admin/sqlnet.ora so it contains only one uncommented line, that is:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
  1. Save and close the file.

Related Articles

Trending Articles

Don't see what you're looking for?