Oracle Connection Manager Parameters

This chapter provides a complete listing of the cman.ora file configuration parameters.

By default, the cman.ora file is located in the ORACLE_HOME/network/admin directory.

The cman.ora file can also be stored in the following locations:

1. The directory specified by the TNS_ADMIN environment variable or registry value.
2. On Linux and UNIX operating systems, the global configuration directory. For example, on the Oracle Solaris operating system, this directory is /var/opt/oracle.

Example 8-1 Sample cman.ora File

CMAN=

  (CONFIGURATION=

    (ADDRESS=(PROTOCOL=tcp)(HOST=proxysvr)(PORT=1521))

    (RULE_LIST=

      (RULE=(SRC=192.0.2.32/27)(DST=sales-server)(SRV=*)(ACT=accept))

        (ACTION_LIST=(AUT=on)(MCT=120)(MIT=30)))

      (RULE=(SRC=foo)(DST=hr-server)(SRV=cmon)(ACT=accept)))

    (PARAMETER_LIST=

      (MAX_GATEWAY_PROCESSES=8)

      (MIN_GATEWAY_PRCESSSES=3)

      (DIAG_ADR_ENABLED=ON)

      (ADR_BASE=/oracle/log)))

cman.ora分为三部分：

1. Listening address

The ADDRESS parameter is required.

