#################################### # # 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 = )) ) # # 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