| Oracle9i Net Services Reference Guide Release 2 (9.2) Part Number A96581-02 |
|
|
View PDF |
This chapter describes the commands and associated syntax of the Oracle Names Control utility.
This chapter contains these topics:
The Oracle Names Control utility enables you to administer Oracle Names servers. You can use its commands to perform basic management functions on one or more Oracle Names servers. Additionally, you can view and change parameter settings.
The basic syntax of Oracle Names Control utility administrative commands is as follows:
namesctl command[onames_server]
where onames_server is the name of the Oracle Names server to be administered.
You can also issue Oracle Names Control utility commands at the NAMESCTL> program prompt. To obtain the prompt, enter namesctl with no arguments at the operating system command line. When you run namesctl, the program is started. You can then enter the necessary commands from the program prompt. The basic syntax of issuing commands from NAMESCTL> program prompt is as follows:
namesctl NAMESCTL> command[onames_server]
When you start the Oracle Names Control utility, it starts a session with an Oracle Names server. The session is started with the first Oracle Names server listed in the discovery file (.sdns.ora on UNIX operating systems and sdns.ora on Windows operating systems) or the sqlnet.ora file (by the NAMES.PREFERRED_SERVERS parameter). The SHOW SERVER commands display the Oracle Names server that the Oracle Names Control utility is currently managing. If you want to start a session with another Oracle Names server, then use the SET SERVER command.
|
Note: The |
The Oracle Names Control utility supports several types of administrative commands:
START, STOP, and RESTARTSET TRACE_LEVELSTATUS, SHOW LOG_FILE_NAME, and PINGEXIT, QUIT, and HELPThe Oracle Names Control utility also provides data operations command, such as QUERY and REGISTER.
You can use the SET command to change some parameter values for an Oracle Names server or the Oracle Names Control utility environment. Parameter values remain in effect until the Oracle Names server is shut down. If you want these settings to persist, use the SAVE_CONFIG, SET SAVE_CONFIG_ON_STOP, or SET SAVE_CONFIG_INTERVAL commands to save changes to the names.ora.
You can use the SHOW command to display the current value of a configuration setting.
The Oracle Names Control utility can perform operations on a local or a remote Oracle Names server. This is useful when a single administrator is managing all of the Oracle Names servers in a region, or wants to check the availability of a specific Oracle Names server.
To set up a computer to remotely administer an Oracle Names server, ensure that the Oracle Names Control utility (namesctl) executable is installed.
All commands except START can be issued when an Oracle Names server is administered remotely. The Oracle Names Control utility can only start the Oracle Names server on the same computer from where the utility is running.
When issuing commands, specify the name of the Oracle Names server as an argument. For example:
NAMESCTL> SHOW SYSTEM_QUERIES dolphin.us.acme.com
If the Oracle Names Control utility cannot locate the Oracle Names server, then a name lookup error appears:
NNL-00406: name "dolphin.us.acme.com" does not exist
If you know the protocol address of the particular Oracle Names server, then enter it in place of the name of the Oracle Names server. For example:
NAMESCTL> SHOW SYSTEM_QUERIES (ADDRESS=(PROTOCOL=tcp)(HOST=dolphin.us.acme.com)(PORT=1575))
When the name omitted, the Oracle Names server that the Oracle Names Control utility has a session with is assumed. If a session cannot be established with any Oracle Names server, then the following error appears:
NNL-00005: no server has been set. Use the "SET SERVER" command first
Use the SET SERVER command to establish a session with an Oracle Name server.
Once remote access is established, all commands except START can be issued.
| See Also:
"Oracle Names Control Utility Overview" for further information about session establishment |
If the NAMES.PASSWORD parameter is set in the names.ora, then the Oracle Names Control utility requires a SET PASSWORD command for any sensitive operations, such as stopping an Oracle Names server.
If the NAMESCTL.SERVER_PASSWORD parameter is set in the sqlnet.ora file on the node running the Oracle Names Control utility, you are prompted to use the SET PASSWORD command each time a secure operation is performed.
If you are concerned with the security implications of explicitly putting an Oracle Names server password in the client sqlnet.ora file, you can omit the NAMESCTL.SERVER_PASSWORD parameter and always use the command:
NAMESCTL> SET PASSWORD
When passed over the network, the password is encrypted, regardless of how it was set in the names.ora file. However, if the NAMESCTL.INTERNAL_ENCRYPT_PASSWORD parameter is set to false in the sqlnet.ora file, then the password is not encrypted.
Some of the Oracle Names Control utility commands require confirmation before they are executed. When you issue the command, you are prompted:
confirm:[yes or no]
Enter yes to execute the command; enter no to cancel the command.
You can turn confirmation mode off by setting the parameter NAMESCTL.NOCONFIRM to true in the sqlnet.ora file.
This section lists and describes the Oracle Names Control utility commands.
Use the command DELEGATE_DOMAIN to define a domain as the start of a subregion for the current administrative region.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system prompt:
namesctl DELEGATE_DOMAIN {domain}{onames_server}{(ADDRESS=...)}
From the Oracle Names Control utility:
NAMESCTL> DELEGATE_DOMAIN {domain}{onames_server}{(ADDRESS=...)}
{domain}: Specify the domain name.
{onames_server}: Specify the Oracle Names server name.
{(ADDRESS=...)}: Specify the Oracle Names server protocol address.
| See Also:
Chapter 5, "Protocol Address Configuration" for further information about defining protocol addresses |
This command provides a dynamic way to subdivide the namespace.
Unless a domain is delegated from a region, the Oracle Names servers in that region assume authority over all subdomains. In order to delegate a domain, you must first create a new region.
Once a domain is delegated, the Oracle Names servers in the current administrative region forward subsequent operations to the subregion where the domain is administered by Oracle Names servers.
NAMESCTL> DELEGATE_DOMAIN webwidgets.acme.com ns1.webwidgets.acme.com
(ADDRESS=(PROTOCOL=tcp)(HOST=fred.webwidgets.acme.com)(PORT=1575))
Use the command DOMAIN_HINT to specify domain hints for requests for data from remote regions. A domain hint contains the name of a remote domain and at least one address of an Oracle Names server in that domain. A hint enables the Oracle Names server to forward the request to a specific address, reducing network traffic.
Without a domain hint, an Oracle Names server forwards a request to whatever remote Oracle Names servers it knows, which then forwards the request to the root Oracle Names server in its region. The root Oracle Names server forwards the request to the Oracle Names server which has information on the domain that the request refers to.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl DOMAIN_HINT {domain}{onames_server}{(ADDRESS=...)}
From the Oracle Names Control utility:
NAMESCTL> DOMAIN_HINT {domain}{onames_server}{(ADDRESS=...)}
{domain}: Specify the domain name.
{onames_server}: Specify the Oracle Names server name.
{(ADDRESS=...)}: Specify the Oracle Names server protocol address.
| See Also:
Chapter 5, "Protocol Address Configuration" for further information about defining protocol addresses |
Any region that is not the root region will need at least the root region defined using this command in order to find objects in any other region. You can provide additional hints as optimizations to provide local Oracle Names servers with direct access to certain other regions.
NAMESCTL> DOMAIN_HINT ACME.COM ns0.acme.com (ADDRESS=(PROTOCOL=tcp)
(HOST=top.acme.com)(PORT=1575))
Use the command DUMP_ALIAS to query all the alias data in a domain or domain subtree and export the data to a LDAP-compliant directory service or into an LDAP Data Interchange Format (LDIF) file, which can later be loaded into a directory.
|
Notes:
|
The directory must already have the Oracle schema and one or more Oracle Contexts.
A password for the directory may be required.
Exporting Data to an LDIF File
NAMESCTL> DUMP_ALIAS [source] [destination] [options] {-f [filename]}
Exporting Data To a Directory
NAMESCTL> DUMP_ALIAS [source] [destination] [options] {-h host} {-p port} {-D
user_dn} {-w password}
[source]: Specify the source Oracle Names domain and, optionally, the -R argument:
{domain}: Specify the domain name for aliases to be exported. The default domain is the root. The operation is forwarded to an Oracle Names server that is authoritative for that domain if the Oracle Names server which the client contacts is not authoritative.
[-R]: Specify to recursively descend the Oracle Names tree structure. Without -R, this command looks only at objects in the specified domain.
[destination]: Specify the distinguished name (DN) in the directory information tree (DIT) where to export net service aliases. A DN can be specified in one of following ways:
For example, (dn:dc=acme,dc=com) specifies to export all aliases to cn=OracleContext under dc=acme,dc=com. By default, cn=OracleContext is automatically inserted.
You create a template by specifying attributes for mapping subdomains to the corresponding attribute/value pairs in a DN. A destination of (dn:o,ou,dc), for example, maps to a DIT structure that contains an organization (o), organization unit (ou), and a domain component (dc).
When you use -R in the source argument, the domain in the source maps to the segment of the destination argument that contains the fully-specified attribute/value pairs, and subdomains of the source domain map to nodes specified in the destination argument by attributes without values. For example, if Oracle Names contains a root domain of acme.com and delegated domains of sales.acme.com and dev.acme.com, you can use a template of (dn:ou,o=acme,c=us) to create a DIT with a common structure of o=acme,c=us and unique subtrees of ou=sales and ou=dev. Using the -R argument exports data in one of two ways:
DUMP_ALIAS command recursively descends the Oracle Names tree structure and exports all aliases in that structure to the destination node in the DIT. All the aliases in all the subdomains map to a single DIT node.
Continuing with an example of an Oracle Names root domain of acme.com and delegated domains of sales.acme.com and dev.acme.com, issuing DUMP_ALIAS acme.com (dn:dc=acme,dc=com) -R
exports all net services in acme.com, sales.acme.com, and dev.acme.com to dc=OracleContext,dc=acme,dc=com.
DUMP_ALIAS command recursively descends the Oracle Names tree structure and exports the aliases in the source domain and subdomains according to the template.
Issuing DUMP_ALIAS acme.com (dn:ou,dc=acme,dc=com) -R exports aliases in acme.com to dc=OracleContext,dc=acme,dc=com, aliases in sales.acme.com to dc=OracleContext,ou=sales,dc=acme,dc=com, and aliases in dev.acme.com to dc=OracleContext,ou=dev,dc=acme,dc=com.
[options]: Arguments that specify how the export of the aliases is to occur:
-c: Specify that the export should continue on error.
-n: Specify to not perform an actual export. This argument enables you to perform a test run. The results display to the screen.
-m: Specify that existing entries in the DIT are to be modified.
-x: Specify to not include cn=OracleContext in each object's DN.
[-f filename]: Specify that the exported data dumped into an LDIF file, which can later be loaded into a directory. The default file name is onames.ldif. To use onames.ldif as the default name, specify -f as the last argument.
These arguments specify the location of the directory server:
[-h host]: Specify the host name of the directory server.
[-p port]: Specify the port number the directory is configured to listen on. The default TCP/IP port number is 389.
These arguments specify the authentication credentials of the directory server:
[-D user_dn]: Specify a directory administrator that has been given add and modify privileges. For example, cn=Mary is the DN for an administrator named Mary.
[-w password]: Specify the password for the directory administrator.
Exporting Net Service Aliases to a LDIF File
NAMESCTL> DUMP_ALIAS acme.com (dn:dc=sales,dc=com) -R -f test.ldif
Exporting Net Service Aliases Directly Into a Directory
NAMESCTL> DUMP_ALIAS acme.com (dn:dc=sales,dc=com) -R -h ldap-server -p
389 -D cn=orcladmin -w welcome
Use the command DUMP_LDAP to query all the addresses of database objects in a domain or region and export the data to a LDAP-compliant directory service or into an LDIF file, which can later be loaded into a directory.
|
Note: Because database objects are exported as net service names, the username and password credentials for a global database link or link qualifier is not exported with the address information. In the same way you used global database links in Oracle Names, you can use a net service name from a directory to access an object in a database. However, the net service name will behave as a connected user database link. |
See Also:
|
The directory must already have an Oracle schema and one or more Oracle Contexts.
A password for the directory may be required.
Exporting Data to an LDIF File
NAMESCTL> DUMP_LDAP [source] [destination] [options] {-f [filename]}
Exporting Data To a Directory
NAMESCTL> DUMP_LDAP [source] [destination] [options] {-h host} {-p port} {-D
user_dn} {-w password}
[source]: Specify the source Oracle Names domain and, optionally, the -R argument:
{domain}: Specify the domain name for objects to be exported. The default domain is the root. The operation is forwarded to an Oracle Names server that is authoritative for that domain if the Oracle Names server which the client contacts is not authoritative.
[-R]: Specify to recursively descend the Oracle Names tree structure. Without -R, this command looks only at objects in the specified domain.
[destination]: Specify the DN in the DIT where to export objects. A DN can be specified in one of following ways:
For example, (dn:dc=acme,dc=com) specifies to export objects to cn=OracleContext under dc=acme,dc=com. By default, cn=OracleContext is automatically inserted.
You create a template by specifying attributes for mapping subdomains to the corresponding attribute/value pairs in a DN. A destination of (dn:o,ou,dc), for example, maps to a DIT structure that contains an organization (o), organization unit (ou), and a domain component (dc).
When you use -R in the source argument, the domain in the source maps to the segment of the destination argument that contains the fully-specified attribute/value pairs, and subdomains of the source domain map to nodes specified in the destination argument by attributes without values. For example, if Oracle Names contains a root domain of acme.com and delegated domains of sales.acme.com and dev.acme.com, you can use a template of (dn:ou,o=acme,c=us) to create a DIT with a common structure of o=acme,c=us and unique subtrees of ou=sales and ou=dev. Using the -R argument exports data in one of two ways:
DUMP_ALIAS command recursively descends the Oracle Names tree structure and exports all net service names and database services in that structure to the destination node in the DIT. All the objects in all the subdomains map to a single DIT node.
Continuing with the example of an Oracle Names root domain of acme.com and delegated domains of sales.acme.com and dev.acme.com, issuing
DUMP_LDAP acme.com (dn:dc=acme,dc=com) -R
exports all net service names and database services in acme.com, sales.acme.com, and dev.acme.com to dc=OracleContext,dc=acme,dc=com.
DUMP_ALIAS command recursively descends the Oracle Names tree structure and exports the net service names and database services in the source domain and subdomains according to the template.
Issuing DUMP_LDAP acme.com (dn:ou,dc=acme,dc=com) -R
exports objects in acme.com to dc=OracleContext,dc=acme,dc=com, objects in sales.acme.com to dc=OracleContext,ou=sales,dc=acme,dc=com, and objects in dev.acme.com to dc=OracleContext,ou=dev,dc=acme,dc=com.
[options]: Arguments that specify how the export of data is to occur:
-c: Specify that the export should continue on error.
-n: Specify to not perform an actual export. This argument enables you to perform a test run. The results display to the screen.
-m: Specify that existing entries in the DIT are to be modified.
-x: Specify to not include cn=OracleContext in each object's DN.
[-f filename]: Specify that the exported data be dumped into an LDIF file, which can later be loaded into a directory. The default file name is onames.ldif. To use onames.ldif as the default name, specify -f as the last argument.
These arguments specify the location of the directory server:
[-h host]: Specify the host name of the directory server.
[-p port]: Specify the port number the directory is configured to listen on. The default TCP/IP port number is 389.
These arguments specify the authentication credentials of the directory server:
[-D user_dn]: Specify a directory administrator that has been given add and modify privileges. For example, cn=mary is the DN for an administrator named Mary.
[-w password]: Specify the password for the directory administrator.
Exporting Data to an LDIF File
NAMESCTL> DUMP_LDAP sj.us.sczi.com (dn:ou=sj,dc=us,dc=sczi,dc=com) -R -f
test.ldif
Exporting Data Directly Into a Directory
NAMESCTL> DUMP_LDAP sj.us.sczi.com (dn:ou=sj,dc=us,dc=sczi,dc=com) -R -h
ldap-server -p 389 -D cn=orcladmin -w welcome
Use the command DUMP_TNSNAMES to write the address information defined in the local region to a tnsnames.ora file.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl DUMP_TNSNAMES
From the Oracle Names Control utility:
NAMESCTL> DUMP_TNSNAMES
None
DUMP_TNSNAMES writes the addresses defined in the local region into tnsnames.ora, that is, everything with an address-type record, A.SMD.
The command creates or partially overwrites the tnsnames.ora file. Any entries in the existing tnsnames.ora that are not defined in the Oracle Names servers will remain. Any definitions in tnsnames.ora that are also defined in the Oracle Names servers will be overwritten. Entries that are defined in the Oracle Names servers but not in the tnsnames.ora are added.
NAMESCTL> DUMP_TNSNAMES
Use the command EXIT to exit from the Oracle Names Control utility.
The Oracle Names Control utility must be loaded.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the Oracle Names Control utility:
NAMESCTL> EXIT
None
EXIT has no affect on any Oracle Names servers; it affects only the Oracle Names Control utility.
This command is identical to the QUIT command.
namsctl> EXIT
NL-00851: NAMESCTL finished
Use the command FLUSH to instruct the Oracle Names server to clear all remote region information from its local cache checkpoint file, which has a default of ckpcch.ora.
This command is relevant with an environment with multiple regions where there is authoritative data.
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system prompt:
namesctl FLUSH [onames_server] [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> FLUSH [onames_server] [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then only the current Oracle Names server cache is flushed of the foreign names.
FLUSH erases all remote data that has been cached. Typically, you should flush the foreign data cache for the following reasons:
Names are flushed from the current Oracle Names server. The current Oracle Names server is either the default preferred Oracle Names server or the one set by using the SET SERVER command.
NAMESCTL>FLUSHConfirm [yes or no]:yes
Use the command FLUSH_NAME to instruct the Oracle Names server to clear information for a specific region from its local cache checkpoint file, which has a default of ckpcch.ora.
This parameter is useful for an environment with multiple regions. (In central administration, there is no authoritative data.)
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system prompt:
namesctl flush_name {domain}
From the Oracle Names Control utility:
NAMESCTL> flush_name {domain}
[domain]: Specify the domain name.
FLUSH_NAME erases only data cached from outside the region of the Oracle Names server, that is, non-authoritative data. Data is typically flushed when a name is behaving unusually, suggesting the source copy may have changed.
Names are flushed from the current Oracle Names server. The current Oracle Names server is either the default preferred Oracle Names server or the one set by using the SET SERVER command.
NAMESCTL> FLUSH_NAME mountain.acme.com
Use the command HELP to provide a list of all the Oracle Names Control utility commands or provide syntax help for a particular Oracle Names Control utility command.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl HELP [command]
From the Oracle Names Control utility:
NAMESCTL> HELP [command]
[command]: Specify a HELP command. Commands are shown in the following example output.
When you enter a command as an argument to HELP, the Oracle Names Control utility displays information about how to use the command. When you enter HELP without an argument, the Oracle Names Control utility displays a list of all the commands.
NAMESCTL> HELP
The following operations are available:
An asterisk (*) denotes a modifier or extended command:
exit
flush
flush_name
log_stats
ping
query
quitreload
repeat*
reset_stats
restart
save_config
set*
show
shutdown
start
startup
status
stop
version
Use the command LIST_DELEGATED to list all the delegated domains for the root region or a specified domain.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl LIST_DELEGATED [domain]
From the Oracle Names Control utility
NAMESCTL> LIST_DELEGATED [domain]
[domain]: Specify the domain name.
Before exporting data from an Oracle Names server to a directory server, use this command to find out the current domain structure.
NAMESCTL> LIST_DELEGATED
europe.acme.com
asia.acme.com
africa.acme.com
Use the command LIST_DOMAINS to list all the domains in the root region or subdomains for a specified domain.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system
namesctl LIST_DOMAIN [domain]
From the Oracle Names Control utility:
NAMESCTL> LIST_DOMAIN [domain]
[domain]: Specify the domain name.
Before exporting data from an Oracle Names server to a directory server, use this command to determine the current domain structure.
NAMESCTL> LIST_DOMAINS
com
sczi.com
us.sczi.com
sj.us.sczi.com
Use the command LIST_OBJECTS to list all the network objects for the root region or a specified domain.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl LIST_OBJECT [-R] [domain]
From the Oracle Names Control utility:
NAMESCTL> LIST_OBJECT [-R] [domain]
[-R]: Specify that all authoritative subdomains of the given domain be listed.
[domain]: Specify the domain name.
Before exporting data from an Oracle Names server to a directory server, use this command to determine the objects stored in a domain.
NAMESCTL> LIST_OBJECTS
partsdb.widgets.acme.com
toolsdb.widgets.acme.com
partsdb.components.widgets.acme.com
sparepartsdb.gadgets.widgets.acme.com
Use the command LOAD_TNSNAMES to load all connect descriptors defined in one or more tnsnames.ora files into an Oracle Names server.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system prompt:
namesctl LOAD_TNSNAMES {directory_path/tnsnames.ora} [...]
From the Oracle Names Control utility:
NAMESCTL> LOAD_TNSNAMES {directory_path/tnsnames.ora}[...]
{directory_path/tnsnames.ora}: Specify one or more tnsnames.ora files.
This command would typically be used once when a site begins using Oracle Names after having used tnsnames.ora files. Run this command once for each region. The names defined during this operation will be defined permanently and will be propagated from one Oracle Names server to all the rest in the region.
NAMESCTL> LOAD_TNSNAMES /oracle9i/network/admin/tnsnames.ora
Name: koala.lab.npd.us.acme.com
Response status: normal, successful completion
Name: devdd.rdbms.us.acme.com
Response status: normal, successful completion
Name: envyd.lab.npd.us.acme.com
Response status: normal, successful completion
Name: stealth.npd.us.acme.com
Response status: normal, successful completion
Name: null.us.acme.com
Response status: normal, successful completion
Name: slime.lab.npd.us.acme.com
Response status: normal, successful completion
Name: felix.hp.us.acme.com
Response status: normal, successful completion
Name: dtnet1.dec.acme.com
Response status: normal, successful completion
Name: devds.rdbms.us.acme.com
Response status: normal, successful completion
Use the command LOG_STATS to log the current set of statistics to the configured log file for that Oracle Names server. The log file has a default of names.log.
None
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system prompt:
namesctl LOG_STATS [onames_server] [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> LOG_STATS [onames_server] [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. When no names are supplied, then only the statistics for the current Oracle Names server are reset.
Statistics may be logged if the STATUS command or other behavior indicates some data that you would like to capture in the log. This command does not affect the current log statistics interval.
NAMESCTL> LOG_STATS
Statistics counters logged.
Use the command PASSWORD to set an encrypted password for privileged Oracle Names Control utility commands, such as STOP, RESTART, and RELOAD.
The Oracle Names Control utility must be loaded.
Not applicable
From the Oracle Names Control utility:
NAMESCTL> PASSWORD [password]
Text string matching the value encrypted in the NAMES.PASSWORD parameter in the names.ora file.
This command does not change a password already established with the NAMES.PASSWORD parameter in the names.ora file. It simply sets an Oracle Names Control utility variable. Then, the value stored is sent from the Oracle Names Control utility with any command request to the Oracle Names server, and the value is compared to that on the Oracle Names server. If they match, then operations requiring passwords are allowed.
Only privileged operations are affected, that is, operations that alter the functioning of the Oracle Names server. Operations such as SHOW or STATUS are not considered privileged, and do not require a password.
The password can either be passed as an argument of the PASSWORD command, or, if no argument is given, you are prompted for the password. Note that the input is not displayed on the screen as it is entered.
When passed over the network, the password is always encrypted, regardless of how it is set.
NAMESCTL>PASSWORD open_sesameNAMESCTL>PASSWORDEnter name server password:names9i
Use the command PING to contact an Oracle Names server and display the request/response time.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system prompt:
namesctl PING [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> PING [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then only the current Oracle Names server is pinged.
Ping ensures that an Oracle Names server is functioning and shows typical response times from the location of the Oracle Names Control utility user to an Oracle Names server.
NAMESCTL> PING nserver.com
Round trip time is 0.04 seconds
Use the command QUERY to retrieve the contents of a network object stored in the Oracle Names server.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system prompt:
namesctl QUERY object_name [record_type] [modifiers]
From the Oracle Names Control utility:
NAMESCTL> QUERY object_name [record_type] [modifiers]
[record_type]: Specify one of the following record types:
A.SMD for a network addressCNAME.SMD for an aliasDL.RDBMS.OMD for a global database linkDLCR.RDBMS.OMD for a global database link qualifierNS.SMD for an Oracle Names serverV1ADD.NPO.OMD for a SQL*Net Version 1 connect descriptor[modifier]: Specify one of the following modifier types:
authority: Forces the query to be resolved at the source of the data (in the administrative region where the data is considered local) even if the data is in the local cache. Use this modifier if you suspect that the data has changed at the source.noforward: Queries for the data, but does not forward the request. When the data is not local and no forward is specified, the query is not be resolved.trace: Enables a trace of the path to the answer. This is useful whenever you want to find out which Oracle Names servers the request went to.QUERY can be used to verify that a defined piece of data can be found, and that the contents are correct.
If this command is used with just a name as a parameter, then Oracle Names server responds with the number of pieces of data with that name, and the time required to complete the operation.
If this command is used with the name and type supplied as arguments, the specific name is looked up and returned to the user.
The QUERY command can take multiple arguments. For example:
QUERY sales.com a.smd authority trace
This command operates on the current Oracle Names server, either the default, or as specified using the SET SERVER command.
NAMESCTL> QUERY bones.dem.medicine a.smd
Total response time:0.04 seconds
Response status:normal, successful completion
Authoritative answer:yes
Number of answers:1
Canonical name:bones.dem.medicine
TTL: 1 day
Alias translations:
from:bones.dem.medicine
to: bones.dem.medicine
Answers:
data type is "a.smd"
Syntax is ADDR:...(DESCRIPTION=(ADDRESS=
(PROTOCOL=TCP)(Host=bones-pc)
(Port=1521))(CONNECT_DATA=(SERVICE_NAME=bones.dem.medicine)))
Use the command QUIT to quit the Oracle Names Control utility.
The Oracle Names Control utility must be loaded.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the Oracle Names Control utility:
NAMESCTL> QUIT
None
QUIT has no affect on any Oracle Names servers; it affects only the Oracle Names Control utility.
This command is identical to the EXIT command.
NAMESCTL> QUIT
NL-00851: NAMESCTL finished
Use the command REGISTER to register a network object to an Oracle Names server.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system
namesctl REGISTER {object_name} [-t service_type] [-d[(DESCRIPTION=](ADDRESS=...)[(CONNECT_DATA=(SERVICE_NAME|SID=service_ name|SID))][)] [-h host] [-l listener_name]
From the Oracle Names Control utility:
NAMESCTL> REGISTER {object_name} [-t service_type] [-d[(DESCRIPTION=](ADDRESS=...)[(CONNECT_DATA=(SERVICE_NAME|SID=service_ name|SID))][)] [-h host] [-l listener_name]
{object_name}: Specify the object name.
[-t service_type]: Specify the service type of the object:
ORACLE_DATABASE for an Oracle databaseORACLE_LISTENER for a listenerORACLE_NAMESERVER for an Oracle Names server
|
Note: To register an Oracle Names server, use the |
[-d]: Specify the protocol address of the listener or Oracle Names server object, or complete connect descriptor of the database object, net service name, alias, or global database link.
| See Also:
Chapter 5, "Protocol Address Configuration" for further information about protocol addresses and parameters |
[-h host]: Specify the host name that the object resides on.
[-l listener_name]: Specify the name of the listener object.
The service type, address description, host, and listener name options are not necessary to make the registration process appear to work. However, they are necessary to make the registration useful. In other words, an object name registered without an address cannot be used.
| See Also:
Chapter 5, "Protocol Address Configuration" for further information about protocol addresses and parameters |
This command provides a mechanism for registering a service, its type, its hostname, and its address. Both the type of service and the data can be any valid string, but the typical registration has either ORACLE_DATABASE or ORACLE_LISTENER as type of service, and the address as the data.
The object registration is propagated to all other Oracle Names servers in the region.
If the sqlnet.ora file is configured with the parameter NAMES.DEFAULT_DOMAIN to set the same domain name as the database domain, then the database name does not need to be qualified with the domain.
The following example shows the registration of database service sales.us.acme.com.
NAMESCTL> REGISTER sales -t oracle_database -d (DESCRIPTION=(ADDRESS=
(PROTOCOL=TCP)(HOST=sales-server)(PORT=1575)) (CONNECT_DATA=(SERVICE_
NAME=sales.us.acme.com)))
Use the REGISTER_NS command to define an Oracle Names server and its authoritative domain.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl REGISTER_NS {onames_server}{(ADDRESS=...)}{domain}
From Oracle Names Control utility:
NAMESCTL> REGISTER_NS {onames_server}{(ADDRESS=...)}{domain}
{onames_server}: Specify the Oracle Names server name.
{(ADDRESS=...)}: Specify the Oracle Names server protocol address.
{domain}: Specify the domain name.
This command provides a mechanism for registering an Oracle Names server as an authoritative server for a given domain. The command adds a network session record type, NS.SMD, for the Oracle Names server to the domain, and provides the Oracle Names server with an address record, A.SMD.
This command will fail if either the domain exists and has non-NS records or the Oracle Names server exists and has a type of service record that is other than 'ORACLE_NAMESERVER'.
Ordinarily, the Oracle Names servers maintain their own data by registering themselves when they start. This command is provided as a manual way to manage domain and Oracle Names server data if for some reason the Oracle Names server cannot. This may occur if the region database tables are set up as read-only for security reasons.
If the Oracle Names servers are not registering themselves, then use this command to define the region topology data. Each Oracle Names server in the region should be defined using this command for each top-level domain in the region. Usually, the top level consists of a single parent domain, for example, acme.com. However, a region may also have multiple sibling parent domains, for example, a region covering North America would have US, CA, and MX as its top-level parent domains.
Note the regions which were defined using the Oracle Network Manager in SQL*Net version 2 have NS.SMD records defined for every domain in the administrative region, but in Oracle Net only the top-level parent domains need to have ns.smd records defined for each server in the region.
Use the Oracle Names Control utility DELEGATE DOMAIN command to define Oracle Names servers which are delegation points for subregions.
Use the NAMES.DOMAIN_HINTS parameter in the names.ora file to provide data about any other Oracle Names servers in foreign regions.
NAMESCTL> REGISTER_NS namesrv1
(ADDRESS=(PROTOCOL=tcp)(HOST=namesvr1)(PORT=1575))
Total response time: 7 minutes 59.14 seconds
Response status: normal, successful completion
Use the command RELOAD to force the Oracle Names server to check immediately for data changes in its administrative region. If there are any changes, then the Oracle Names server reloads all database service names, net service names, global database links, and aliases.
None
Yes. If a password is set, then issue then the SET PASSWORD command prior to this command.
From the operating system prompt:
namesctl RELOAD [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> RELOAD [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then only the current Oracle Names server is reloaded.
All Oracle Names servers load their data directly from the database specified by the NAMES.ADMIN_REGION parameter in the names.ora file.
In an environment with multiple regions, RELOAD affects only the data for the current administrative region. All foreign data in the cache is unchanged.
NAMESCTL> RELOAD
Server reloaded.
Use the command REORDER_NS to create the file that lists local Oracle Names servers and their protocol addresses.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system prompt:
namesctl REORDER_NS [(ADDRESS=...)]
From the Oracle Names Control utility:
NAMESCTL> REORDER_NS [(ADDRESS=...)]
| See Also:
Chapter 5, "Protocol Address Configuration" for further information about protocol addresses and parameters |
[(ADDRESS=...)]: Specify an optional Oracle Names server address to be used as the initial Oracle Names server to contact.
This command generates the file which defines Oracle Names server names and addresses to enable clients to contact Oracle Names servers for name lookup.
The REORDER_NS command performs the following tasks:
sqlnet.ora file with the NAMES.PREFERRED_SERVERS parameterping to each of these Oracle Names servers
NAMESCTL> REORDER_NS (ADDRESS=(PROTOCOL=tcp)(HOST=namesrv-server)(PORT=1575))
Use the command REPEAT to perform QUERY, REGISTER, TIMED_QUERY, or UNREGISTER multiple times to compute average return rates.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system prompt:
namesctl REPEAT {number} QUERY|REGISTER|TIMED_QUERY|UNREGISTER [record_type]
From the Oracle Names Control utility:
NAMESCTL> REPEAT {number} QUERY [record_type]
{number}: Specify an integer
[record_type]: Specify one of the following record types:
A.SMD for a network addressCNAME.SMD for an aliasDL.RDBMS.OMD for a global database linkDLCR.RDBMS.OMD for a global database link qualifierNS.SMD for an Oracle Names serverV1ADD.NPO.OMD for a SQL*Net Version 1 connect descriptorThis command is useful for understanding the average response time over a number of requests.
Do not specify too large a number here; while the number of iterations are occurring, the Oracle Names Control utility cannot perform any other operation.
NAMESCTL> REPEAT 10 QUERY manatee a.smd
Number of requests: 10
Average response time: 0.01 seconds
Minimum response time: 0.01 seconds
Maximum response time:0.04 seconds
Total response time:0.14 seconds
Response status:normal, successful completion
Authoritative answer:yes
Number of answers: 1
TTL: 1 day
Answers:
data type is "a.smd"
Syntax is ADDR:(DESCRIPTION=(ADDRESS=
(PROTOCOL=TCP)(Host=salmon)
(Port=1522))(CONNECT_DATA=(SID=otter)))
Use the command RESET_STATS to reset the Oracle Names server statistics to the original values of the Oracle Names server at startup.
None
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system prompt:
namesctl RESET_STATS [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> RESET_STATS [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then only the current statistics for the Oracle Names server are reset.
NAMESCTL> RESET_STATS
Confirm [yes or no]: yes
Server statistics reset.
Use the command RESTART to initiate a reset of an Oracle Names server to its original state at startup.
None
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system prompt:
namesctl RESTART [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> RESTART [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then only the current Oracle Names server is restarted.
RESTART is the same as STARTUP, except that you use it when the Oracle Names server is already running.
Data is reloaded, statistics are reset, and all foreign data is flushed. Valid foreign cache data, that is, data with a TTL greater than 0, is retrieved from the checkpoint files.
NAMESCTL> RESTART
Confirm [yes or no]: yes
Server restarted.
Use the SAVE_CONFIG command to compare the current configuration state of the Oracle Names server, including trace level, trace file, trace directory, and logging to the names.ora file. Any changes are stored in names.ora, preserving formatting, comments, and case as much as possible.
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
lsnrctl SAVE_CONFIG
From the Oracle Names Control utility:
LSNRCTL> SAVE_CONFIG
None
NAMESCTL> SAVE_CONFIG
Server saving the config file now
Use the SET command to alter the parameter values for the Oracle Names server. These changes remain in effect until the Oracle Names is stopped. To make the changes permanent, use the SAVE_CONFIG, SET SAVE_CONFIG_ON_STOP, or SET SAVE_CONFIG_INTERVAL commands to save changes to the names.ora file.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
NAMESCTL SET [parameter]
From the Oracle Names Control utility:
namesctl> SET [parameter]
[parameter]: Specify a SET parameter to modify its configuration setting. Parameters are shown in the example output.
When you enter SET without an argument, the Oracle Names Control utility displays a list of all the parameters.
NAMESCTL> SET
The following operations are available after set
An asterisk (*) denotes a modifier or extended command:
cache_checkpoint_interval
default_domain
forwarding_available
log_file_name
log_stats_interval
NAMESCTL_trace_level
password
requests_enabled
reset_stats_interval
save_config_interval
save_config_on_stop
server
trace_file_name
trace_level
Use the command SET CACHE_CHECKPOINT_INTERVAL to specify the time, in seconds, of how often to save all collected information about remote regions to the local cache file. By default, the cache checkpoint file name is ckpcch.ora.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SET CACHE_CHECKPOINT_INTERVAL [time]
From the Oracle Names Control utility:
NAMESCTL> SET CACHE_CHECKPOINT_INTERVAL [time]
{time}: Specify the number of seconds.
For example, to increase the interval to 36 hours, set the following:
NAMESCTL> SET CACHE_CHECKPOINT_INTERVAL 129600
Minimum Value: 10
Maximum Value: 259200 (3 days)
Default Value: 0 (disabled)
NAMESCTL> SET CACHE_CHECKPOINT_INTERVAL 12
Use the command SET DEFAULT_DOMAIN to set the domain from which the Oracle Names Control utility most often looks up names resolution requests. The domain set is used for the duration of the session, ignoring the NAMES.DEFAULT_DOMAIN parameter configured in the sqlnet.ora file.
The Oracle Names Control utility must be loaded.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the Oracle Names Control utility:
NAMESCTL> SET DEFAULT_DOMAIN [domain_name]
{domain}: Specify the domain name. The root domain is the default domain.
When a default domain is set, it is automatically appended to any unqualified net service name or service name. For example, if the default domain is set to us.acme.com, the global name sales.us.acme.com can be queried using:
NAMESCTL> QUERY sales
NAMESCTL> SET DEFAULT_DOMAIN us.acme.com
Default domain is now "US.ACME.COM"
Use the command SET FORWARDING_AVAILABLE to set forwarding to remote Oracle Names servers for client name requests.
Oracle Names server must be running.
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SET FORWARDING_AVAILABLE [yes | no] [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> SET FORWARDING_AVAILABLE [yes | no] [onames_server] [...]
[yes | no]: Specify yes or on to set forwarding on. Specify no or off (default) to set forwarding off.
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then the setting is displayed for the current Oracle Names server.
This command is intended for Oracle Names servers that have no local clients and are exclusively handling requests from remote Oracle Names servers. This usually would apply only to Oracle Names servers in the root region when the root is configured without clients or services. If such an Oracle Names server is a performance bottleneck in cross-region request processing, then disabling forwarding in that Oracle Names server can reduce its workload in half. Rather than forward the request and return the answer, the Oracle Names server simply tells the requestor the address of the Oracle Names server that can answer the request. Note that there is no overall reduction in work; the work is simply displaced from the non-forwarding Oracle Names server to the requesting Oracle Names server.
|
Caution: If |
NAMESCTL> SET FORWARDING_AVAILABLE off
Request processing is now disabled.
Use the command SET LOG_FILE_NAME to set the name for the Oracle Names server log file. By default, the log file name is names.log.
None
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SET LOG_FILE_NAME [file_name]
From the Oracle Names Control utility:
NAMESCTL> SET LOG_FILE_NAME [file_name]
{file_name}: Specify file name of the Oracle Names trace. The default file name is names.log.
The LOG_FILE_NAME changes the destination of all logging messages.
NAMESCTL> SET LOG_FILE_NAME namesvr1
Use the command SET LOG_STATS_INTERVAL to change the frequency at which the statistics are logged to the log file. By default, the log file name is names.log.
None
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SET LOG_STATS_INTERVAL [time]
From the Oracle Names Control utility:
NAMESCTL> SET LOG_STATS_INTERVAL [time]
{time}: Specify the time in seconds or in [n day[s]] [hh:mm:ss]. For example, to increase the LOG_STATS_INTERVAL to 36 hours, both of the following can be set:
set log_stats_interval 129600 set log_stats_interval 1 day 12:00:00
You can specify any valid combination, such as the number of days combined with number of hours, minutes, and seconds, or just the number in hours.
Minimum Value: 10
Maximum Value: None
Special Value: 0 (never reset)
Default value: 0 (no logging)
The LOG_STATS_INTERVAL value is initially set based on the value configured in NAMES.LOG_STATS_INTERVAL parameter in the sqlnet.ora file when the Oracle Names server is loaded. By default, the value is 0 (no logging). This command is intended to override that value during server operation.
NAMESCTL> SET LOG_STATS_INTERVAL 7200
Statistic counter logging interval is now 2 hours
Use the command SET NAMESCTL_TRACE_LEVEL to set the level at which the Oracle Names Control utility can be traced.
None
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SET NAMESCTL_TRACE_LEVEL {level}
From the Oracle Names Control utility:
NAMESCTL> SET NAMESCTL_TRACE_LEVEL {level}
{level}: Specify one of the following trace levels:
off for no trace outputuser for user trace informationadmin for administration trace informationsupport for Oracle Support Services trace informationTracing assists in diagnosing unexpected or unidentifiable failures in processing the Oracle Names Control utility. Tracing writes a series of events from normal Oracle Names Control utility processing to an operating system file for review by the administrator.
When no level is specified, the setting is reset to the level specified by the NAMESCTL.TRACE_LEVEL parameter in the sqlnet.ora file.
NAMESCTL> SET NAMESCTL_TRACE_LEVEL admin
Controller's local trace level changed from 0 to 4
Use the command SET PASSWORD to set the password for privileged Oracle Names Control utility commands, such as STOP, RESTART, and RELOAD.
The password entered should match the one set for the NAMES.PASSWORD parameter in the names.ora file.
The Oracle Names Control utility must be loaded.
Not applicable
From the Oracle Names Control utility:
NAMESCTL> SET PASSWORD [password]
{password}: Specify the password.
You can enter this command when you start up the Oracle Names Control utility or at any time during the session as needed.
When passed over the network, the password is always encrypted, regardless of how it is set.
NAMESCTL>SET PASSWORD open_sesameNAMESCTL>SET PASSWORDenter name server password:onames9i
Use the command SET REQUESTS_ENABLED to determine whether the current Oracle Names server will respond to requests.
None
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SET REQUESTS_ENABLED [on | off]
From the Oracle Names Control utility:
NAMESCTL> SET REQUESTS_ENABLED [on | off]
[on] (default): Specify to have the Oracle Names server respond to requests.
[off]: Specify to send refusals to all clients that approach with names resolution requests. This is primarily useful for diagnostics when an Oracle Names server is functioning unexpectedly.
NAMESCTL> SET REQUESTS_ENABLED OFF
Confirm [yes or no]: yes
General request processing is now disabled
Use the command SET RESET_STATS_INTERVAL to change the time between the statistics being reset to 0 or initial values in the current Oracle Names server.
None
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SET RESET_STATS_INTERVAL [time]
From the Oracle Names Control utility:
NAMESCTL> SET RESET_STATS_INTERVAL [time]
{time}: Specify the time in seconds or in [n day[s]] [hh:mm:ss]. For example, to increase the RESET_STATS_INTERVAL to 72 hours, the following can be set:
SET RESET_STATS_INTERVAL 259200 SET RESET_STATS_INTERVAL 3 days
Minimum Value: 10 seconds
Maximum Value: no maximum
Default value: 0 (never reset)
The RESET_STATS_INTERVAL value is initially set based on the NAMES.RESET_STATS_INTERVAL parameter in the names.ora file. This command is intended to override that value during Oracle Names server operation.
NAMESCTL> SET RESET_STATS_INTERVAL 1 day
Statistic counter reset interval is now 24 hours
Use the command SET SAVE_CONFIG_INTERVAL to save any changes made by SET commands to the names.ora at an interval.
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SET SAVE_CONFIG_INTERVAL [time]
From the Oracle Names Control utility:
NAMESCTL> SET SAVE_CONFIG_INTERVAL [time]
{time}: Specify the time in seconds.
NAMESCTL> SET SAVE_CONFIG_INTERVAL 10
Scheduled configuration save to occur in 3 minutes
Use the command SET SAVE_CONFIG_ON_STOP to specify whether or not changes made to the parameter values for the Oracle Names server by the SET commands are to be saved to the names.ora file at the time the Oracle Names server is stopped with the SHUTDOWN or STOP commands.
When changes are saved, the Oracle Names Control utility tries to preserve formatting, comments, and letter case.
To have all parameters saved right away, use the SAVE_CONFIG command.
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SET SAVE_CONFIG_ON_STOP [on | off]
From the Oracle Names Control utility:
NAMESCTL> SET SAVE_CONFIG_ON_STOP [on | off]
[on]: Specify to save configuration to names.ora.
[off] (default): Specify to not save configuration to names.ora.
NAMESCTL>SET SAVE_CONFIG_ON_STOP on
Use the command SET SERVER to set Oracle Names server for the Oracle Names Control utility to administer.
The Oracle Names Control utility must be loaded
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the Oracle Names Control utility:
NAMESCTL> SET SERVER [onames_server | (ADDRESS=(protocol_address_information))]
| See Also:
Chapter 5, "Protocol Address Configuration" for further information about protocol addresses and parameters |
[onames_server | (ADDRESS=(protocol_address_information))]: Specify a valid Oracle Names server or Oracle Names server address.
If you specify no argument, this command defaults to the values set by the NAMES.PREFERRED_SERVERS parameter in the sqlnet.ora file.
SET SERVER enables switching between multiple Oracle Names servers while running the Oracle Names Control utility. The qualifier can be a name where the name is defined in the memory of the current Oracle Names server, or it can be the TNS address of any Oracle Names server.
The Oracle Names server name specified is resolved through normal name lookup. Another Oracle Names server can be set only if the current Oracle Names server knows or can retrieve its address. If no current Oracle Names server is set, you must enter an address to complete this command.
NAMESCTL> SET SERVER server1.us.acme
Use the command SET TRACE_FILE_NAME to set the name of the Oracle Names server trace file. By default, the trace file name is names.trc.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SET TRACE_FILE_NAME [file_name]
From the Oracle Names Control utility:
NAMESCTL> SET TRACE_FILE_NAME [file_name]
{file_name}: Specify the file name of the Oracle Names trace.
NAMESCTL> SET TRACE_FILE_NAME namesvr1
Use the command SET TRACE_LEVEL to set a specific level of tracing for the Oracle Names server.
None
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SET TRACE_LEVEL {level}
From the Oracle Names Control utility:
NAMESCTL> SET TRACE_LEVEL {level}
{level}: Specify one of the following trace levels:
off for no trace outputuser for user trace informationadmin for administration trace informationsupport for Oracle Support Services trace informationTracing assists in diagnosing unexpected or unidentifiable failures in processing the current Oracle Names server. It writes a series of events from normal Oracle Names server processing to an operating system file for review by the administrator.
After the TRACE_LEVEL is set, tracing begins immediately. All operations are traced until it is reset to trace level off.
Trace files can grow very large. Remember to turn trace level off after diagnosing the problem.
NAMESCTL> SET TRACE_LEVEL admin
Trace level is now 6.
Use the command SHOW to view the parameter values for the Oracle Names server.
All of the SET commands listed except SET PASSWORD have equivalent SHOW commands.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW
namesctl SHOW [command]
From the Oracle Names Control utility:
NAMESCTL> SHOW
NAMESCTL> SHOW [command]
[parameter]: Specify a SHOW parameter to view its configuration setting. Parameters are shown in the example output.
When you enter SET without an argument, the Oracle Names Control utility displays a list of all the parameters.
NAMESCTL> SHOW The following operations are available after show An asterisk (*) denotes a modifier or extended command: cache_checkpoint_interval default_domain forwarding_available log_file_name log_stats_interval NAMESCTL_trace_level requests_enabled reset_stats_interval save_config_interval save_config_on_stop server status system_queries trace_file_name trace_level version
Use the command SHOW CACHE_CHECKPOINT_INTERVAL to show the frequency at which the Oracle Names server cache is written to the cache checkpoint file. By default, the cache checkpoint file name is ckpcch.ora.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW CACHE_CHECKPOINT_INTERVAL
From the Oracle Names Control utility
NAMESCTL> SHOW CACHE_CHECKPOINT_INTERVAL
None
The interval is initially set with the value in NAMES.CACHE_CHECKPOINT_INTERVAL parameter in the names.ora file. By default, the value is 0, which disables cache checkpointing. Data written to the cache checkpoint file includes net service names, protocol addresses, and Oracle Names server addresses that were learned by the Oracle Names server as a result of forwarding a query to a foreign region on behalf of the client.
NAMESCTL> SHOW CACHE_CHECKPOINT_INTERVAL
Cache checkpoint interval is currently 8 minutes 20 seconds
Use the command SHOW DEFAULT_DOMAIN to show the domain set by the SET DEFAULT_DOMAIN command or the NAMES.DEFAULT_DOMAIN parameter in the sqlnet.ora file.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW DEFAULT_DOMAIN
From the Oracle Names Control utility:
NAMESCTL> SHOW DEFAULT_DOMAIN
None
When a default domain is set, it is automatically appended to any unqualified net service name or service name. For example, if the default domain is set to us.acme.com, the global name sales.us.acme.com can be queried using the following syntax:
NAMESCTL> QUERY sales
NAMESCTL> SHOW DEFAULT_DOMAIN
Current default domain is "com"
Use the command SHOW FORWARDING_AVAILABLE to show whether the Oracle Names server is forwarding client requests to remote Oracle Names servers.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW FORWARDING_AVAILABLE [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> SHOW FORWARDING_AVAILABLE [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then the setting is displayed for the current Oracle Names server.
By default, all Oracle Names servers forward requests to remote Oracle Names servers. If forwarding is disabled, then requests to remote Oracle Names server are redirected to an Oracle Names server in the region that is authoritative to the requested name.
Disabling forwarding can reduce the load on a particular Oracle Names server, but makes it impossible to direct clients to remote Oracle Names servers.
Use the SET FORWARDING_AVAILABLE command to turn forwarding on or off.
NAMESCTL> SHOW FORWARDING_AVAILABLE
Request forwarding is currently enabled
Use the command SHOW LOG_FILE_NAME to show the name of the file where the Oracle Names server writes logging information.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW LOG_FILE_NAME
From the Oracle Names Control utility:
NAMESCTL> SHOW LOG_FILE_NAME
None
The log file name is initially set with the value of the NAMES.LOG_FILE parameter in the names.ora file. By default, the log file name is names.log.
NAMESCTL> SHOW LOG_FILE_NAME
Log file name is currently
/oracle9i/network/log/names.log
Use the command SHOW LOG_STATS_INTERVAL to display the frequency at which statistics are logged to the log file.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW [onames_server] [...] LOG_STATS_INTERVAL
From the Oracle Names Control utility:
NAMESCTL> SHOW [onames_server] [...] LOG_STATS_INTERVAL
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then the setting is displayed for the current server.
The interval is initially set with the value of the NAMES.LOG_STATS_INTERVAL parameter in the names.ora file. By default, the value is 0, or no logging.
NAMESCTL> SHOW LOG_STATS_INTERVAL
Statistic counter logging is currently disabled
Use the command SHOW NAMESCTL_TRACE_LEVEL to display the level at which the Oracle Names Control utility is being traced.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW NAMESCTL_TRACE_LEVEL
From the Oracle Names Control utility:
NAMESCTL> SHOW NAMESCTL_TRACE_LEVEL
None
Tracing assists in diagnosing unexpected or unidentifiable failures in processing the Oracle Names Control utility. Tracing writes a series of events from normal Oracle Names Control utility processing to an operating system file for review by the administrator.
Tracing output is at four levels
off for no trace outputuser for user trace informationadmin for administration trace informationsupport for Oracle Support Services trace information
NAMESCTL> SHOW NAMESCTL_TRACE_LEVEL
Controller's trace level is currently 0
Use the command SHOW REQUESTS_ENABLED to show whether the Oracle Names server is responding to requests.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW REQUESTS_ENABLED [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> SHOW REQUESTS_ENABLED [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then the setting is displayed for the current server.
If requests are disabled, all requests to the Oracle Names server will be refused.
NAMESCTL> SHOW REQUESTS_ENABLED
General request processing is currently enabled
Use the command SHOW RESETS_STATS_INTERVAL to display the interval set for dumping statistics to the log file.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW RESET_STATS_INTERVAL
From the Oracle Names Control utility:
NAMESCTL> SHOW RESET_STATS_INTERVAL
None
The interval is initially set with the value of the NAMES.RESET_STATS_INTERVAL parameter in the names.ora file. By default the value is set to 0, or no reset.
For example, if statistics are reset every day, then the statistics will represent totals for the day rather than the entire time the Oracle Names server has been running.
NAMESCTL> SHOW RESET_STATS_INTERVAL
Statistic counter reset interval is currently 5 minutes
Use the command SHOW SAVE_CONFIG_INTERVAL to display the interval of when the SET command is scheduled to save to the names.ora file.
The command only displays an interval if the SET SAVE_CONFIG_INTERVAL command was set.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW SAVE_CONFIG_INTERVAL
From the Oracle Names Control utility:
NAMESCTL> SHOW SAVE_CONFIG_INTERVAL
None
NAMESCTL> SHOW SAVE_CONFIG_INTERVAL
Configuration will be saved in 1 minute 35 seconds
Use the command SHOW SAVE_CONFIG_ON_STOP to show whether SET commands changes are scheduled to be saved to the names.ora file.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW SAVE_CONFIG_ON_STOP
From the Oracle Names Control utility:
NAMESCTL> SHOW SAVE_CONFIG_ON_STOP
None
NAMESCTL>SHOW SAVE_CONFIG_ON_STOPSave_config_on_stop is currently ON
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW SERVER
From the Oracle Names Control utility:
NAMESCTL> SHOW SERVER
None
SHOW SERVER displays the current Oracle Names server that commands will operate on.
NAMESCTL> SHOW SERVER
currently managing name server "NameServer.us.acme.com
Version banner is "Oracle Names for SunOS: Version 9.2.0.2.0"
Use the command SHOW STATUS to display general status information about the Oracle Names server.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW STATUS [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> SHOW STATUS [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then the setting is displayed for the current server.
This command is identical to the STATUS command.
NAMESCTL> SHOW STATUS
Version Banner is "Oracle Names for SunOS: Version 9.2.0.2.0" Server has been
running for:1 day 2 hours 3 minutes 35.16 seconds....
Use the command SHOW SYSTEM_QUERIES to display the next occurrence of all system queries.
This is relevant only for distributed configurations. There are no system queries with only one administrative region.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW SYSTEM_QUERIES
From the Oracle Names Control utility:
NAMESCTL> SHOW SYSTEM_QUERIES
None
System queries are performed at intervals to keep information among Oracle Names servers current.
There is no specific action that can change the activities listed as system queries. Being able to show them gives the administrator an understanding of when a system change will occur, and can assist in a decision to RESTART.
NAMESCTL> SHOW SYSTEM_QUERIES
System query index number:1
Query ID:49824
Query next issued in:2 hours 55 min 3.84 seconds
Query state:2
Name:""
Desired data type:ns.smd
Use the command SHOW TRACE_FILE_NAME to display the directory path and file name of the current Oracle Names server trace file.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW TRACE_FILE_NAME
From the Oracle Names Control utility:
NAMESCTL> SHOW TRACE_FILE_NAME
None
The trace file name is initially set with the value of the NAMES.TRACE_FILE parameter in the names.ora file. The default value is names.trc.
NAMESCTL> SHOW TRACE_FILE_NAME
Trace file name is currently
/oracle9i/network/names.trc
Use the command SHOW TRACE_LEVEL to display the level of tracing for the current Oracle Names server.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW TRACE_LEVEL
From the Oracle Names Control utility:
NAMESCTL> SHOW TRACE_LEVEL
None
Tracing assists in diagnosing unexpected or unidentifiable failures in processing the current Oracle Names server. Tracing writes a series of events from normal Oracle Names server processing to an operating system file for review by the administrator.
Tracing is available at the following levels:
off for no trace outputuser for user trace informationadmin for administration trace informationsupport for Oracle Support Services trace information
NAMESCTL> SHOW TRACE_LEVEL
Trace level is currently 0
Use the command SHOW VERSION to display the current version and name of the Oracle Names server.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl SHOW VERSION [onames_server] [...] VERSION
From the Oracle Names Control utility:
NAMESCTL> SHOW VERSION [onames_server] [...] VERSION
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then the setting is displayed for the current server.
This command identifies the Oracle Names server by name and version, which can be useful when clearing up minor difficulties. This command is enabled every time you connect Oracle Names Control utility to an Oracle Names server.
NAMESCTL> SHOW VERSION
Currently managing Oracle Names server "NameServer.com"
Version banner is "Oracle Names for SunOS: Version 9.2.0.2.0"
Use the command SHUTDOWN to stop one or more Oracle Names servers.
The Oracle Names server(s) must be started.
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl SHUTDOWN [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> SHUTDOWN [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. When no arguments are supplied, only the current Oracle Names server is shut down.
SHUTDOWN stops the current Oracle Names server and unloads the program from memory. An Oracle Names server should be shut down only for operational reasons like upgrades or computer maintenance. The preferred way to stop and start an Oracle Names server is using the RESTART command because you can perform it from anywhere in the network. If SHUTDOWN and START are processed individually, then they must occur on the Oracle Names server computer.
This command is identical to the STOP command.
NAMESCTL> SHUTDOWN
Confirm [yes or no] yes
Server shut down.
Use the command START to load the Oracle Names server and start loading system and local administrative region data.
Oracle Names server must be stopped.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl START
From the Oracle Names Control utility:
NAMESCTL> START
None
START is the command to initially load an Oracle Names server into memory. At startup, the Oracle Names server reads its configuration files to set up its operating parameters, and then loads all data for the administrative region.
Security on Oracle Names server startup is supplied through the operating system that Oracle Names is installed on. Because an Oracle Names server must be started from a local session, network security is not an issue.
This command is identical to the STARTUP command.
NAMESCTL> START
Starting "/private/dsteiner/sales/bin/names"...server successfully started
Currently managing name server "namesrv1.us.acme.com"
Version banner is "Oracle Names for Solaris: Version 9.2.0.2.0"
Server name: namesrv1.us.acme.com
Server has been running for: 0.16 seconds
Request processing enabled: yes
Request forwarding enabled: yes
Requests received: 0
Requests forwarded: 0
Foreign data items cached: 0
Region data next checked for reload in: not set
Region data reload check failures: 0
Cache next checkpointed in: not set
Cache checkpoint interval: not set
Cache checkpoint file name:
/private/dsteiner/sales/network/names/ckpcch.ora
Statistic counters next reset in: not set
Statistic counter reset interval: not set
Statistic counters next logged in: not set
Statistic counter logging interval: not set
Trace level: 0
Trace file name:
/private/dsteiner/sales/network/trace/names_10841.trc
Log file name:
/private/dsteiner/sales/network/log/names.log
System parameter file name:
/private/dsteiner/sales/network/admin/names.ora
Command-line parameter file name: ""
Administrative region name: ""
Administrative region description: ""
ApplTable Index: 0
Contact ""
Operational Status 0
Save Config on Stop yes
Use the command START_CLIENT_CACHE to start the client cache process. The client cache process finds a list of the local Oracle Names servers in a static list of preferred Oracle Names servers in the sqlnet.ora file or in the discovery list file (.sdns.ora or sdns.ora) the first time it runs. Afterwards, it relies on its cache checkpoint file. Once the client cache has contact with the local region server(s), it begins to cache data on all local servers, various foreign servers, and all the data it has been asked to find.
| See Also:
Oracle9i Net Services Administrator's Guide for more information about the usage of this command |
The client cache process must be stopped.
An Oracle Names server list must exist before you run the client cache process.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl START_CLIENT_CACHE
From the Oracle Names Control utility:
NAMESCTL> START_CLIENT_CACHE
None
Once started, the client cache daemon process stores all information received from an Oracle Names server, making lookups faster.
NAMESCTL> START_CLIENT_CACHE
Starting ".../onrsd"...server successfully started
Use the command STARTUP to load the Oracle Names server and start loading system and local administrative region data.
Oracle Names server must be stopped.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl STARTUP
From the Oracle Names Control utility:
NAMESCTL> STARTUP
None
This command is identical to the START command.
See example for START.
The command STATUS display statistics for one or more Oracle Names servers.
Oracle Names server must be started.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl STATUS [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> STATUS [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. When no arguments are supplied, status is given only for the current Oracle Names server.
STATUS shows the activity of the Oracle Names server over time and its state at a point in time.
NAMESCTL> STATUS
Version banner is "Oracle Names for SunOS:
9.2.0.2.0"
Server name:NSERVER.com
Server has been running for:1 day 20 hours ........
Use the command STOP to stop one or more Oracle Names servers.
Oracle Names server must be started.
Yes. If a password is set, then issue the SET PASSWORD command prior to this command.
From the operating system:
namesctl STOP [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> STOP [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. When no arguments are supplied, only the current Oracle Names server is stopped.
STOP stops the current Oracle Names server and unloads the program from memory. An Oracle Names server should be shut down only for operational reasons like upgrades or computer maintenance. The preferred way to stop and start an Oracle Names server is using the RESTART command because you can issue it from anywhere in the network. If STOP and START are processed individually, they must occur on the Oracle Names server computer.
This command is identical to the SHUTDOWN command.
NAMESCTL> STOP
Confirm [yes or no]: yes
Server shut down
Use the command TIMED_QUERY to show all data in the Oracle Names server cache.
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl TIMED_QUERY [timestamp]
From the Oracle Names Control utility:
NAMESCTL> TIMED_QUERY [timestamp]
Time in seconds
The first time you issue this command, do not use the [timestamp] argument. The output returned includes all the objects registered. At the end of returned output is a Last timestamp field that provides a time stamp.
After there has been an update of date, issue the command again. This time, pass the time stamp provided from the first output. The command displays the data updated since the last the command was issued.
In the following output, TIMED_QUERY is issued for the first time:
NAMESCTL> TIMED_QUERY
Total response time: 0.26 seconds
Response status: normal, successful completion
Number of answers: 7
Name: [root]
data type is "ns.smd"
Syntax is DOMAIN: namesrv1
Name: us.acme.com
data type is "ns.smd"
Syntax is DOMAIN: us.acme.com
Name: hr.us.acme.com
data type is "a.smd"
Syntax is ADDR:
...(address=(protocol=tcp)(host=namesrv1-server)(port=1575))
Name: namesrv2
data type is "a.smd"
Syntax is ADDR:
...(address=(protocol=tcp)(Port=1575)(host=namesrv3-server))
data type is "tos.npd.omd"
Syntax is CTEXT: "ORACLE_NAMESERVER"
data type is "host.nm.omd"
Syntax is TEXT: "namesrv3-server"
Last timestamp: 1072
Note that the Last timestamp is 1072.
In the following output, TIMED_QUERY is issued before new data is registered.
NAMESCTL> TIMED_QUERY 1072 Total response time: 0.19 seconds Response status: NNC-00408: name "1072" exists but desired data does not
In the following output, a new object is registered:
NAMESCTL> REGISTER sales -t oracle_database -d (DESCRIPTION=(ADDRESS=
(PROTOCOL=TCP)(HOST=sales-server)(PORT=1575)) (CONNECT_DATA=(SERVICE_
NAME=sales.us.acme.com)))
Total response time: 0.29 seconds
Response status: normal, successful completion
When TIMED_QUERY is issued again, the newly registered data displays in the output:
NAMESCTL> TIMED_QUERY 1072 Total response time: 0.13 seconds Response status: normal, successful completion Number of answers: 1 Name: sales data type is "a.smd" Syntax is ADDR: ...(description=(address=(protocol=tcp)(host=sales-server)(port=1575))(connect_ data=(service_name=sales.us.acme.com) Last timestamp: 6107
Use the command UNREGISTER to remove a network object from an Oracle Names server.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system
namesctl UNREGISTER {object_name} [-t service_type] [-d[(DESCRIPTION=](ADDRESS=...)[(CONNECT_DATA=(SERVICE_NAME|SID=service_ name|SID))][)] [-h host] [-l listener_name]
From the Oracle Names Control utility:
NAMESCTL> UNREGISTER {object_name} [-t service_type] [-d[(DESCRIPTION=](ADDRESS=...)[(CONNECT_DATA=(SERVICE_NAME|SID=service_ name|SID))][)] [-h host] [-l listener_name]
{object_name}: Specify the object name.
[-t service_type]: Specify the service type of the object:
ORACLE_DATABASE for an Oracle database
ORACLE_LISTENER for a listener
ORACLE_NAMESERVER for an Oracle Names server
|
Note: To remove an Oracle Names server, use the |
[-d]: Specify the protocol address of the listener or Oracle Names server object, or complete connect descriptor of the database object, net service name, alias, or global database link
| See Also:
Chapter 5, "Protocol Address Configuration" for further information about protocol addresses and parameters |
[-h host]: Specify the host name the object resides on.
[-l listener_name]: Specify the name of the listener object.
The service type, address description, host, and listener name options are not necessary to make the registration process appear to work. However, they are necessary to make the registration useful. In other words, an object name registered without an address cannot be used.
This command provides a manual mechanism for unregistering a service. The definition for that object is removed from the Oracle Names servers in the region. If the object was registered with an address, listener name, or a host name, then the address, listener name, or host name must be provided on the command line in order to unregister the object.
NAMESCTL> UNREGISTER sales -t oracle_database -d
(description=(address= (protocol=tcp)(host=sales-server)(port=1575))(connect_
data=(service_name=db3)))
Use the UNREGISTER_NS command to undefine an Oracle Names server and its authoritative domain.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl UNREGISTER_NS {onames_server}{domain}
From Oracle Names Control utility:
NAMESCTL> UNREGISTER_NS {onames_server}{domain}
{onames_server}: Specify the Oracle Names server name. If the sqlnet.ora file parameter NAMES.DEFAULT_DOMAIN to set to the same domain name as the Oracle Names server domain, then the Oracle Name server does not need to be qualified with its domain.
{domain}: Specify the domain name.
This command provides a mechanism for unregistering an Oracle Names server as an authoritative server for a given domain. This command removes the NS.SMD record for the Oracle Names from the domain, and deletes the Oracle Names server and its A.SMD address record.
This command will fail if either the domain exists and has non-NS records or the server exists and has a type of service record that is other than 'ORACLE_NAMESERVER'.
Ordinarily, Oracle Names servers maintain their own data by registering themselves when they start. This command is provided as a manual way to manage domain and Oracle Names server data if for some reason the Oracle Names server cannot. This can occur if the region database tables are set up as read-only for security reasons.
If the Oracle Names servers are not registering themselves, then this command should be used to define the region topology data. Each Oracle Names server in the region should be defined using this command for each top-level domain in the region. Usually, the top level consists of a single parent domain, for example, acme.com. However, a region may also have multiple sibling parent domains, for example, a region covering North America would have US, CA and MX as its top-level parent domains.
Note the regions which were defined using the Oracle Network Manager in SQL*Net version 2 have ns.smd records defined for every domain in the administrative region, but in Oracle Net only the top-level parent domains need to have NS.SMD records defined for each server in the region.
NAMESCTL> UNREGISTER_NS namesrv1.us.acme.com us.acme.com
Total response time: 7 minutes 59.14 seconds
Response status: normal, successful completion
Use the command VERSION to display the current version and name of the Oracle Names server.
None
No. If a password is set, then the SET PASSWORD command does not need to be issued prior to this command.
From the operating system:
namesctl VERSION [onames_server] [...]
From the Oracle Names Control utility:
NAMESCTL> VERSION [onames_server] [...]
[onames_server]: Specify zero or more Oracle Names servers separated by a space. If no names are supplied, then the setting is displayed for the current server.
The output identifies the Oracle Names server by name and version, which can be useful when clearing up minor difficulties.
NAMESCTL> VERSION
Currently managing Oracle Names server "NameServer.com"
Version banner is "Oracle Names for SunOS: Version 9.2.0.2.0"