- 3,722,118 Users
- 2,244,225 Discussions
- 7,849,643 Comments
DB service concept
A service name can be associated with multiple database instances, and an instance can be associated with multiple services. The listener acts as a mediator between the client and database instances and routes the connection request to the appropriate instance. Clients connecting to a service do not have to specify which instance they want to connect to.
Could someone please explain me this concept with example and diagram as I am confused about DB instance and instance.