B
Sample Configuration Files

This appendix provides sample configuration files used in Net8. These files include:

Profile (SQLNET.ORA)

A profile (SQLNET.ORA) contains the parameters that specify preferences for how a client or server uses Net8 features. SQLNET.ORA is located in $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows platforms. For more information about each individual parameter, see "Profile Parameters (SQLNET.ORA)".

names.default_domain = com
names.initial_retry_timeout = 30
names.max_open_connections = 3
names.message_pool_start_size = 10
names.preferred_servers = (address_list =
 (address=(protocol=ipc)(key=n23))
  (address=(protocol=tcp)(host=nineva)(port=1383))
  (address=(protocol=tcp)(host=cicada)(port=1575))
 )
names.request_retries = 2
names.directory_path = (tnsnames, onames, hostname)
namesctl.trace_directory = /oracle/network/trace
namesctl.trace_file = namesctl.trc
namesctl.trace_level = admin
namesctl.trace_unique = true
namesctl.no_initial_server = false
namesctl.internal_use = true
namesctl.noconfirm = true
namesctl.server_password = mangler
namesctl.internal_encrypt_password = false
names.dce.prefix = /.:/subsys/oracle/names
names.nds.name_context = personnel.acme
names.nis.meta_map=sqlnet.maps
sqlnet.authentication_services=(none)
sqlnet.authentication_services=(beq, oss)
sqlnet.kerberos5_cc_name=/tmp/mycc
sqlnet.kerberos5_clockskew=600
sqlnet.kerberos5_conf=/tmp/mykrb.conf
sqlnet.kerberos5_realms=/tmp/mykrb.realms
sqlnet.kerberos5_keytab=/tmp/myv5srvtab
sqlnet.authentication_kerberos5_service=acme
sqlnet.authentication_gssapi_service=acme/asriniva.us.oracle.com@us.oracle.com
sqlnet.identix_fingerprint_method=oracle
sqlnet.identix_fingerprint_database=ofm
sqlnet.identix_fingerprint_database_user=<username>
sqlnet.identix_fingerprint_database_password=<password>
sqlnet.authentication_gssapi_service=acme/scott.us.oracle.com@us.oracle.com
oss.source.my_wallet
   =(source
       =(method=file)
        (method_data=/dve/asriniva/oss/wallet)
        ) 
oss.source.encrypted_private_key
   =(source
       =(method=oracle) 
        (method_data= 
           (username=andre_security_service) 
           (password=andre_security_service) 
           (sqlnet_address=andreoss)
        ) 
    ) 
oss.source.certificates
   =(source
       =(method=oracle) 
        (method_data= 
           (username=scott_security_service) 
           (password=ascott_security_service) 
           (sqlnet_address=andreoss)
        ) 
    ) 
oss.source.attributes
   =(source
       =(method=oracle) 
        (method_data= 
           (username=scott_oracle_security_service) 
           (password=scott_oracle_security_service) 
           (sqlnet_address=andreoss)
        ) 
    ) 
sqlnet.crypto_checksum_client = required
sqlnet.encryption_client = required
sqlnet.crypto_checksum_types_client = required
sqlnet.crypto_checksum_types_server = required
sqlnet.encryption_types_client = required
sqlnet.encryption_types_server = required
sqlnet.crypto_seed ="4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf"
sqlnet.crypto_checksum_server = required 
sqlnet.encryption_server = required
trace_level_client = admin
trace_directory_client = /oracle/network/trace
trace_file_client =  /oracle/network/trace/cli.trc
trace_unique_client = on
log_directory_client = /oracle/network/log
log_file_client = /oracle/network/log/sqlnet.log
log_directory_server = /oracle/network/trace
trace_directory_server = /oracle/network/trace
trace_file_server = /orace/network/trace/svr_<pid>.trc
trace_level_server = admin
use_dedicated_server = on
use_cman = true
tnsping.trace_directory = /oracle/network/trace
tnsping.trace_level = admin 
sqlnet.expire_time = 10
sqlnet.client_registration = <unique_id>
bequeath_detach = yes
automatic_ipc = off
disable_oob = on

Local Naming Configuration File (TNSNAMES.ORA)

The local naming configuration file (TNSNAMES.ORA) contains service aliases. The service aliases of databases are mapped to connect descriptors that describe their location on the network. The TNSNAMES.ORA is used by clients and distributed database servers to identify destinations and servers. TNSNAMES.ORA is located in $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows platforms. For more information on each individual parameter, see "Local Naming Parameters (TNSNAMES.ORA)".

tcpnew1 = (description=
              (source_route=yes)
              (address=(protocol=tcp)(port=1610)(host=spcstn))
              (address=(protocol=tcp)(port=1580)(host=spcstn)))
              (connect_data=(service=sales1))
          )

spx2tcp  = (description=
              (source_route=yes)
              (address=(protocol=spx)(service=orasrvc1))
              (address=(protocol=tcp)(port=1580)(host=spcstn)))
              (connect_data=(service_name=sales2))
          )

