You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for sqlnet.ora


1 to 40 of 352 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Database Installation Guide for Linux, 11g Release 1 (11.1)

Glossary

sqlnet.ora fileAdvanced Security parameters The sqlnet.ora file resides in $ORACLE_HOME /network/admin.

Database Installation Guide for Microsoft Windows, 11g Release 1 (11.1)

Glossary

sqlnet.ora fileAdvanced Security parameters The sqlnet.ora file resides in ORACLE_BASE \\ ORACLE_HOME \\network\\admin.

Real Application Clusters Installation Guide for Linux and UNIX, 11g Release 1 (11.1)

Understanding the Oracle Real Application Clusters Installed Configuration

7.11 Net Services Profile (sqlnet.ora File)installed, and creates the Net Services profile, or sqlnet.ora file. By default, the sqlnet.ora file is … default sqlnet.ora file generated during installation, you also can find a sample sqlnet.ora file in … entries in the sqlnet.ora file: NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT) The parameter

Real Application Clusters Installation Guide for Microsoft Windows, 11g Release 1 (11.1)

Understanding the Oracle Real Application Clusters Installed Configuration

6.9 Net Services Profile (sqlnet.ora File)The sqlnet.ora file is automatically configured with: The computer's network domain This network … following is a sample sqlnet.ora file created during a preconfigured database configuration install … Database Net Services Administrator's Guide for further information about the sqlnet.ora file

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

More OCI Advanced Topics

Controlling ADR Creation and Disabling Fault Diagnosability Using sqlnet.orasqlnet.ora (the default is TRUE ): DIAG_ADR_ENABLED=FALSE DIAG_DDE_ENABLED=FALSE To turn off the OCI … parameter setting in sqlnet.ora: DIAG_SIGHANDLER_ENABLED=FALSE As noted previously, ADR_BASE is used in … sqlnet.ora to set the location of the ADR base. See Also: Oracle Database Net Services Reference Oracle

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

Diagnostic Parameters in sqlnet.orain the sqlnet.ora file are ignored when ADR is enabled. This section includes the following topics … : ADR Diagnostic Parameters in sqlnet.ora Non-ADR Diagnostic Parameters in sqlnet.ora

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

sqlnet.ora Profile ParametersThis section lists and describes the following sqlnet.ora file parameters: BEQUEATH_DETACH

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

5 Profile Parameters (sqlnet.ora)This chapter provides complete listing of the sqlnet.ora file configuration parameters. This … chapter includes the following topics: Overview of Profile Configuration File sqlnet.ora Profile Parameters Diagnostic Parameters in sqlnet.ora

Database Advanced Security Administrator's Guide, 11g Release 1 (11.1)

Authentication Parameters

B.2.1 sqlnet.ora File ParametersThe following sections describe the sqlnet.ora parameters that are used to specify RADIUS … sqlnet.ora file to set the path for the Java classes for that graphical interface, and to set the

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

ADR Diagnostic Parameters in sqlnet.oraThis section lists the parameters used when ADR is enabled (when DIAG_ADR_ENABLED is set to on ): ADR_BASE DIAG_ADR_ENABLED TRACE_LEVEL_CLIENT TRACE_LEVEL_SERVER TRACE_TIMESTAMP_CLIENT TRACE_TIMESTAMP_SERVER

Database Advanced Security Administrator's Guide, 11g Release 1 (11.1)

Data Encryption and Integrity Parameters

A.1 Sample sqlnet.ora FileThis section contains a sample sqlnet.ora configuration file for a set of clients with similar

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

