The following ToolTip illustrates how Oracle Names resolves a request. Roll your cursor over the areas outlined in red to read about the explanation. Or click (Resolving Oracle Requests) to see a static representation on a new page.
Resolving Oracle Requests
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.
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: