Databases Reference
In-Depth Information
Oracle Enterprise Manager Cloud Control also gives you the ability to manage network
configurations from the Enterprise Manager environment.
Debugging Network Problems
If you're having a problem with your network, one of the first steps toward debugging
the problem is to check that the Oracle Net files were generated, not handcoded. If you're
in doubt, back up the current configuration files and use the Oracle Net Manager to
regenerate them. In fact, when Oracle Support assists customers with Oracle Net prob‐
lems, one of the first questions they ask is whether or not the files were handcoded.
Oracle Connection Pooling
Many Oracle-based systems use a middle-tier server. This server is responsible for a
number of tasks, including accepting requests from clients and passing them on to the
database server. Since many clients only need a connection for a brief period, the middle
tier can perform
connection pooling
. Connection pooling allows the middle tier to es‐
tablish and manage a pool of connections that are shared between multiple clients,
reducing the overall connection overhead needed by the database instance. The Oracle
Connection Manager is responsible for the tasks of managing a connection pool from
a middle tier.
Oracle Database 12
c
also supports
database resident connection pooling
. This capability
allows connection pooling which is implemented in the database server without the
need for a middle-tier component, so systems that require or desire a direct connection
to the database can still benefit from the reduced overhead of shared connections.
Auto-Discovery and Agents
Beginning with Oracle 7.3, Oracle provided auto-discovery features that allowed it to
find new databases automatically. Support for auto-discovery increased and improved
with each Oracle release since then. Since Oracle8
i
, the Universal Installer and Oracle
Net Manager work together smoothly to automatically configure your Oracle Net net‐
work.
A key piece of the Oracle network that enables auto-discovery is the Oracle Intelligent
Agent. The agent is a piece of software that runs on the machine with your Oracle
Database(s). It acts as an agent for other functions that need to find and work with the
database on the machine. For example, the agent knows about the various Oracle in‐
stances on the machine and handles critical management functions, such as monitoring
the database for certain events and executing jobs. The agent provides a central point
for auto-discovery: Oracle Net discovers instances and databases by interrogating the
