Database Administration (MOSC)

MOSC Banner

Same service directs to different db's-Service "e3d7469e04cd3695e053c40dd10af220" has 2 instance(s)

edited Aug 23, 2022 1:06PM in Database Administration (MOSC) 4 comments

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center