database-net-services-reference

Oracle® Database
Database Net Services Reference
19c
E96314-15
February 2023

Oracle Database Database Net Services Reference, 19c
E96314-15
Copyright © 2002, 2023, Oracle and/or its affiliates.
Primary Author: Binika Kumar
Contributing Authors: Douglas Williams, Prakash Jashnani
Contributors: Abhishek Dadhich, Alan Williams, Anita Patel, Bhaskar Mathur, Ching Tai, Christopher Jones,
David Lin, Feroz Khan, Hector Pujol, Jean Zeng, Kant Patel, Kevin Neel, Krishna Itikarlapalli, Mark Dilman,
Misaki Miyashita, Murali Purayathu, Norman Woo, Peter Knaggs, Robert Achacoso, Santanu Datta,
Saravanakumar Ramasubramanian, Sarma Namuduri, Scot McKinley, Sharad Chandran R, Srinivas Pamu,
Steve Ding, Sudeep Reguna, Sweta Mogra, Thanigai Nallathambi, Yi Ouyang
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software, software documentation, data (as defined in the Federal Acquisition Regulation), or related
documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S.
Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,
any programs embedded, installed, or activated on delivered hardware, and modifications of such programs)
and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end
users are "commercial computer software," "commercial computer software documentation," or "limited rights
data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental
regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation
of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated
software, any programs embedded, installed, or activated on delivered hardware, and modifications of such
programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and
limitations specified in the license contained in the applicable contract. The terms governing the U.S.
Government's use of Oracle cloud services are defined by the applicable contract for such services. No other
rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications.
It is not developed or intended for use in any inherently dangerous applications, including applications that
may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you
shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its
safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this
software or hardware in dangerous applications.
Oracle®, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may be
trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are
used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,
and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered
trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise
set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be
responsible for any loss, costs, or damages incurred due to your access to or use of third-party content,
products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents
Preface
Audience xv
Documentation Accessibility xv
Diversity and Inclusion xv
Related Documents xvi
Conventions xvi
Changes in This Release for Oracle Database Net Services Reference
New Features xvii
Deprecated Features xx
1 Listener Control Utility
1.1 Listener Control Utility Overview 1-1
1.2 SET and SHOW Commands of the Listener Control utility 1-2
1.3 Distributed Operations 1-3
1.4 Oracle Net Listener Security 1-3
1.5 Listener Control Utility Commands 1-3
1.5.1 EXIT 1-5
1.5.2 HELP 1-6
1.5.3 QUIT 1-7
1.5.4 RELOAD 1-7
1.5.5 SAVE_CONFIG 1-8
1.5.6 SERVICES 1-9
1.5.7 SET 1-10
1.5.8 SET CURRENT_LISTENER 1-12
1.5.9 SET DISPLAYMODE 1-12
1.5.10 SET INBOUND_CONNECT_TIMEOUT 1-13
1.5.11 SET LOG_DIRECTORY 1-14
1.5.12 SET LOG_FILE 1-15
1.5.13 SET LOG_STATUS 1-15
1.5.14 SET SAVE_CONFIG_ON_STOP 1-16
iii

1.5.15 SET TRC_DIRECTORY 1-17
1.5.16 SET TRC_FILE 1-18
1.5.17 SET TRC_LEVEL 1-19
1.5.18 SHOW 1-20
1.5.19 SPAWN 1-21
1.5.20 START 1-22
1.5.21 STATUS 1-23
1.5.22 STOP 1-25
1.5.23 TRACE 1-26
1.5.24 VERSION 1-27
2 Oracle Connection Manager Control Utility
2.1 Command Modes and Syntax 2-1
2.2 Oracle Connection Manager Control Utility Overview 2-3
2.3 Oracle Connection Manager Control Utility Commands 2-3
2.3.1 ADMINISTER 2-4
2.3.2 CLOSE CONNECTIONS 2-5
2.3.3 EXIT 2-7
2.3.4 HELP 2-7
2.3.5 QUIT 2-8
2.3.6 RELOAD 2-9
2.3.7 RESUME GATEWAYS 2-9
2.3.8 SAVE_PASSWD 2-10
2.3.9 SET 2-10
2.3.10 SET ASO_AUTHENTICATION_FILTER 2-11
2.3.11 SET CONNECTION_STATISTICS 2-12
2.3.12 SET EVENT 2-12
2.3.13 SET IDLE_TIMEOUT 2-13
2.3.14 SET INBOUND_CONNECT_TIMEOUT 2-14
2.3.15 SET LOG_DIRECTORY 2-14
2.3.16 SET LOG_LEVEL 2-15
2.3.17 SET OUTBOUND_CONNECT_TIMEOUT 2-16
2.3.18 SET PASSWORD 2-16
2.3.19 SET SESSION_TIMEOUT 2-17
2.3.20 SET TRACE_DIRECTORY 2-18
2.3.21 SET TRACE_LEVEL 2-18
2.3.22 SHOW 2-19
2.3.23 SHOW ALL 2-20
2.3.24 SHOW CONNECTIONS 2-21
2.3.25 SHOW DEFAULTS 2-23
iv

2.3.26 SHOW EVENTS 2-24
2.3.27 SHOW GATEWAYS 2-25
2.3.28 SHOW PARAMETERS 2-25
2.3.29 SHOW RULES 2-26
2.3.30 SHOW SERVICES 2-28
2.3.31 SHOW STATUS 2-28
2.3.32 SHOW VERSION 2-29
2.3.33 SHUTDOWN 2-29
2.3.34 STARTUP 2-30
2.3.35 SUSPEND GATEWAY 2-31
3 Syntax Rules for Configuration Files
3.1 Overview of Configuration File Syntax 3-1
3.2 Syntax Rules for Configuration Files 3-2
3.3 Network Character Set for Keywords 3-3
3.4 Character Set for Listener and Net Service Names 3-3
4 Protocol Address Configuration
4.1 Protocol Addresses 4-1
4.1.1 ADDRESS 4-1
4.1.2 ADDRESS_LIST 4-2
4.2 Protocol Parameters 4-2
4.3 Recommended Port Numbers 4-4
4.4 Port Number Limitations 4-4
5 Parameters for the sqlnet.ora File
5.1 Overview of Profile Configuration File 5-1
5.2 sqlnet.ora Profile Parameters 5-2
5.2.1 ACCEPT_MD5_CERTS 5-7
5.2.2 ACCEPT_SHA1_CERTS 5-8
5.2.3 ADD_SSLV3_TO_DEFAULT 5-8
5.2.4 BEQUEATH_DETACH 5-8
5.2.5 DEFAULT_SDU_SIZE 5-9
5.2.6 DISABLE_INTERRUPT 5-9
5.2.7 DISABLE_OOB 5-10
5.2.8 DISABLE_OOB_AUTO 5-10
5.2.9 EXADIRECT_FLOW_CONTROL 5-11
5.2.10 EXADIRECT_RECVPOLL 5-11
5.2.11 HTTPS_SSL_VERSION 5-11
v