Net8 Administrator's Guide
Release 8.1.5

A67440-01

Library

Product

Contents

Index

Prev Next

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



Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index