| Oracle9i Net Services Reference Guide Release 2 (9.2) Part Number A96581-02 |
|
|
View PDF |
This chapter provides a complete listing of the names.ora file configuration parameters.
This chapter contains these topics:
Oracle Names server configuration, stored in the names.ora file, consists of the following elements:
By default, names.ora is located in the $ORACLE_HOME/network/admin directory on UNIX operating systems and the ORACLE_HOME\network\admin directory on Windows NT. names.ora can also be stored the following locations:
TNS_ADMIN environment variable or registry value/var/opt/oracle.
Figure 10-1 shows a names.ora file for an Oracle Names server named namesvr2.us.acme.com.
NAMES.SERVER_NAME=namesvr2.us.acme.comNAMES.ADDRESSES=(ADDRESS=(PROTOCOL=tcp)(HOST=namesvr2-server)(PORT=1575))NAMES.ADMIN_REGION=(REGION=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com))(USERID=system) (PASSWORD=manager) (NAME=local_region)(REFRESH=86400)(RETRY=60)(EXPIRE=600))NAMES.DOMAIN_HINTS= (HINT_DESC= (HINT_LIST= (HINT= (NAME=namesvr1) (ADDRESS=(PROTOCOL=tcp)(HOST=namesvr1-server)(PORT=1575))NAMES.DOMAINS=(DOMAIN=(NAME=us.acme.com)(MIN_TTL=86400))
This section lists and describes the names.ora file parameters.
Use the parameter NAMES.ADDRESSES to list the protocol addresses on which the Oracle Names server listens. Any valid ADDRESS or ADDRESS_LIST is allowed.
See Also:
|
NAMES.ADDRESSES= [(ADDRESS_LIST=] (ADDRESS=...) (ADDRESS=...)[)]
NAMES.ADDRESSES= (ADDRESS=(PROTOCOL=tcp)(HOST=namesvr-server)(PORT=1575))
NAMES.ADDRESSES= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=namesrv2-server)(PORT=1575)) (ADDRESS=(PROTOCOL=tcp)(HOST=namesrv2-server)(PORT=1375)))
Use the parameter NAMES.ADMIN_REGION to specify the data source for an administrative region.
NAMES.ADMIN_REGION= (REGION= (DESCRIPTION= (ADDRESS=...) (CONNECT_DATA=(SERVICE_NAME|SID=service_name|sid))) (USERID=user) (PASSWORD=password) (REFRESH=seconds) (RETRY=seconds) (EXPIRE=seconds) (VERSION=version) (TYPE=ldap|ldif) (HOST=directory_host) (PORT=port) (TIMEOUT=time) (SUBTREE_LIST= (SUBTREE=(BASE=base_DN)[(SCOPE=sub|one)))
REGION supports the following subparameters:
DESCRIPTION: Specify the connect descriptor that the Oracle Names server uses to connect to the region database.
USERID: If loading data from the region database, specify a database user. If loading restricted data from a LDAP-compliant directory server, specify a directory user with read privileges in the form of a distinguished name (DN).
PASSWORD: Specify the password for the database user or directory user.
REFRESH: Specify the interval in seconds when the memory cache (not the cache checkpoint file) for the local Oracle Names server will be refreshed from the region database.
The interval value for this parameter is irrelevant for Oracle Names LDAP Proxy servers, because the directory has no mechanism for enabling the Oracle Names LDAP Proxy server to determine if there is new data. Even if this parameter is specified, an Oracle Names LDAP Proxy server always has a reload interval of 248 days, 13 hours, and 20 minutes
RETRY: Specify the interval in seconds the Oracle Names server will wait after a failure to connect to the region database before trying again.
EXPIRE: Specify the time in seconds to wait before terminating the retry attempt.
VERSION: Specify an arbitrary value. Even though the value is irrelevant, this parameter is still necessary.
The following parameters are reserved for Oracle Names LDAP Proxy servers:
TYPE: Specify how the Oracle Names LDAP Proxy server is to load data from a directory server. This parameter supports the following values:
ldap: Specifies that the Oracle Names LDAP Proxy server is to load data directly from a directory server
ldif: Specifies that the Oracle Names LDAP Proxy server is to use data from an LDAP Data Interchange Format (LDIF) file
The following subparameters are for (TYPE=ldap):
HOST: Specify the directory server host name.
PORT: Specify the listening TCP/IP port for the directory server. If you do not specify this option, the default port (389) is used.
TIMEOUT: Specify the time limit in seconds in which the Oracle Names LDAP Proxy server can spend performing a search of directory objects. This time limit cannot be greater than the time limit set for searches in the directory server. By default, the time limit is set to 10 seconds, which is sufficient for most searches.
SUBTREE_LIST | SUBTREE: Use the SUBTREE parameter to specify the DN. Use the SUBTREE_LIST parameter if there are multiple DNs. The SUBTREE parameter supports the following subparameters:
BASE: Specify a subtree location in the directory information tree (DIT) from which the Oracle Names Proxy server should load data. The location is specified as a DN of a LDAP directory entry. The Oracle Names Proxy loads directory naming data from one or more Oracle Contexts located in the subtree following the entry specified.
SCOPE: Specifies where the Oracle Names Proxy server looks for directory data to load. one (default) specifies that the Oracle Names Proxy server look only in one Oracle Context directly following the entry specified in the BASE parameter. sub specifies the Oracle Names Proxy server look in all the Oracle Contexts in the subtree following the entry specified in the BASE parameter.
| See Also:
Oracle9i Net Services Administrator's Guide for more information about configuring the |
NAMES.ADMIN_REGION= (REGION= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1575)) (CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com))) (USERID=system) (PASSWORD=manager) (REFRESH=172800) (RETRY=2700) (EXPIRE=8700) (VERSION=34619392))
Use the parameter NAMES.AUTHORITY_REQUIRED to specify whether or not system queries require authoritative answers.
false
NAMES.AUTHORITY_REQUIRED=true
Use the parameter NAMES.AUTO_REFRESH_EXPIRE to specify the amount of time, in seconds, for the Oracle Names server to cache database server addresses in other administrative regions obtained through the NAMES.DOMAIN.HINTS parameter. At the end of this interval, the Oracle Names server issues a query to the other regions to refresh the database server addresses.
600
60 to 1209600
NAMES.AUTO_REFRESH_EXPIRE=1200000
Use the parameter NAMES.AUTO_REFRESH_RETRY to specify the interval, in seconds, that the Oracle Names server retries the other Oracle Names servers on its domain hint list.
180
60
3600
NAMES.AUTO_REFRESH_RETRY=180
Use the parameter NAMES.CACHE_CHECKPOINT_FILE to specify the name and directory path of the file to which the Oracle Names server writes its checkpoint file.
The $ORACLE_HOME/network/names/ckpcch.ora file on UNIX operating systems and the ORACLE_HOME\network\names\ckpcch.ora file on Windows NT
NAMES.CACHE_CHECKPOINT_FILE=c:\oracle\network\names\cacheck.ora
Use the parameter NAMES.CACHE_CHECKPOINT_INTERVAL to specify the interval, in seconds, in which the Oracle Names server writes a checkpoint of its stored data to a checkpoint file. Each Oracle Names server can periodically write its cached data to a file to protect against startup failures.
0 (disabled)
10
259200 (3 days)
NAMES.CACHE_CHECKPOINT_INTERVAL=24
Use the parameter NAMES.CONFIG_CHECKPOINT_FILE to specify the name and directory path of the file used to checkpoint Oracle Names server configuration settings.
The $ORACLE_HOME/network/names/ckpcfg.ora file on UNIX operating systems and the ORACLE_HOME\network\names\ckpcfg.ora file on Windows NT
NAMES.CONFIG_CHECKPOINT_FILE=c:\oracle\network\names\configck.ora
Use the parameter NAMES.CONNECT_TIMEOUT to specify the time, in seconds, for the Oracle Names server to wait for a connection request from a client to complete.
3
1
600
NAMES.CONNECT_TIMEOUT=8
Use the parameter NAMES.DEFAULT_FORWARDERS to provide an address list of other Oracle Names servers used to forward queries.
NAMES.DEFAULT_FORWARDERS=
(FORWARDER_LIST=
(NAME=onames_server)
(ADDRESS=...))
FORWARDER_LIST supports the following subparameters:
NAME: Specify the Oracle Names server name to forward queries.
ADDRESS: Specify the protocol address of the Oracle Names server.
| See Also:
"Protocol Parameters" for descriptions of the correct parameters to use for each protocol |
NAMES.DEFAULT_FORWARDERS= (FORWARDER_LIST= (FORWARDER= (NAME=rootserv1.com) (ADDRESS=(PROTOCOL=tcp)(HOST=root-server)(PORT=4200))))
Use the parameter NAMES.DEFAULT_FORWARDERS_ONLY to specify how the Oracle Names server forwards queries.
When you set the parameter to true, the Oracle Names server forwards queries only to those Oracle Names servers listed as default forwarders with the NAMES.DEFAULT_FORWARDERS parameter. When you set the parameter to false, the Oracle Names server calls the Oracle Names servers listed as default forwarders before other Oracle Names servers found in the cache.
false
NAMES.DEFAULT_FORWARDERS_ONLY=c:\oracle\network\names\domainck.ora
Use the parameter NAMES.DOMAIN_CHECKPOINT_FILE to specify the name and path of the file used for checkpoint authoritative domain data.
The $ORACLE_HOME/network/names/ckpdom.ora file on UNIX operating systems and the ORACLE_HOME\network\names\ckpdom.ora file on Windows NT
NAMES.DOMAIN_CHECKPOINT_FILE=c:\oracle\network\names\domainck.ora
Use the parameter NAMES.DOMAINS to provide a list of domains in the local region of the Oracle Names server, as well as the default time to live (TTL) in seconds for data in those domains.
NAMES.DOMAINS=(DOMAIN_LIST=(DOMAIN=(NAME=domain)(MIN_TTL=ttl))
NAMES.DOMAINS supports the following subparameters:
In the following example, NAMES.DOMAINS contains a listing for the root (value of null), com, acme.com, and hq.oracle.com domains. All the domain precedent to hq.acme.com must be defined in order to define hq.acme.com.
NAMES.DOMAINS=(DOMAIN_LIST=(DOMAIN=(NAME=)(MIN_TTL=86400))(DOMAIN=(NAME=com)(MIN_TTL=86400))(DOMAIN=(NAME=acme.com)(MIN_TTL=86400))(DOMAIN=(NAME=hq.acme.com)(MIN_TTL=86400)))
Use the parameter NAMES.DOMAINS_HINTS in one of two ways:
NAMES.DOMAINS_HINTS supports the following subparameters:
HINT_LIST: Specify a list of hints. Each hint contains the name and address of Oracle Names server in a remote administrative region. HINT_LIST uses the following syntax:
(HINT_LIST= (HINT=(NAME=onames_server)(ADDRESS=...)))
DOMAIN_LIST: Specify the list of remote domains. DOMAIN_LIST uses the following syntax:
(DOMAIN_LIST= (DOMAIN=domain))
| See Also:
Oracle9i Net Services Administrator's Guide for usage notes |
In the following example, NAMES.DOMAIN_HINTS contains a domain hint for Oracle Names server rootsvr.com that is located in the root domain of the remote administrative region. The DOMAIN parameter is left null, meaning that the hint is for the root domain.
NAMES.DOMAIN_HINTS= (HINT_DESC= (HINT_LIST= (HINT= (NAME=rootsvr.com) (ADDRESS=(PROTOCOL=tcp)(HOST=root-server)(PORT=1575)))) (DOMAIN_LIST= (DOMAIN=)))
The following example shows a hint to query two domains, the root domain and the us.acme.com domain, for Oracle Names servers rootsvr.com and namesvr.us.acme.com.
NAMES.DOMAIN_HINTS= (HINT_DESC= (HINT_LIST= (HINT= (NAME=rootsvr.com) (ADDRESS=(PROTOCOL=tcp)(HOST=root-server)(PORT=1575))) (HINT= (NAME=namesrv.us.acme.com) (ADDRESS=(PROTOCOL=tcp)(HOST=hr-server)(PORT=1575)))) (DOMAIN_LIST= (DOMAIN=) (DOMAIN=us.acme.com)))
Use the parameter NAMES.FORWARDING_AVAILABLE to specify how the Oracle Names server forwards client requests.
When you set the parameter to on, the Oracle Names server forwards client requests to remote Oracle Names server. When you set the parameter to off, clients outside the local domain without access to the network are unable to resolve names.
on
on | off
NAMES.FORWARDING_AVAILABLE=off
Use the parameter NAMES.FORWARDING_DESIRE to specify how the Oracle Names server handles requests for remote Oracle Names servers.
When you set the parameter to true, the Oracle Names server provides protocol address of remote Oracle Names server to clients. This way, clients are redirected to the appropriate Oracle Names server. When you set the parameter to false, the Oracle Names server connects to the remote Oracle Names server on behalf of clients.
true
true | false
NAMES.FORWARDING_DESIRED=true
Use the parameter NAMES.KEEP_DB_OPEN to specify whether to attempt to keep the connection to the region database open between operations.
When you set the parameter to true, the connection is left open after each load, reload, or reload-check. When you set the parameter to false, the connection is closed after each load, reload, or reload-check.
true
true | false
NAMES.KEEP_DB_OPEN=false
Use the parameter NAMES.LOG_DIRECTORY to specify the destination directory where the log file for Oracle Names server operational events are written
The $ORACLE_HOME/network/log directory on UNIX operating systems and the ORACLE_HOME\network\log directory on Windows NT
NAMES.LOG_DIRECTORY=c:\oracle\network\names
Use the parameter NAMES.LOG_FILE to indicate the name of the output file to which Oracle Names server operational events are written. The file name extension is always .log. Do not enter an extension for this parameter.
names
NAMES.LOG_FILE=onames
Use the parameter NAMES.LOG_STATS_INERVAL to specify the number of seconds between full statistical dumps in the log file.
0 (disabled)
10 seconds
none
NAMES.LOG_STATS_INTERVAL=12
Use the parameter NAMES.LOG_UNIQUE to indicate whether or not log files are given unique names.
When you set the parameter to on, a process identifier is appended to the name of each log file generated, allowing multiple log files to coexist. For example, log files named namespid.log are created if the default log file name, names.log, is used.
false
true | false
NAMES.LOG_UNIQUE=true
Use the parameter NAMES.MAX_OPEN_CONNECTIONS to specify the number of connections that the Oracle Names server can have open at any given time. The value is generated as the value 10 or the sum of one connection for listening, 5 for clients, plus one for each remote domain defined in the local administrative region, whichever is greater.
The calculated value is acceptable for most installations.
Calculated based on entered data.
2
64
NAMES.MAX_OPEN_CONNECTIONS=52
Use the parameter NAMES.MAX_REFORWARDS to specify the maximum number of times the Oracle Names server attempts to forward an operation.
2
1
15
NAMES.MAX_REFORWARDS=2
Use the parameter NAMES.MESSAGE_POOL_START_SIZE to specify the initial number of messages allocated in the Oracle Names server message pool that are used for incoming or outgoing forwarded messages.
10
3
256
NAMES.MESSAGE_POOL_START_SIZE=10
Use the parameter NAMES.NO_MODIFY_REQUESTS to allow or disallow operations that modify data in the Oracle Names server region.
When the parameter NAMES.NO_MODIFY_REQUESTS is set to true, the Oracle Names server refuses any operations that modify data in its region. When the parameter NAMES.NO_MODIFY_REQUESTS is set to false, the Oracle Names server accepts operations that modify data in its region.
false
true | false
NAMES.NO_MODIFY_REQUESTS=true
Use the parameter NAMES.NO_REGION_DATABASE to enable or disable the Oracle Names server from loading data from a region database.
When you set the parameter to true, the Oracle Names server does not load data from a region database. Instead, it loads data from its checkpoint files. When you set the parameter to false, the Oracle Names server loads data from a region database.
false
true | false
NAMES.NO_REGION_DATABASE=true
Use the parameter NAMES.PASSWORD to set an encrypted password for an Oracle Names server, so that certain privileged operations, such as STOP, RESTART and RELOAD, used from the Oracle Names Control utility are secure.
If this parameter is set with Oracle Net Manager, then the password is encrypted. A clear-text password can be made manually. If the password is clear-text, ensure that the NAMESCTL.INTERNAL_ENCRYPT_PASSWORD parameter in the sqlnet.ora file is set to false.
None
NAMES.PASSWORD=625926683431aa55
Use the parameter NAMES.RESET_STATS_INTERVAL to specify the number of seconds during which the statistics collected by the Oracle Names servers should accumulate. At the frequency specified, they are reset to 0. The default value of 0 means never reset statistics.
0 (never reset)
10
None
NAMES.RESET_STATS_INTERVAL=15
Use the parameter NAMES.SAVE_CONFIG_ON_STOP to specify whether or not runtime configuration changes are saved into the names.ora file.
When you set the parameter to true, the Oracle Names Control utility saves runtime configuration changes to names.ora file. Any parameters which were modified through Oracle Names Control utility SET operations replace prior names.ora settings. When you set the parameter to false, the Oracle Names Control utility does not save runtime configuration changes to the names.ora file.
false
NAMES.SAVE_CONFIG_ON_STOP=false
Use the NAMES.SERVER_NAME parameter to uniquely identify an Oracle Names server by a name. All configuration references to a particular Oracle Names server use this name.
ONAMES_onames_server
NAMES.SERVER_NAME=namesrv1.us.acme.com
Use the parameter NAMES.TOPOLOGY_CHECKPOINT_FILE to specify the name and path of the file used for checkpoint topology data. This file defines the domains in the administrative region and the Oracle Names servers authoritative for each domain. Specifically, topology data consists of:
NS.SMD record types that are authoritative for the domainA.SMD record type and listening protocol addressesThe $ORACLE_HOME/network/names/ckptop.ora file on UNIX operating systems and the ORACLE_HOME\network\names\ckptop.ora on Windows NT
NAMES.TOPOLOGY_CHECKPOINT_FILE=c:\oracle\network\names\topck.ora
Use the parameter NAMES.TRACE_DIRECTORY to specify the destination directory of the output trace files from Oracle Names trace sessions.
The $ORACLE_HOME/network/trace directory on UNIX operating systems and the ORACLE_HOME/network/trace directory on Windows NT
NAMES.TRACE_DIRECTORY=/oracle/network/admin/trace
Use the parameter NAMES.TRACE_FILE to specify the name of the output trace files for Oracle Names trace sessions. The file name extension is always .trc.
names
NAMES.TRACE_FILE=onames
Use the parameter NAMES.TRACE_FUNC to enable the internal mechanism to control tracing by a function name.
false
NAMES.TRACE_FUNC=false
Use the parameter NAMES.TRACE_LEVEL to turn Oracle Names tracing on, at a specific level, or off.
off
off for no trace outputuser for user trace informationadmin for administration trace informationsupport for Oracle Support Services trace informationNAMES.TRACE_LEVEL=admin
When NAMES.TRACE_LEVEL is set to a specific tracing level, you can use the parameter NAMES.TRACE_TIMESTAMP to add a time stamp in the form of dd-mon-yyyy hh:mi:ss:mil to every trace event in the trace file for Oracle Names.
true
yes or true | no or false
NAMES.TRACE_TIMESTAMP=true
Use the parameter NAMES.TRACE_UNIQUE to specify whether or not a unique trace file is created for each Oracle Names trace session. When the value is set to on, a process identifier is appended to the name of each trace file, enabling several files to coexist. For example, trace files named namespid.trc are created if default trace file name names.trc is used. When the value is set to off, data from a new trace session overwrites the existing file.
on
on | off
NAMES.TRACE_UNIQUE=on