Non-ADR Diagnostic Parameters in sqlnet.orasqlnet.ora This section lists the parameters used when ADR is disabled (when DIAG_ADR_ENABLED is set to

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

NAMES.DCE.PREFIXPurpose Use the parameter NAMES.DCE.PREFIX to specify the Distributed Computing Environment (DCE) cell name (prefix) to use for name lookups. Default /.:/subsys/oracle/names Example NAMES.DCE.PREFIX=/.:/subsys/oracle/names

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.EXPIRE_TIMEPurpose Use parameter SQLNET.EXPIRE_TIME to specify a time interval, in minutes, to send a probe to verify that client/server connections are active. Setting a value greater than 0 ensures that connections are not left open indefinitely, due to an abnormal client termination. If the probe finds a terminated connection, or a connection that is no longer in use, it returns an error, causing the server

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.INBOUND_CONNECT_TIMEOUTPurpose Use the SQLNET.INBOUND_CONNECT_TIMEOUT parameter to specify the time, in seconds, for a client to connect with the database server and provide the necessary authentication information. If the client fails to establish a connection and complete authentication in the time specified, then the database server terminates the connection. In addition, the database server logs the IP address of the

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.RADIUS_CHALLENGE_RESPONSEPurpose Use the parameter SQLNET.RADIUS_CHALLENGE_RESPONSE to turn challenge response on or off. Default off Values on | off Example SQLNET.RADIUS_CHALLENGE_RESPONSE=on

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SSL_CIPHER_SUITESPurpose Use the parameter SSL_CIPHER_SUITES to control what combination of encryption and data integrity is used by the Secure Sockets Layer (SSL). Default None Values See Also: Oracle Database Advanced Security Administrator's Guide for further information about cipher suite values Example SSL_CIPHER_SUITE=(ssl_rsa_with_rc4_138_md5)

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SSL_VERSIONPurpose Use the parameter SSL_VERSION to force the version of the SSL connection. Clients and database servers must use a compatible version. See Also: Oracle Database Advanced Security Administrator's Guide Default undetermined Values undetermined | 2.0 | 3.0 Example SSL_VERSION=2.0

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

NAMES.LDAP_PERSISTENT_SESSIONPurpose Use the NAMES.LDAP_PERSISTENT_SESSION parameter to specify whether the LDAP naming adapter should leave the session with the LDAP server open after name lookup is complete. Usage The parameter value is boolean. If set to TRUE, the connection to the LDAP server will be left open after the name lookup is complete; the connection will effectively stay open for the duration of the process. If

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SEND_BUF_SIZEPurpose Use the SEND_BUF_SIZE parameter to specify the buffer space limit for send operations of sessions. This parameter is supported by the TCP/IP, TCP/IP with SSL, and SDP protocols. Note: Additional protocols might support this parameter on certain operating systems. Refer to operating-system specific documentation for information about additional protocols that support this parameter. See Also:

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.AUTHENTICATION_KERBEROS5_SERVICEPurpose Use the parameter SQLNET.AUTHENTICATION_KERBEROS5_SERVICE to define the name of the service used to obtain a Kerberos service ticket. See Also: Oracle Database Advanced Security Administrator's Guide Default None Example SQLNET.AUTHENTICATION_KERBEROS5_SERVICE=oracle

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.CLIENT_REGISTRATIONPurpose Use the parameter SQLNET.CLIENT_REGISTRATION to set a unique identifier for this client computer. This identifier is passed to the listener with any connection request and is included in the Audit Trail. The identifier can be any alphanumeric string up to 128 characters long. Default None Example SQLNET.CLIENT_REGISTRATION=1432

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENTPurpose Use the parameter SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT to specify a list of crypto-checksum algorithms for the client to use. See Also: Oracle Database Advanced Security Administrator's Guide Default all available algorithms Values md5 for the RSA Data Security's MD5 algorithm sha1 for the Secure Hash algorithm Example SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(MD5)

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.ENCRYPTION_TYPES_CLIENTPurpose Use the parameter SQLNET.ENCRYPTION_TYPES_CLIENT to specify a list of encryption algorithms for the client to use. See Also: Oracle Database Advanced Security Administrator's Guide Default All available algorithms. Values One or more of the following: 3des112 for triple DES with a two-key (112 bit) option 3des168 for triple DES with a three-key (168 bit) option des for standard 56 bit key

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.KERBEROS5_KEYTABPurpose Use the parameter SQLNET.KERBEROS5_KEYTAB to specify the complete path name to the Kerberos principal/secret key mapping file, which is used to extract keys and decrypt incoming authentication information. See Also: Oracle Database Advanced Security Administrator's Guide Default /etc/v5srvtab on UNIX operating systems and c:\\krb5\\v5srvtab on Windows operating systems Example SQLNET.KERBEROS5_KEYTAB=/etc/v5srvtab

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.RADIUS_ALTERNATE_RETRIESPurpose Use the parameter SQLNET.RADIUS_ALTERNATE_RETRIES to specify the number of times the database server should resend messages to the alternate RADIUS server. See Also: Oracle Database Advanced Security Administrator's Guide Default 3 Example SQLNET.RADIUS_ALTERNATE_RETRIES=4

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.RADIUS_AUTHENTICATION_INTERFACEPurpose Use the parameter SQLNET.RADIUS_AUTHENTICATION_INTERFACE to specify the class containing the user interface used to interact with the user. See Also: Oracle Database Advanced Security Administrator's Guide Default DefaultRadiusInterface Example SQLNET.RADIUS_AUTHENTICATION_INTERFACE=DefaultRadiusInterface

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.RADIUS_AUTHENTICATION_PORTPurpose Use the parameter SQLNET.RADIUS_AUTHENTICATION_PORT to specify the listening port of the primary RADIUS server. See Also: Oracle Database Advanced Security Administrator's Guide Default 1645 Example SQLNET.RADIUS_AUTHENTICATION_PORT= 1667

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.RADIUS_SEND_ACCOUNTINGPurpose Use the parameter SQLNET.RADIUS_SEND_ACCOUNTING to turn accounting on and off. If enabled, packets are sent to the active RADIUS server at listening port plus one. The default port is 1646. See Also: Oracle Database Advanced Security Administrator's Guide Default off Values on | off Example SQLNET.RADIUS_SEND_ACCOUNTING=on

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SSL_CERT_FILEPurpose Use the parameter SSL_CRL_FILE to specify the name of the file where you can assemble the CRL of CAs for client authentication. This file contains the PEM-encoded CRL files, in order of preference. You can use this file alternatively or in additional to the SSL_CERT_PATH parameter. This parameter is only valid if SSL_CERT_REVOCATION is set to either requested or required. See Also: Oracle

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SSL_CERT_PATHPurpose Use the parameter SSL_CRL_PATH to specify the destination directory of the CRL of CA. The files in this directory are hashed symbolic links created by Oracle Wallet Manager. This parameter is only valid if SSL_CERT_REVOCATION is set to either requested or required. See Also: Oracle Database Advanced Security Administrator's Guide Default None

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

USE_CMANPurpose If set to true, the parameter USE_CMAN routes the client to a protocol address for an Oracle Connection Manager. The following example shows two address lists. While the first address list routes the client to an Oracle Connection Manager, the second address list routes the client directly to a listener. sales= (DESCRIPTION= (LOAD_BALANCE=on) (FAILOVER=on) (ADDRESS_LIST= (SOURCE_ROUTE=yes)

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

Overview of Profile Configuration FileThe sqlnet.ora file enables you to: Specify the client domain to append to unqualified names … parameters to restrict access to the database By default, sqlnet.ora is located in the $ORACLE_HOME … Windows operating systems. sqlnet.ora can also be stored in the directory specified by the TNS_ADMIN environment variable.

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

DEFAULT_SDU_SIZEsqlnet.ora file to ensure the same SDU size is used throughout a connection. When the configured

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

DISABLE_OOBPurpose If turned off, the parameter DISABLE_OOB enables Oracle Net to send and receive \"break\" messages using urgent data provided by the underlying protocol. If turned on, disables the ability to send and receive \"break\" messages using urgent data provided by the underlying protocol. Once enabled, this feature applies to all protocols used by this client. See Also: Operating system-specific

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

NAMES.LDAP_AUTHENTICATE_BINDPurpose Use the NAMES.LADP_AUTHENTICATE_BIND parameter to specify whether the LDAP naming adapter should attempt to authenticate using a specified wallet when it connects to the LDAP directory to resolve the name in the connect string. Usage The parameter value is boolean. If set to TRUE, the LDAP connection will be authenticated using a wallet whose location must be specified in the WALLET_LOCATION

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.ENCRYPTION_SERVERPurpose Use the parameter SQLNET.ENCRYPTION_SERVER to turn encryption on for the database server. See Also: Oracle Database Advanced Security Administrator's Guide Default accepted Values accepted to enable the security service if required or requested by the other side rejected to disable the security service, even if the required by the other side requested to enable the security service if the

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

SQLNET.KERBEROS5_REALMSPurpose Use the parameter SQLNET.KERBEROS5_REALMS to specify the complete path name to the Kerberos realm translation file, which provides a mapping from a host name or domain name to a realm. See Also: Oracle Database Advanced Security Administrator's Guide Default /krb5/krb.realms on UNIX operating systems and c:\\krb5\\krb.realms on Windows operating systems Example SQLNET.KERBEROS5_REALMS=/krb5/krb.realms

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

TCP.INVITED_NODESTCP. INVITED_NODES Purpose Use the parameter TCP.INVITED_NODES to specify which clients are allowed access to the database. This list takes precedence over the TCP.EXCLUDED_NODES parameter if both lists are present. Syntax TCP.INVITED_NODES=(hostname | ip_address, hostname | ip_address,...) Example TCP.INVITED_NODES=(sales.us.example.com, hr.us.example.com, 192.0.2.73)

Database Net Services Reference, 11g Release 1 (11.1)

Profile Parameters (sqlnet.ora)

TNSPING.TRACE_DIRECTORYPurpose Use the parameter TNSPING.TRACE_DIRECTORY to specify the destination directory for the TNSPING utility trace file, tnsping.trc. Default The $ORACLE_HOME/network/trace directory on UNIX operating systems and the %ORACLE_HOME%\\network\\trace directory on Windows operating systems Example TNSPING.TRACE_DIRECTORY=/oracle/traces