How to validate the system and EBS_SYSTEM passwords in EBS 12.2

How to validate the system and EBS_SYSTEM passwords in EBS 12.2

In EBS 12.2. while using ad utilities esp adop to patch the applications, we may face the issue with system and EBS_SYSTEM passwords.

They should be same in EBS 12.2.

To validate these two passwords use the utility adValidateEbssystemSchema.pl

applprod@server01:/u03/applsmu3/R122/fs1/EBSapps/appl/ad/12.0.0/bin$ perl adValidateEbssystemSchema.pl

Enter the APPS password:

Enter the SYSTEM password:

Validating APPS credentials...validated successfully

Validating SYSTEM credentials...validated successfully

Validating EBS_SYSTEM user

ebssys codelevel = C.0

***** E R R O R *****

User : EBS_SYSTEM

ORA-01017: invalid username/password; logon denied

*********************

Error: EBS_SYSTEM password is not the same as SYSTEM password

Please change the EBS_SYSTEM password to be the same as SYSTEM password

ALTER USER EBS_SYSTEM IDENTIFIED BY <SYSTEM PASSWORD>

applprod@server01:

-------------------------------------

Change the EBS_SYSTEM user manually.

----------------------------------------