000035633 - ORA-01017: invalid username/password; logon denied . For details refer to "(:CLSN00107:)" when attempting to start the database for RSA Governance and Lifecycle

Document created by RSA Customer Support Employee on Oct 24, 2017
Version 1Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000035633
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0
Platform: UNIX
 
IssueWhen 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.
CauseThis 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.

Attachments

    Outcomes