Oracle® Warehouse Builder Installation and Administration Guide 11g Release 2 (11.2) for Windows and Linux Part Number E10579-01 |
|
|
View PDF |
This section describes how to start and stop the Control Center Agent (CCA), and how to administer it using the cca_admin
utility. Note that the CCA manages deployment and execution of the mappings that are based on Code Templates. CCA is not part of the Control Center service hosted within the Oracle Database.
This section contains the following topics:
See Also:
Chapter 7, "Installing Optional Components", and specifically section "Configuring Control Center Agent Server-side Logging" if you have your own Oracle Application Server and want to install the CCA there.
Chapter 7, "Installing Optional Components" for procedures that modify the installation defaults
This section describes how to start and stop the CCA.
Note that when you invoke the ccastart
for the first time, it prompts you to enter a password for the OC4J administrator account. The default username for this account is oc4jadmin
.
To start the CCA:
In Linux, in the directory OWB_HOME
/owb/bin/unix/
, run the script ccastart
.
In Windows, in the directory OWB_HOME
\owb\bin\win32\
, run the script ccastart.bat
.
To stop the CCA:
In Linux, in the directory OWB_HOME
/owb/bin/unix/
, run the script ccashut
. This script accepts an optional argument password
.
In Windows, in the directory OWB_HOME
\owb\bin\win32\
, run the script ccashut.bat
. This script accepts an optional argument password
.
For a representation of architectural structures of this installation, see Figure 1-5, "Control Center Agent Topology".
For procedures that modify installation defaults, see Chapter 7, "Installing Optional Components".
The cca_admin
utility changes Control Center Agent settings dynamically, without the need to shut down and subsequently restart the run-time environment. cca_admin commands retrieve the values of various environment attributes, set these to new values, and invoke the operations of JRTAdministratorMBean
, introduced in section "JRTAdministratorMBean".
The typical cca_admin session includes the following steps:
Running the cca_admin script, as described in "Starting the cca_admin Utility"
Connecting to an MBeanServer using the connect
command described in "connect"
Issuing one or more commands to view or update run-time environment attributes or invoke cca_admin commands described in "cca_admin Commands"
Disconnecting from the server using the command "disconnect" or the command "exit".
The cca_admin
tool is delivered as a shell script on Linux or a batch file on Windows.
In Linux, use the following command:
OWB_HOME
/owb/bin/unix/cca_admin
In Windows, use the following command:
OWB_HOME
\owb\bin\win32\cca_admin.bat
.
Before activating the JRTAdministratorMBean
, your can use only the basic commands: help
, connect
, disconnect
, and exit
. The full range of commands is available once you connect to an MBean server and start using the JRTAdministratorMBean
.
The following is a complete list of the cca_admin commands:
This command removes all log files that were modified during the specified time range, between startDate
and endDate
, and returns the total number of files removed. Both parameters are expressed in the format DD-MM-YYYY HH:MM:SS
. If the specified startDate
is null
, no records are deleted. If endDate
is null
, all log files created after the startDate
are purged.
This command removes the specified number, n
, of least recent log files from the system, and returns the number of job log files that are actually removed.
This command connects the user to MBean server.
The command is of the following form, where host
is the computer on which the CCA is located, port
is the port number for accessing the CCA, user
is the user name for accessing the CCA, password
is that user's password, connection_type
is one of RMI
, OPMN
, RMIS
, OPMN_RMIS
, OPMN_CLUSTER
, or OPMN_CLUSTER_RMIS
, application_name
is the name of the application deployed to OC4J, and instance
is the OC4J process that contains the CCA application:
connect host port user password connection_type application_name instance
This command disconnects the user from the MBean server.
This command exits the cca_admin
shell when it is running in the interactive mode. If the connection to the MBean server is not closed, it first disconnects and then exits cca_admin
shell.
This command returns a value for the numerical (integer) MBean attribute CacheJobStatusSize
, which controls the maximum number of the job status logs that can be stored by the in-memory job log cache in CCA. The attribute's value is in the range of 1
and 10000
, with the default value of 3000
.
This command returns the value of MBean attribute CacheLogNo
, which controls the maximum number of job logs that can be stored by the in-memory job log cache in CCA. Obviously the bigger this number is the more memory CCA takes up. The attribute's value is in the range of 1
and 100
, with the default value of 10
.
This command returns the value of MBean attribute KmPermissionsFile
, which is the file system path to the ct_permissions.properties
file. If this parameter is set to true
, the CCA checks ct_permissions.properties
to determine what system commands may be executed. This path may be either absolute or relative. The relative value refers to the $OC4J_HOME
/j2ee/home
directory. The default value is config/ct_permissions.properties
.
This command returns the value of MBean attribute LogRoot
, which is the directory that stores the CCA job log file. The attribute value may be either absolute or relative. The relative value refers to $OC4J_HOME
/j2ee/home
directory; the default value is $OC4J_HOME
/j2ee/home/log
.
Returns the value of MBean attribute MaxAbortTimeout
, the maximum amount of wait time in seconds before the execution is aborted. The attribute's value is in the range of 1
to 60
; and the default value is 60
.
This command returns the value of MBean attribute MaxRuntimeFileSizeMB
, the maximum size of any log file, in MB
. When a log file exceeds this limit, it is closed and a new log file is opened. The attribute's value is in the range of 1
MB
to 15
MB
, and the default value is 3
MB
.
This command returns the value of MBean attribute MaxRuntimeLogSizeMB
, the maximum size of the log file directory, in MB.
When the directory exceeds this limit, log files are purged, starting with the oldest. The attribute's value is in the range of 1
MB
to 20
MB
, and the default value is 10
MB
.
This command returns the value of MBean attribute RuntimeLogEncoding
, which specifies the character encoding of the log file. The default value is UTF-8
.
This command returns the value of MBean attribute RuntimeLogFileLocation
, the name of CCA job log file, a read-only attribute. This value is $OC4J_HOME
/j2ee/home/log/
appName
.log
, where appName
is the name of the CCA application.
This application returns the value of MBean attribute RuntimeLogLevel
, the log level for run-time logger. The legal values for this attribute are: SEVERE
, WARNING
, INFO
, CONFIG
, FINE
, FINER
, FINEST
, ALL
(default).
This command returns help information for a specified valid command
; if a command is not specified, it returns the list of valid commands.
This command returns the value of MBean attribute KmSecurityNeeded
, determining whether security is enforced on system commands that are invoked by CCA script. If the value is true
(which is the default), CCA checks the ct_permissions.properties
file for allowable system commands, and only execute the commands defined in ALLOWED_CMD
. If the value is false
, CCA executes all system commands.
This command returns the value of MBean attribute LogToAuditTable
, which turns audit table logging on and off. Audit table logging is only effective for execution job logs. The attribute value is either true
or false
.
This command returns the value of MBean attribute LogToOdl
, which turns ODL logging on and off. Only effective for execution job logs. Deployment and web service logs are always created in the ODL log format, regardless of the value of this setting. The attribute value is either true
or false
.
This command returns the value of MBean attribute ShowRuntimeLoggerLogHostAddr
, which determines whether the IP address of the host that is running CCA is included in the run-time log messages. The attribute value is either true
or false
(default).
This command returns the value of MBean attribute ShowRuntimeLoggerLogHostId
, which determines whether the ID of the host that is running CCA is included in the run-time log messages. The attribute value is either true
or false
(default).
This command returns the value of MBean attribute ShowRuntimeLoggerLogMsgClassPath
, which determines whether the path of the class where the message is logged is included in the run-time log messages. The attribute value is either true
or false
(default).
This command returns the value of MBean attribute ShowRuntimeLoggerLogMsgLogLevel
, which determines whether the log level of the log message is included in the run-time log messages. The attribute value is either true
or false
(default).
This command returns the value of MBean attribute ShowRuntimeLoggerLogUserId
, which determines whether the ID of the user is included in the run-time log messages. The attribute value is either true
or false
(default).
This command reads CCA settings from the CCA configuration file.
This command resets attributes to their default values, if the attributes are defined to have defaults.
This command sets the value for MBean attribute CacheJobStatusSize
, which controls the maximum number of the job status that can be stored in the in-memory job log cache in CCACCA. The attribute's value is an integer in the range of 1
to 10000
; the default value is 3000
.
This command sets a value for MBean attribute CacheLogNo
, which controls the maximum number of job logs that can be stored in the in-memory job log cache in CCA. The attribute's value is an integer in the range of 1
and 100
; the default value is 10
.
This command sets the value for MBean attribute KmPermissionsFile
, which is the file system path to the ct_permissions.properties
file. If the value is set to true
, the CCA checks the file to determine what system commands may run. The path can be either absolute or relative. The relative refers to $OC4J_HOME
/j2ee/home
directory; the default value is config/ct_permissions.properties
.
This command sets a value for MBean attribute KmSecurityNeeded
, which determines whether security is enforced on system commands invoked from CCA scripts. When the value is true
(default), CCA checks the ct_permissions.properties
file for system commands that may run, and only execute the ones defined in ALLOWED_CMD
. When the value is false
, CCA executes all system commands.
This command sets the value of MBean attribute LogRoot
, the directory of the CCA job log file. The attribute's value may be either absolute or relative. The relative value refers to $OC4J_HOME
/j2ee/home
directory; the default value is $OC4J_HOME
/j2ee/home/log
.
This command sets the value for MBean attribute LogToAuditTable
, which turns audit table logging on and off. Audit table logging is only effective for execution job logs. The attribute's value is true
or false
.
This command sets the value for MBean attribute LogToOdl
, which turns ODL logging on and off. This is only effective for execution job logs; deployment and web service logs are created in ODL log format regardless of this setting. The attribute's value is true
or false
.
This command sets the value for MBean attribute MaxAbortTimeout
, the maximum wait time (in seconds) before aborting the execution. The attribute's value is an integer in the range of 1
to 60
(default).
This command sets the value of MBean attribute MaxRuntimeFileSizeMB
, the maximum size, in MB, a log file in the directory. When a log file exceeds this limit, it is closed and a new log file is opened. The attribute's value is an integer in the range of 1
MB
and 15
MB
; the default value is 3
MB
.
This command sets the value of MBean attribute MaxRuntimeLogSizeMB
, the maximum size of the log file directory, in MB.
When the directory exceeds this limit, log files are purged, starting with the oldest. The attribute's value is in the range of 1
MB
to 20
MB
, and the default value is 10
MB
.
This command sets the value of MBean attribute RuntimeLogEncoding
, which specifies the character set encoding of the log file. The default value is UTF-8
.
This command sets the value for MBean attribute RuntimeLogLevel
, the log level for run-time logger. The attribute's value may be SEVERE
,WARNING
, INFO
, CONFIG
, FINE
, FINER
, FINEST
, ALL
(default).
This command sets the value for MBean attribute ShowRuntimeLoggerLogHostAddr
, which determines whether the IP address of the CCA host is included in the run-time log messages. The attribute value is either true
or false
(default).
This command sets the value for MBean attribute ShowRuntimeLoggerLogHostId
, which determines whether the ID of the CCA host is included in the run-time log messages. The attribute value is either true
or false
(default).
This command sets the value for MBean attribute ShowRuntimeLoggerLogMsgClassPath
, which determines whether the path of the class that logged the message is included in the run-time log messages. The attribute value is either true
or false
(default).
This command sets the value for MBean attribute ShowRuntimeLoggerLogMsgLogLevel
, which determines whether the log level of the log message is included in the run-time log messages. The attribute value is either true
or false
(default).
This command sets the value for MBean attribute ShowRuntimeLoggerLogUserId
, which determines whether the ID of the user is included in the run-time log messages. The attribute value is either true
or false
(default).
This command converts CCA setting information to String
, and shows all CCA settings.