The following images illustrate the role of the Oracle listener in managing incoming connections:
A request is made in the SQL with a databse link name
The Oracle listener intercepts the incoming request and creates an Oracle session.
This in turn creates a UNIX process to manage the remote connection
Cloud DBA Oracle
Overview of Distributed Architectures
Organization and economic factors in distributed databases
The factors that create distributed database
Specialized databases
Rightsizing
Corporate acquisitions
Essentials of distributed databases
Data integrity management
Transparency features
Location transparency
Domains and location transparency
Performance and tuning methods
Interoperability features
Replication and reliability
Master-slave replication
Operating system copy replication
Replication advantages
Types of distributed databases
Architectural distribution
Geographical distribution
The myth of open systems
Solutions to distributed database communication
The impact of client-server on distributed systems