Describe how a request is resolved through Oracle Names.
How Oracle Names resolves Requests
Clients no longer require local directory usage configuration (ldap.ora). If an Oracle Internet Directory Server
is registered with the Domain Name System (DNS), clients can automatically locate a directory server, eliminating the need for local configuration.
How Oracle Names resolves requests
The following Diagram illustrates how Oracle Names resolves a request. The areas outlined in red are described by means of the ordered list displayed below.
Resolving Oracle Requests describes the diagram above in further detail.
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 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.
To complete the picture, Oracle Names also allows for the sharing of database links for all remote databases.
These links may be either private or public and are shared among the database servers.
This simplifies database administration since the DBA does not have to define connectivity between Oracle servers.
Does Oracle Names sound like a panacea? Let us look at when its use is appropriate.
NAMESCTL is a basic utility for controlling Oracle Names Servers. This utility does not work on Oracle*Net clients, which is a legacy technology.
The namesctl utility is only used on the Oracle database server that contains the Names database.
There are several common namesctl commands that are commonly used.
NAMESCTL RESTART - Restart the Names Server.
NAMESCTL SET PASSWORD - Registers password for privileged Names Server operations such as RELOAD and STOP.
NAMESCTL SET SERVER - Change the current Names Server.
NAMESCTL SHOW SERVER - Displays name and version of current Names Server.
NAMESCTL SHOW STATUS - Displays general status information about the Names Server.
NAMESCTL SHOW TRACE_FILE_ NAME - Shows the name of the file where the Names Server writes the trace information.
NAMESCTL SHUTDOWN or STOP - Stop the Names Server.
NAMESCTL START or STARTUP - Start the Names Server.
NAMESCTL STATUS - Display the status of the current Names Server.
NAMESCTL STOP - Stops one or more Names Servers.
The namesctl utility is very similar to the lsnrctl utility in syntax. For example, to see the available commands, just enter:
Dilbert > NAMESCTL HELP
The following operations are available
An asterisk (*) denotes a modifier or extended command:
Now that we have seen the basic functions of the namesctl utility lets look at how we start and stop a Names Server.