C
Sample Configuration Files

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

• Section C.1, "Profile (SQLNET.ORA)"
• Section C.2, "Local Naming Configuration File (TNSNAMES.ORA)"
• Section C.3, "Listener Configuration File (LISTENER.ORA)"
• Section C.4, "Names Server Configuration File (NAMES.ORA)"
• Section C.5, "Oracle Connection Manager Configuration File (CMAN.ORA)"

This appendix is intended for use as a reference only.

C.1 Profile (SQLNET.ORA)

A profile (SQLNET.ORA) contains the parameters that specify preferences for how a client or server uses Net8 features. For more information on each individual parameter, refer to "Profile Parameters (SQLNET.ORA)", in Appendix B, "Configuration Parameters".

names.default_domain = world
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

C.2 Local Naming Configuration File (TNSNAMES.ORA)

The local naming configuration file (TNSNAMES.ORA) contains the names and addresses of services on the network. The service names of databases are mapped to connect descriptors that describe their location on the network. The local naming configuration file (TNSNAMES.ORA) is used by clients and distributed database servers to identify destinations and servers. For more information on each individual parameter, refer to "Local Naming Parameters (TNSNAMES.ORA)", in Appendix B, "Configuration Parameters".

tcpnew1 = (description=
              (address_list=
                  (address=(protocol=tcp)(port=1610)(host=spcstn))
                  (address=(protocol=tcp)(port=1580)(host=spcstn)))
              (connect_data=(sid=cman))
              (source_route=yes)
          )

spx2tcp  = (description=
              (address_list=
                  (address=(protocol=spx)(service=orasrvc1))
                  (address=(protocol=tcp)(port=1580)(host=spcstn)))
              (connect_data=(sid=cman))
              (source_route=yes)
          )

C.3 Listener Configuration File (LISTENER.ORA)

The listener configuration file (LISTENER.ORA) contains the parameters that specify preferences for how a network listener behaves. For more information on each individual parameter, refer to "Listener Parameters (LISTENER.ORA)", in Appendix B, "Configuration Parameters".

listener=(address_list=
 (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

C.4 Names Server Configuration File (NAMES.ORA)

The Names Server configuration file (NAMES.ORA) contains the parameters that specify preferences for each Names Server. For more information on each individual parameter, refer to "Oracle Names Parameters (NAMES.ORA)", in Appendix B, "Configuration Parameters".

names.addresses = (address=(protocol=tcp)(host=oranamesrvr0)(port=1575))
names.server_name = ons1.world
names.domains = (domain_list=
                  (domain=
                     (name=world)
                     (min_ttl=86400)
                  )
                  (domain=
                     (name=lostworld)
                     (min_ttl=86400)
                  )
                )
names.admin_region= (region=
   (name= local_region.world)
   (type= rosdb)
   (userid = names)
   (password = names)
   (description =
      (address = (protocol = tcp)(host = nineva)(port = 1387))
      (connect_data = (sid = 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 = cache.ckp
names.default_forwarders=
   (forwarder_list=
      (forwarder= (name=rootserv1.world)
      (address=(protocol=tcp)(port=42100)(host=roothost))))
names.default_forwarders_only = true
names.domain_hints = (hint_desc=
   (hint_list= (hint=(name=rootserv1.world)
   (address=(protocol=tcp)(host=nineva)(port=42100)))))
names.domains_dns_aligned = na
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

C.5 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. For more information on each individual parameter, refer to "Oracle Connection Manager Parameters (CMAN.ORA)", in Appendix B, "Configuration Parameters".

cman = (address_list= 
           (address = (protocol=tcp)(host=anyhost)(port=1610))
           (address = (protocol=tcp)(host=anyhost)(port=1620))
)
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)) 

)

---