Release 8.0.3
A51576_01
 Library |
 Product |
 Contents |
 Index |
| Net8(TM) Administrator's Guide Release 8.0.3 A51576_01 |
|
This appendix provides sample configuration files used in Net8. These files include:
This appendix is intended for use as a reference only.
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
The local names 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 names 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) )
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) sid_list_listener=(sid_list=(protocol=tcp) (port=1521) (host=mudshark)) (address= # non-default ipc listening address(protocol=ipc) (key=salesdb))(sid_desc=) 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(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)))
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 =) 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(address = (protocol = tcp)(host = nineva)(port = 1387)) (connect_data = (sid = em))) (docname = sbox) (version = 34619392) 2.1.4 (refresh = 14400) (retry = 600) (expire = 259200)
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) (relay_statistics=yes) (show_tns_info=yes) (use_async_call=yes) (authentication_level=1)) # the following specifies a rule for single access control # cman_rules = (rule_list=(rule=(src=spcstn)(dst=x)(srv=x)(act=accept)))
