Same service directs to different db's-Service "e3d7469e04cd3695e053c40dd10af220" has 2 instance(s)
Oracle 19.16 RAC
I created 2 container databases. Somehow there appears to have same service name defined for 2 different databases.
$ lsnrctl status
...
Service "e3d7469e04cd3695e053c40dd10af220" has 2 instance(s).
Instance "cdba1", status READY, has 1 handler(s) for this service...
Instance "cdbf1", status READY, has 1 handler(s) for this service...
..
I have tried connecting to it, and it will direct me to cdb$root container (I have set different passwords for both databases and sometimes it needs cdba1 password and sometimes cdbf1 password).
$ sqlplus system@dc1-test-db2-1:1521/e3d7469e04cd3695e053c40dd10af220 SQL> show con_name; CON_NAME ------------------------------ CDB$ROOT