EBS r12.2 ORA-1017: Invalid username/password: login denied in forms 19c database

1. In 19c database service_name parameter should be set to container name

Connect to the CDB and run the following commands:

alter System set SERVICE_NAMES='<CDBNAME>' SCOPE=BOTH;
alter system register;

Note :- Need to wait ensuring the ebs_<PDB_NAME> and <PDB_NAME>_ebs_patch running automatically

2. Verify that the PDB database is registered with the listener

Connect to PDB and check value of local_listener parameter. It should be not be set at PDB level and should be same as CDB value.

3. PDB should have at a minimum of these services in 12.1 and 12.2.

select name from v$active_services;

12.2:

ebs_<PDB NAME>
<PDB NAME>
<PDB_NAME>_ebs_patch

4. Listener should be started using CDB environment file

cd $ORACLE_HOME

CDB_HOSTNAME.env

lsnrcrt stop CDBNAME

lsnrctl start CDBNAME

5. Verify status of listner using below mentioned command :

$ lsnrctl status 

R