7.2 Restricted Parameters and Values in Connect Descriptors

These are the restrictions on the parameter names and values that can appear in the connect_descriptor value.

Allowed Naming-Restricted Parameters

All parameters that can potentially access the file-system are restricted to avoid issues, especially in multi-tenant, middle-tier environments. This is because a tenant can potentially add references to a wallet of another tenant. All the parameters that may cause process-level changes or issues with unintended resource usage are also restricted.

This is a list of all left-hand side naming parameters (before =) allowed as a connect_descriptor value in Azure App Configuration or Oracle Cloud Infrastructure (OCI) Object Storage JSON file:

Parameter
PROTOCOL
METHOD
DESCRIPTION_LIST
DESCRIPTION
ADDRESS_LIST
ADDRESS
CONNECT_DATA
HOST
PORT
SERVICE_NAME
SID
SERVER
INSTANCE_NAME
TRANSPORT_CONNECT_TIMEOUT
RECV_TIMEOUT
CONNECT_TIMEOUT
ENABLE
EXPIRE_TIME
FAILOVER
LOAD_BALANCE
SDU
RECV_BUF_SIZE
SEND_BUF_SIZE
RETRY_COUNT
RETRY_DELAY
COMPRESSION
COMPRESSION_LEVELS
SECURITY
SSL_SERVER_CERT_DN
SSL_SERVER_DN_MATCH
IGNORE_ANO_ENCRYPTION_FOR_TCPS
HTTPS_PROXY
HTTPS_PROXY_PORT
CONNECTION_ID_PREFIX
WALLET_LOCATION
POOL_PURITY
POOL_CONNECTION_CLASS
POOL_BOUNDARY
OCI
STATEMENT_CACHE_SIZE
PREFETCH_ROWS
SESSION_POOL
MIN
MAX
INCREMENT
LOB_PREFETCH_SIZE
MAX_LIFETIME_SESSION
MAX_USE_SESSION
INACTIVITY_TIMEOUT
TYPE_OF_SERVICE
FAILOVER_MODE
GLOBAL_NAME
HS
RDB_DATABASE
SHARDING_KEY
SUPER_SHARDING_KEY
COLOCATION_TAG
SERVICE_TAG
POOL_NAME

Allowed Values for Naming-Restricted Parameters

For some of the naming-restricted parameter names, not all values are allowed on the right-hand side (after =).

Note the following restrictions on the values that you can specify.

Parameter	Restriction
PROTOCOL	BEQ or Fork capability is not allowed. The allowed values are: TCP TCPS WSS EXADIRECT
WALLET_LOCATION	For the METHOD sub-parameter, the allowed values are: VAULT-OCI VAULT-AZURE SYSTEM

Note:

To disable the preceding naming restrictions, set the sqlnet.ora parameter or environment variable NAMES.CLOUD_NAMING_RESTRICTIONS to FALSE. The default value for this parameter is TRUE.