The following table describes the Oracle mirroring parameters worksheet when building or copying a database. You need these values when you set up the mirror database.
Parameter |
Description |
---|---|
Control‑M Mirror Database Owner (DBO) |
Defines the name of the Control‑M/Server Mirror database owner. Control‑M uses the name when accessing the mirror database. When building a new mirror database, the initialization script creates this user on the database server. When copying to an existing database, this user must already be defined on the database server. NOTE: After using the utility, enter the DBO password to access the Control-M/Server database. Limited to 30 alphanumeric characters (including underscores). Default: ctrlm |
DBO password |
Defines the password for the Control‑M/Server database user (6 to 30 characters alphanumeric). The characters you enter do not echo for security reasons. Control‑M processes and utilities use the password to access the Control‑M/Server database. |
Mirror Oracle Host Name |
Defines the host computer name of an existing Oracle server. |
Mirror Oracle Port Number |
Defines the communication port of the Oracle Database Server. If you use a Control-M dedicated database SQL Server for the mirror database, the Port Number can be found in the QUERY_SPN field in the <controlm_owner>/install/install_defs file. Refresh Type: Recycle |
Mirror Oracle Instance Name (SID) |
Defines the Server ID of the Oracle Database Server. Type the command echo $ORACLE_SID on the mirror database server to obtain the name of the server. Default: ctrlm NOTE: The name must contain 1 to 8 alpha characters and an underscore. |
Control-M Mirror tablespace name |
Defines the name of a defined tablespace on the database server that the mirror database uses. The name must be unique. Default: ctrlm NOTE: Name starts with a letter followed by 1-24 alphanumeric characters. |
Control-M Mirror SID |
Defines the instance name of the Control-M/Server database. The ORACLE_SID parameter must be unique and not appear more than once in the tnsnames.ora file. For more information see Oracle documentation. NOTE: The Oracle database instance name must conform to the Oracle naming convention. |
Control-M Mirror Retry |
Defines the the number of retries the Control-M/Server attempts before marking the mirror as damaged. Valid values: 0-99 seconds. Default: 10 seconds |
Database Administrator Password |
Defines the password of the database server administrator |
Force (default: Y) |
Defines whether existing user are dropped before mirror initialization when the requested username is the same as the existing user. If set to N, the existing user won’t be dropped and the mirror initialization aborts. Valid values: Y,N |
Data Device Physical Full File |
Defines the database data location path |
Data File Size |
Defines the database size in MB created in the database server. The database size must have a numeric number. |
Parent Topic |