(ADDRESS=(PROTOCOL=protocol)(HOST=host_name)(PORT=port_number)

可以监听多种协议，这样就可以进行协议转化：

CMAN_ALIAS=

 (configuration=

 (address_list=

 (address=(protocol=TCP)(host=a.b.c.d)(port=12522))

 (address=(protocol=TCPS)(host=a.b.c.d)(port=12523))

...

Example

(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))

1. Rule list

Preceded by RULE_LIST=. The RULE parameter is required.

类型防火墙设置A rule list specifies which connections are accepted, rejected, or dropped.

If no rules are specified, then all connections are rejected.

The source and destination can be a host name, IP address, or subnet mask.

There must be at least one rule for client connections and one rule for CMCTL connections.

IP不支持部分通配，要以支持子网/nn的形式

Oracle Connection Manager does not support wildcards for partial IP addresses. If you use a wildcard, then use it in place of a full IP address. The IP address of the client may, for example, be (SRC=*). Oracle Connection Manager supports only the /nn notation for subnet addresses

语法：

(RULE_LIST=

  (RULE=

    (SRC=host)

    (DST=host)

    (SRV=service_name)

    (ACT={accept|reject|drop})

    (ACTION_LIST=AUT={on|off}

    ((CONN_STATS={yes|no})(MCT=time)(MIT=time)(MOCT=time)))

  (RULE= ...))

Action_list用于设置一些参数，它会覆盖Parameter list的全局设置

ACTION_LIST: The rule-level parameter settings for some parameters

AUT: Oracle Database security authentication on client side.

CONN_STATS: Log input and output statistics.

MCT: Maximum connect time.

MIT: Maximum idle timeout.

MOCT: Maximum outbound connect time.

Example

(RULE_LIST=

  (RULE=

    (SRC=client1-pc)

    (DST=sales-server)

    (SRV=sales.us.example.com)

    (ACT=reject))

  (RULE=

    (SRC=192.0.2.45)

    (DST=192.0.2.200)

    (SRV=db1)

    (ACT=accept))

  (RULE=

    (SRC=sale-rep)

    (DST=sales1-server)

    (SRV=cmon)

    (ACT=accept)))

1. Parameter list

1. MAX_CMCTL_SESSIONS= Any positive number. The default value is 4.

To specify the maximum number of concurrent local or remote sessions of the Oracle Connection Manager control utility allowable for a given instance.

One of the sessions must be a local session.

1. MAX_CONNECTIONS= A value between 1 and 1024. The default value is 256.

To specify the maximum number of connection slots that a gateway process can handle.

Any number in the range of 1 to 1024.

1. MAX_ALL_CONNECTIONS

To specify the maximum number of concurrent registration and client connection sessions that can be supported by Oracle Connection Manager.

This number includes registration connections from databases, and ongoing client connection establishment requests. After a connection is established, the clients do not maintain a connection to the listener. This limit only applies to client connections that are in the initial connection establishment phase from a listener perspective.

1. MAX_GATEWAY_PROCESSES= Any number greater than the minimum number of gateway processes up to 64. The default value is 16.

To specify the maximum number of gateway processes that an instance of Oracle Connection Manager supports.

1. MIN_GATEWAY_PROCESSES= Any positive number less than or equal to 64. Must be less than or equal to the maximum number of gateway processes. The default value is 2.

1. MAX_REG_CONNECTIONS

To specify the maximum number of concurrent registration connection sessions that can be supported by Oracle Connection Manager. Default: 512

1. REGISTRATION_EXCLUDED_NODES

To specify the list of nodes that cannot register with the listener.

The list can include host names or CIDR notation for IPv4 and IPv6 addresses. The wildcard format (*) is supported for IPv4 addresses. The presence of a host name in the list results in the inclusion of all IP addresses mapped to the host name. The host name should be consistent with the public network interface.

If the REGISTRATION_INVITED_NODES parameter and the REGISTRATION_EXCLUDED_NODES parameter are set, then the REGISTRATION_EXCLUDED_NODES parameter is ignored.

Values: Valid nodes and subnet IP addresses or names.

Example

REGISTRATION_EXCLUDED_NODES = (10.1.26.*, 10.16.40.0/24, \

                                       2001:DB8:3eff:fe38, node2)

1. REGISTRATION_INVITED_NODES

Example

REGISTRATION_INVITED_NODES = (10.1.35.*, 10.1.34.0/24, \

                                      2001:DB8:fe38:7303, node1)

下面参数参见cmctl命令说明

1. ASO_AUTHENTICATION_FILTER={off(default) | on}
2. CONNECTION_STATISTICS={no(default) | yes}
3. EVENT_GROUP={init_and_term | memory_ops | conn_hdlg | proc_mgmt | reg_and_load | wake_up | timer | cmd_proc | relay}
4. IDLE_TIMEOUT=0 (default) or greater
5. INBOUND_CONNECT_TIMEOUT=0 or greater. The default value is 60.
6. OUTBOUND_CONNECT_TIMEOUT=0 or greater
7. LOG_DIRECTORY=log_directory. The default value is ORACLE_HOME/network/log.
8. LOG_LEVEL={off | user | admin | support(default)}
9. PASSWORD_instance_name= Value is the encrypted instance password, if one has been set. The default value is no value.
10. SESSION_TIMEOUT=0 or greater
11. TRACE_DIRECTORY=trace_directory. The default value is ORACLE_HOME/network/trace.
12. TRACE_FILELEN= Any positive number. The default value is 0 (zero).

To specify the size of the trace file in KB.

When the size is reached, the trace information is written to the next file. The number of files is specified with the TRACE_FILENO parameter.

1. TRACE_FILENO= Any positive number. The default value is 0 (zero).

To specify the number of trace files.

When this parameter is set along with the TRACE_FILELEN parameter, trace files are used in a cyclical fashion. The first file is filled first, then the second file, and so on. When the last file has been filled, the first file is reused, and so on.

1. TRACE_LEVEL={off(default) | user | admin | support}
2. TRACE_TIMESTAMP={off(default) | on}

1. ADR Diagnostic Parameters for Oracle Connection Manager

This section describes the parameters used when ADR is enabled. Non-ADR parameters listed in the cman.ora file are ignored when ADR is enabled.

1. ADR_BASE

To specify the base directory to store tracing and logging incidents when ADR is enabled.

Default:The default is ORACLE_BASE, or ORACLE_HOME/log if ORACLE_BASE is not defined.

1. DIAG_ADR_ENABLED

To indicate whether ADR tracing is enabled.

When the DIAG_ADR_ENABLED parameter is set to OFF, then non-ADR file tracing is used.

1. LOG_LEVEL

To specify the level of logging performed by Oracle Connection Manager.

The following log files are used with Oracle Connection Manager:

instance-name_pid.log for the listener.

instance-name_cmadmin_pid.log for CMADMIN.

instance-name_cmgw_pid.log for the gateway processes.

The log files are located in the ORACLE_HOME/network/log directory.

Default: off or 0. Values:

off or 0 for no log output.

user or 4 for user log information.

admin or 10 for administration log information.

support or 16 for Oracle Support Services log information.

1. TRACE_LEVEL

To specify the trace level for the Oracle Connection Manager instance.

This parameter is also applicable when non-ADR tracing is used.

The following trace files are used with Oracle Connection Manager:

instance-name_pid.trc for the listener.

instance-name_cmadmin_pid.trc for CMADMIN.

instance-name_cmgw_pid.trc for the gateway processes.

The log files are located in the ORACLE_HOME/network/log directory.

Default: off. Values

off for no trace output.

user for user trace information.

admin for administration trace information.

support for Oracle Support Services trace information.

1. TRACE_TIMESTAMP

To add a time stamp in the form of dd-mmm-yyyy hh:mi:ss:mil to every trace event in the trace file for the listener.

Default: on

1. Non-ADR Diagnostic Parameters for Oracle Connection Manager

This section lists the parameters used when ADR is disabled:

1. LOG_DIRECTORY

To specify the location of Oracle Connection Manager log files.

Default :ORACLE_HOME/network/log

1. TRACE_DIRECTORY

To specify the location of the Oracle Connection Manager trace files.

Default: ORACLE_HOME/network/trace

1. TRACE_FILELEN

To specify the size, in KB, of the trace file.

When the size is met, the trace information is written to the next file. The number of files is specified with the TRACE_FILENO parameter. Any size can be designated. Use this parameter when ADR is not enabled.

Default: Unlimited

1. TRACE_FILENO

To specify the number of trace files for Oracle Connection Manager tracing.

When this parameter is set along with the TRACE_FILELEN parameter, trace files are used in a cyclical fashion. The first file is filled first, then the second file, and so on. When the last file has been filled, the first file is reused, and so on. Any number of files can be designated.

The trace file names are distinguished from one another by their sequence number. For example, if this parameter is set to 3, then the gateway trace files would be named instance-name_cmgw1_pid.trc, instance_name_cmgw2_pid.trc and instance_name_cmgw3_pid.trc.

In addition, trace events in the trace files are preceded by the sequence number of the file. Use this parameter when ADR is not enabled.

Default: 1