Resolving Oracle Requests
The TOM database
The TOM database is processing the SQL statement and checks its data dictionary for a database link called JERRY.
When it does not find this link, Net8 determines the correct Oracle Names server from the sqlnet.ora file. Net8 then sends the Names server a request to resolve the database link name JERRY.
The Names server
The Names server receives the request, looks it up in the cache, and then sends the response back to the server TOM with the IP address, port number, database name, user ID, and password for the JERRY database.
Server TOM
Server TOM receives the answer and substitutes the response in place of the initial name.
Server TOM contacts server JERRY and establishes a standard Net8 distributed database connection.
Server TOM contacts server JERRY and establishes a standard Net8 distributed database connection.
