|
|
####################################
#
# SQLNET.ORA Configuration File
# Resides in $ORACLE_HOME/network/admin or in the directory specified
by
# TNS_ADMIN environment variable/registry, if defined.
#
# this SQL*NET configuration file can be used by Oracle clients to
define
# locations of Oracle Names Servers, Default Domains, and encryption
keys
# that are used with Oracle Advanced Networking Option (ANO)
#
# this file is NOT required if you have standard, unencrypted connections
and
# define databases only using tnsnames.ora files.
#
# this file only lists the most commonly used options
####################################
# the next section deals with database connect string resolution
####################################
#
# the lines below define the IP Address & Port that is running
the Oracle Names
# Server
#
NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname/IP
of Oracle Names server))(PORT = <port #>))
)
#
# the next line defines the search order in resolving databases (whether
to use names server or tnsnames.ora first)
#
NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES,HOSTNAME)
#
# The next lines define the default zone & domain of all connect
strings
# Generally, I comment out these values, having a default domain/zone
means
# will append ALL connect strings with that zone. For example, if you
have
# a default domain or 'world' and you enter a connect string of 'PROD'
then
# SQL*NET will search for a connect string called 'PROD.world' on the
# names server or in tnsnames.ora
#
NAMES.DEFAULT_ZONE=world
NAMES.DEFAULT_DOMAIN=world
#
###################################
# the next section deals with Advanced Networking Option (ANO) settings
###################################
#
# the next line defines the timeout interval
#
SQLNET.EXPIRE_TIME = 0
#
# next line defines encryption SEED
# must be same on server
#
SQLNET.CRYPTO_SEED="ajksfhak3897raejsdjJQJHQWJKH"
#
# next two lines define encryption priority between client and server
# acceptable values are (required, requested, accepted, and rejected)
#
SQLNET.ENCRYPTION_SERVER = requested
SQLNET.ENCRYPTION_CLIENT = requested
#
###################################
# the next section deals with SQL*NET logging
# enabling logging may adversely affect performance
###################################
#
# the next line defines the trace directory
#
TRACE_DIRECTORY_CLIENT=/u03/oracle/product/8.0.5/net80/admin/trace
#
TRACE_UNIQUE_CLIENT=on
TRACE_LEVEL_CLIENT=SUPPORT
|
|
|