For more complex samples, see"Local Naming Parameters (TNSNAMES.ORA)".

Listener Configuration File (LISTENER.ORA)

The listener configuration file (LISTENER.ORA) contains the parameters that specify preferences for how a network listener behaves. LISTENER.ORA is located in $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows NT. For more information on each individual parameter, see "Listener Parameters (LISTENER.ORA)".

listener=
     
(address= # default tcp listening address
     
(protocol=tcp)
(port=1521)
(host=mudshark)

     )
(address= # non-default ipc listening address
     
(protocol=ipc)
(key=salesdb)

     )
      )
sid_list_listener=(sid_list=
     
(sid_desc=
     
(sid_name=sales)
(global_dbname=salesdb.mycompany)
(oracle_home=/private1/app/oracle/product/8.0.3)
(prespawn_max=20)
(prespawn_list=
     
(prespawn_desc=(protocol=tcp)(pool_size=2)(timeout=5))
(prespawn_desc=(protocol=ipc)(pool_size=3)(timeout=2))

     )	
      )
      )
trace_level_listener=admin
trace_directory_listener=/private1/app/oracle/product/8.0.2/network/trace
trace_file_listener=listener
logging_listener=on
log_directory_listener=/private1/app/oracle/product/8.0.2/network/log
log_file_listener=listener
save_config_on_stop_listener=true
startup_wait_time_listener=0






Note:



The SID_LIST_listener_name section is only required when making connections to a version 8 or version 7 database.

Oracle Names Server Configuration File (NAMES.ORA)

The Oracle Names server configuration file (NAMES.ORA) contains the parameters that specify the location, domain information, and optional configuration parameters for each Oracle Names server. NAMES.ORA is located in $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows NT. For more information on each individual parameter, see "Oracle Names Parameters (NAMES.ORA)".

names.addresses = (address=(protocol=tcp)(host=oranamesrvr0)(port=1575)) 
names.server_name = ons1.com 
names.domains = (domain_list= 
                  (domain= 
                     (name=com) 
                     (min_ttl=86400) 
                  ) 
                  (domain= 
                     (name=org) 
                     (min_ttl=86400) 
                  ) 
               ) 
names.admin_region= (region= 
     
(name= local_region.com) 
(type= rosdb) 
(userid = names) 
(password = names) 
(description =  
     
(address = (protocol = tcp)(host = nineva)(port = 1387)) 
(connect_data = (service = em)) 

     )
(docname = sbox) 
(version = 34619392) # 2.1.4 
(refresh = 14400) 
(retry = 600) 
(expire = 259200) 
      ) 
names.authority_required = false 
names.auto_refresh_expire = 259200 
names.auto_refresh_retry = 180 
names.cache_checkpoint_file = cache.ckp 
names.cache_checkpoint_interval = 7200 
names.config_checkpoint_file = config.ckp 
names.default_forwarders= 
 (forwarder_list= 
    (forwarder= 
       (name= rootserv1.com) 
       (address=(protocol=tcp)(port=42100)(host=roothost)))) 
names.default_forwarders_only = true 
names.domain_hints = 
 (hint_desc= 
    (hint_list= 
        (hint=(name=rootserv1.com) 
              (address=(protocol=tcp)(host=nineva)(port=42100))))) 
names.forwarding_available = true 
names.forwarding_desired = true 
names.log_directory = /oracle/network/log
names.log_file = names.log 
names.log_stats_interval = 3600
names.log_unique = false 
names.max_open_connections = 10 
names.max_reforwards = 2 
names.message_pool_start_size = 24 
names.no_modify_requests = false 
names.no_region_database = false 
names.password = 625926683431aa55 
names.reset_stats_interval = 3600 
names.region_checkpoint_file = reg.ckp 
names.trace_directory = /oracle/network/trace 
names.trace_file = names.trc 
names.trace_level = admin 
names.trace_unique = true

Oracle Connection Manager Configuration File (CMAN.ORA)

The Connection Manager configuration file (CMAN.ORA) contains the parameters that specify preferences for using Oracle Connection Manager. CMAN.ORA is located at $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows NT. For more information on each individual parameter, see "Oracle Connection Manager Parameters (CMAN.ORA)"

cman = (address = (protocol=tcp)(host=anyhost)(port=1630))
cman_admin = (address=(protocol=tcp)(host=anyhost)(port=1830))

cman_profile = (parameter_list=
     
(maximum_relays=512)
(log_level=1)
(tracing=yes)
(trace_directory=/oracle/network/trace)
(relay_statistics=yes)
(show_tns_info=yes)
(use_async_call=yes)
(authentication_level=0)

     )
# the following specifies a rule for single access control #
cman_rules = (rule_list= 
     
(rule=(src=spcstn)(dst=x)(srv=x)(act=accept)) 

     )

B Sample Configuration Files