RelationalDBDesign RelationalDBDesign

Network Config  «Prev 

Resolving Oracle Requests

Resolving requests beteen Oracle Names Server Jerry, Tom

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.