Oracle9i Net Services Reference Guide Release 1 (9.0.1) June 2001 Part No. A90155-01 Oracle9i Net Services Reference Guide, Release 1 (9.0.1) Part No. A90155-01 Copyright © 2001, Oracle Corporation. All rights reserved. Primary Author: Deborah Steiner Contributing Author: Henry Abrecht Contributors: Robert Achacoso, Jesse Anton, Mark Bauer, Pierre Baudin, David Chen, Howard Cohen, Toby Close, Stanley Guan, Harvey Eneman, Stella Kister, Shuvayu Kanjila, Cynthia Kibbe, Scot McKinley, Ed Miner, Peter Povinec, Richard Smith, Juliet Tran, and Norman Woo The Programs (which include both the software and documentation) contain proprietary information of Oracle Corporation; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs is prohibited. Theinformationcontainedinthisdocumentissubjecttochangewithoutnotice.Ifyoufindanyproblems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation. If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on behalf of the U.S. Government, the following notice is applicable: Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065. The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the Programs. Oracle, SQL*Net, and SQL*Plus are registered trademarks of Oracle Corporation. Net8, Oracle9i, Oracle8i, and Oracle8 are trademarks of Oracle Corporation. Other names may be trademarks of their respective owners. Contents Send Us Your Comments................................................................................................................. xxi Preface........................................................................................................................................................ xxiii Audience............................................................................................................................................. xxiv Organization....................................................................................................................................... xxiv Related Documentation..................................................................................................................... xxv Conventions........................................................................................................................................ xxvi Documentation Accessibility........................................................................................................... xxxi Part I Control Utilities 1 Listener Control Utility Listener Control Utility Overview.................................................................................................. 1-2 SET and SHOW Commands of the Listener Control Utility..................................................... 1-3 Distributed Operations...................................................................................................................... 1-4 Listener Security................................................................................................................................. 1-4 Listener Control Utility Commands................................................................................................ 1-5 CHANGE_PASSWORD.............................................................................................................. 1-5 EXIT................................................................................................................................................ 1-7 HELP.............................................................................................................................................. 1-8 QUIT............................................................................................................................................... 1-9 RELOAD...................................................................................................................................... 1-10 SAVE_CONFIG........................................................................................................................... 1-11 SERVICES.................................................................................................................................... 1-12 SET................................................................................................................................................ 1-14 iii SET CURRENT_LISTENER....................................................................................................... 1-16 SET DISPLAYMODE.................................................................................................................. 1-17 SET LOG_DIRECTORY............................................................................................................. 1-18 SET LOG_FILE............................................................................................................................ 1-19 SET LOG_STATUS..................................................................................................................... 1-20 SET PASSWORD......................................................................................................................... 1-21 SET SAVE_CONFIG_ON_STOP.............................................................................................. 1-22 SET STARTUP_WAITTIME...................................................................................................... 1-23 SET TRC_DIRECTORY.............................................................................................................. 1-24 SET TRC_FILE............................................................................................................................. 1-25 SET TRC_LEVEL......................................................................................................................... 1-26 SHOW........................................................................................................................................... 1-27 SPAWN........................................................................................................................................ 1-29 START........................................................................................................................................... 1-30 STATUS........................................................................................................................................ 1-32 STOP............................................................................................................................................. 1-34 TRACE.......................................................................................................................................... 1-35 VERSION..................................................................................................................................... 1-36 2 Oracle Connection Manager Control Utility Oracle Connection Manager Control Utility Overview.............................................................. 2-2 SET Commands of Oracle Connection Manager Control Utility.............................................. 2-3 Distributed Operations...................................................................................................................... 2-4 Oracle Connection Manager Control Utility Commands........................................................... 2-5 ACCEPT_CONNECTIONS......................................................................................................... 2-5 CLOSE_RELAY............................................................................................................................. 2-6 EXIT................................................................................................................................................ 2-7 HELP............................................................................................................................................... 2-8 QUIT............................................................................................................................................... 2-9 SET................................................................................................................................................ 2-10 SET AUTHENTICATION_LEVEL........................................................................................... 2-11 SET DISPLAYMODE.................................................................................................................. 2-12 SET LOG_LEVEL........................................................................................................................ 2-13 SET RELAY_STATISTICS.......................................................................................................... 2-14 SHOW........................................................................................................................................... 2-15 SHOW ADDRESS....................................................................................................................... 2-16 SHOW ALL.................................................................................................................................. 2-17 iv SHOW DISPLAYMODE............................................................................................................ 2-19 SHOW PROFILE......................................................................................................................... 2-20 SHOW RELAY............................................................................................................................ 2-21 SHOW RULES............................................................................................................................. 2-23 SHUTDOWN............................................................................................................................... 2-24 START.......................................................................................................................................... 2-25 STATS........................................................................................................................................... 2-27 STATUS........................................................................................................................................ 2-29 STOP............................................................................................................................................. 2-31 STOPNOW................................................................................................................................... 2-32 VERSION..................................................................................................................................... 2-33 3 Oracle Names Control Utility Oracle Names Control Utility Overview........................................................................................ 3-2 SET and SHOW Commands of the Oracle Names Control Utility........................................... 3-3 Distributed Operations...................................................................................................................... 3-3 Oracle Names Server Security.......................................................................................................... 3-4 Confirmation Mode in the Oracle Names Control Utility.......................................................... 3-5 Oracle Names Control Utility Commands..................................................................................... 3-5 DELEGATE_DOMAIN................................................................................................................ 3-5 DOMAIN_HINT........................................................................................................................... 3-6 DUMP_LDAP................................................................................................................................ 3-8 DUMP_TNSNAMES.................................................................................................................. 3-11 EXIT.............................................................................................................................................. 3-12 FLUSH.......................................................................................................................................... 3-13 FLUSH_NAME........................................................................................................................... 3-14 HELP............................................................................................................................................ 3-15 LIST_DELEGATED.................................................................................................................... 3-16 LIST_DOMAINS......................................................................................................................... 3-18 LIST_OBJECTS............................................................................................................................ 3-19 LOAD_TNSNAMES................................................................................................................... 3-20 LOG_STATS................................................................................................................................ 3-22 PASSWORD................................................................................................................................ 3-23 PING............................................................................................................................................. 3-24 QUERY......................................................................................................................................... 3-25 QUIT............................................................................................................................................. 3-27 REGISTER.................................................................................................................................... 3-28 v REGISTER_NS............................................................................................................................. 3-30 RELOAD...................................................................................................................................... 3-32 REORDER_NS............................................................................................................................. 3-33 REPEAT........................................................................................................................................ 3-35 RESET_STATS............................................................................................................................. 3-37 RESTART..................................................................................................................................... 3-38 SAVE_CONFIG........................................................................................................................... 3-39 SET................................................................................................................................................ 3-40 SET CACHE_CHECKPOINT_INTERVAL............................................................................. 3-41 SET DEFAULT_DOMAIN......................................................................................................... 3-42 SET FORWARDING_AVAILABLE......................................................................................... 3-43 SET LOG_FILE_NAME.............................................................................................................. 3-45 SET LOG_STATS_INTERVAL.................................................................................................. 3-46 SET NAMESCTL_TRACE_LEVEL........................................................................................... 3-47 SET PASSWORD......................................................................................................................... 3-49 SET REQUESTS_ENABLED...................................................................................................... 3-50 SET RESET_STATS_INTERVAL.............................................................................................. 3-51 SET SAVE_CONFIG_INTERVAL............................................................................................ 3-52 SET SAVE_CONFIG_ON_STOP.............................................................................................. 3-53 SET SERVER................................................................................................................................ 3-54 SET TRACE_FILE_NAME......................................................................................................... 3-55 SET TRACE_LEVEL................................................................................................................... 3-56 SHOW........................................................................................................................................... 3-57 SHOW CACHE_CHECKPOINT_INTERVAL....................................................................... 3-59 SHOW DEFAULT_DOMAIN................................................................................................... 3-60 SHOW FORWARDING_AVAILABLE.................................................................................... 3-61 SHOW LOG_FILE_NAME........................................................................................................ 3-62 SHOW LOG_STATS_INTERVAL............................................................................................ 3-63 SHOW NAMESCTL_TRACE_LEVEL..................................................................................... 3-64 SHOW REQUESTS_ENABLED................................................................................................ 3-65 SHOW RESETS_STATS_INTERVAL....................................................................................... 3-66 SHOW SAVE_CONFIG_INTERVAL....................................................................................... 3-67 SHOW SAVE_CONFIG_ON_STOP......................................................................................... 3-68 SHOW SERVER........................................................................................................................... 3-69 SHOW STATUS.......................................................................................................................... 3-70 vi SHOW SYSTEM_QUERIES....................................................................................................... 3-71 SHOW TRACE_FILE_NAME................................................................................................... 3-72 SHOW TRACE_LEVEL............................................................................................................. 3-73 SHOW VERSION........................................................................................................................ 3-74 SHUTDOWN............................................................................................................................... 3-75 START.......................................................................................................................................... 3-76 START_CLIENT_CACHE......................................................................................................... 3-78 STARTUP..................................................................................................................................... 3-79 STATUS........................................................................................................................................ 3-80 STOP............................................................................................................................................. 3-81 TIMED_QUERY.......................................................................................................................... 3-82 UNREGISTER............................................................................................................................. 3-84 UNREGISTER_NS...................................................................................................................... 3-86 VERSION..................................................................................................................................... 3-88 Part II Configuration Parameters 4 Syntax Rules for Configuration Files Configuration File Syntax Overview.............................................................................................. 4-2 Further Syntax Rules for Configuration Files............................................................................... 4-3 Network Character Set....................................................................................................................... 4-4 Character Set........................................................................................................................................ 4-4 5 Protocol Address Configuration ADDRESSes and ADDRESS_LISTs............................................................................................... 5-2 ADDRESS...................................................................................................................................... 5-2 ADDRESS_LIST............................................................................................................................ 5-2 Protocol Parameters............................................................................................................................ 5-3 Recommended Port Numbers.......................................................................................................... 5-6 Port Number Limitations.................................................................................................................. 5-7 vii 6 Profile Parameters (sqlnet.ora) Overview of Profile Configuration File.......................................................................................... 6-2 Profile Parameters............................................................................................................................... 6-3 BEQUEATH_DETACH................................................................................................................ 6-3 DAEMON.TRACE_DIRECTORY............................................................................................... 6-3 DAEMON.TRACE_LEVEL......................................................................................................... 6-4 DAEMON.TRACE_MASK.......................................................................................................... 6-4 DISABLE_OOB.............................................................................................................................. 6-5 LOG_DIRECTORY_CLIENT...................................................................................................... 6-5 LOG_DIRECTORY_SERVER...................................................................................................... 6-6 LOG_FILE_CLIENT..................................................................................................................... 6-6 LOG_FILE_SERVER..................................................................................................................... 6-6 NAMES.CONNECT_TIMEOUT................................................................................................ 6-7 NAMES.DCE.PREFIX.................................................................................................................. 6-7 NAMES.DEFAULT_DOMAIN................................................................................................... 6-8 NAMES.DIRECTORY_PATH..................................................................................................... 6-8 NAMES.INITIAL_RETRY_TIMEOUT..................................................................................... 6-10 NAMES.MAX_OPEN_CONNECTIONS................................................................................ 6-10 NAMES.MESSAGE_POOL_START_SIZE.............................................................................. 6-11 NAMES.NIS.META_MAP......................................................................................................... 6-11 NAMES.PREFERRED_SERVERS............................................................................................. 6-12 NAMES.REQUEST_RETRIES................................................................................................... 6-12 NAMESCTL.INTERNAL_ENCRYPT_PASSWORD............................................................. 6-13 NAMESCTL.INTERNAL_USE ................................................................................................ 6-13 NAMESCTL.NO_INITIAL_SERVER....................................................................................... 6-14 NAMESCTL.NOCONFIRM...................................................................................................... 6-14 NAMESCTL.SERVER_PASSWORD........................................................................................ 6-15 NAMESCTL.TRACE_LEVEL.................................................................................................... 6-15 NAMESCTL.TRACE_FILE........................................................................................................ 6-16 NAMESCTL.TRACE_DIRECTORY......................................................................................... 6-16 NAMESCTL.TRACE_UNIQUE................................................................................................ 6-17 SQLNET.AUTHENTICATION_KERBEROS5_SERVICE..................................................... 6-17 SQLNET.AUTHENTICATION_GSSAPI_SERVICE.............................................................. 6-18 SQLNET.AUTHENTICATION_SERVICES............................................................................ 6-18 SQLNET.CLIENT_REGISTRATION....................................................................................... 6-19 viii SQLNET.CRYPTO_CHECKSUM_CLIENT............................................................................ 6-19 SQLNET.CRYPTO_CHECKSUM_SERVER........................................................................... 6-20 SQLNET_CRYPTO_CHECKSUM_TYPE_CLIENT............................................................... 6-21 SQLNET_CRYPTO_CHECKSUM_TYPE_SERVER.............................................................. 6-21 SQLNET.CRYPTO_SEED.......................................................................................................... 6-22 SQLNET.ENCRYPTION_CLIENT........................................................................................... 6-22 SQLNET.ENCRYPTION_SERVER.......................................................................................... 6-23 SQLNET.ENCRYPTION_TYPES_CLIENT............................................................................. 6-24 SQLNET.ENCRYPTION_TYPES_SERVER............................................................................ 6-25 SQLNET.EXPIRE_TIME............................................................................................................ 6-26 SQLNET.KERBEROS5_CC_NAME......................................................................................... 6-26 SQLNET.KERBEROS5_CLOCKSKEW.................................................................................... 6-27 SQLNET.KERBEROS5_CONF.................................................................................................. 6-27 SQLNET.KERBEROS5_KEYTAB............................................................................................. 6-28 SQLNET.KERBEROS5_REALMS............................................................................................. 6-28 SQLNET.RADIUS_ALTERNATE............................................................................................ 6-29 SQLNET.RADIUS_ALTERNATE_PORT................................................................................ 6-29 SQLNET.RADIUS_ALTERNATE_RETRIES.......................................................................... 6-30 SQLNET.RADIUS_AUTHENTICATION............................................................................... 6-30 SQLNET.RADIUS_AUTHENTICATION_INTERFACE...................................................... 6-31 SQLNET.RADIUS_AUTHENTICATION_PORT.................................................................. 6-31 SQLNET.RADIUS_AUTHENTICATION_RETRIES............................................................. 6-32 SQLNET.RADIUS_AUTHENTICATION_TIMEOUT.......................................................... 6-32 SQLNET.RADIUS_CHALLENGE_RESPONSE..................................................................... 6-33 SQLNET.RADIUS_SECRET...................................................................................................... 6-33 SQLNET.RADIUS_SEND_ACCOUNTING........................................................................... 6-34 SSL_CIPHER_SUITES................................................................................................................ 6-34 SSL_CLIENT_AUTHENTICATION........................................................................................ 6-35 SSL_SERVER_DN_MATCH..................................................................................................... 6-35 SSL_VERSION............................................................................................................................. 6-36 TCP.EXCLUDED_NODES........................................................................................................ 6-37 TCP.INVITED_NODES............................................................................................................. 6-37 TCP.VALIDNODE_CHECKING............................................................................................. 6-38 TCP.NODELAY.......................................................................................................................... 6-38 TNSPING.TRACE_DIRECTORY............................................................................................. 6-39 TNSPING.TRACE_LEVEL........................................................................................................ 6-39 ix TRACE_DIRECTORY_CLIENT................................................................................................ 6-40 TRACE_DIRECTORY_SERVER............................................................................................... 6-40 TRACE_FILE_CLIENT.............................................................................................................. 6-41 TRACE_FILE_SERVER.............................................................................................................. 6-41 TRACE_FILELEN_CLIENT...................................................................................................... 6-42 TRACE_FILELEN_SERVER...................................................................................................... 6-42 TRACE_FILENO_CLIENT........................................................................................................ 6-43 TRACE_FILENO_SERVER........................................................................................................ 6-43 TRACE_LEVEL_CLIENT.......................................................................................................... 6-44 TRACE_LEVEL_SERVER.......................................................................................................... 6-45 TRACE_TIMESTAMP_CLIENT............................................................................................... 6-45 TRACE_TIMESTAMP_SERVER............................................................................................... 6-46 TRACE_UNIQUE_CLIENT...................................................................................................... 6-46 USE_CMAN................................................................................................................................. 6-47 USE_DEDICATED_SERVER..................................................................................................... 6-48 VI_RECEIVE_BUFFERS............................................................................................................. 6-49 VI_SEND_BUFFERS................................................................................................................... 6-49 WALLET_LOCATION............................................................................................................... 6-50 7 Local Naming Parameters (tnsnames.ora) Overview of Local Naming Parameters.......................................................................................... 7-2 General Syntax of tnsnames.ora....................................................................................................... 7-2 Multiple Descriptions in tnsnames.ora.......................................................................................... 7-3 Multiple Address Lists in tnsnames.ora......................................................................................... 7-4 Connect-Time Failover and Client Load Balancing with Oracle Connection Managers...... 7-5 Local Naming Parameters.................................................................................................................. 7-7 Connect Descriptor Descriptions................................................................................................ 7-7 DESCRIPTION....................................................................................................................... 7-7 DESCRIPTION_LIST............................................................................................................. 7-8 Protocol Address Section............................................................................................................. 7-8 ADDRESS............................................................................................................................... 7-8 ADDRESS_LIST..................................................................................................................... 7-9 x