2.2.4 Oracle DBCA Commands and Parameters for True Cache

Use the following Oracle DBCA commands and parameters to configure True Cache.

• configureDatabase
  The configureDatabase command configures the primary database for True Cache. Run this command on the primary database.
• createTrueCache
  The createTrueCache command configures True Cache. Run this command on the True Cache node.

2.2.4.1 configureDatabase

The configureDatabase command configures the primary database for True Cache. Run this command on the primary database.

Parameters

For True Cache, use the dbca -configureDatabase command with the following syntax.

Note:

This table lists the configureDatabase parameters that are specific to True Cache. For the full syntax and parameters, see configureDatabase in the Oracle Multitenant Administrator's Guide.

Table 2-1 configureDatabase Parameters

Parameter	Required/Optional	Description
--prepareTrueCacheConfigFile	Required for True Cache	Use this option to prepare a configuration BLOB file that contains the primary database's password file or wallet. Enter the following additional parameters for this option: -sourceDB: Enter the primary database system identifier (SID) or database unique name (DB_UNIQUE_NAME). -tdeWalletPassword: If the primary database uses a Transparent Data Encryption (TDE) wallet, enter the password for the wallet. This parameter is optional. -trueCacheBlobLocation: Enter the path where you want to save the configuration BLOB file on the primary database. This parameter is optional.
-configureTrueCacheInstanceService	Required for True Cache	Use this option to configure the True Cache database application service on the primary database and start the service on True Cache. Enter the following additional parameters for this option: -serviceName: Enter the primary database application service name. -sourceDB: Enter the primary database SID or database unique name (DB_UNIQUE_NAME). -trueCacheConnectString: Enter the Easy Connect (EZConnect) string to connect to True Cache. Example: host:port/service_name -trueCacheServiceName: Enter a name for the True Cache database application service. -pdbName: Enter the primary pluggable database (PDB) name. This parameter is optional.
-cleanupTrueCacheInstanceService	Required for True Cache	Use this option to remove the True Cache database application services from the primary database configuration if, for example, you delete True Cache. Enter the following additional parameters for this option: -serviceName: Enter the primary database application service name. -sourceDB: Enter the primary database SID or database unique name (DB_UNIQUE_NAME). -trueCacheConnectString: Enter the Easy Connect (EZConnect) string to connect to True Cache. Example: host:port/service_name

2.2.4.2 createTrueCache

The createTrueCache command configures True Cache. Run this command on the True Cache node.

Syntax and Parameters

Use the dbca -createTrueCache command with the following syntax:

dbca -createTrueCache
   -dbUniqueName true_cache_unique_name | -gdbName true_cache_global_name
   -sourceDBConnectionString primary_db_easy_connect_string
   -trueCacheBlobFromSourceDB true_cache_config_blob_path | -passwordFileFromSourceDB password_file_path
      [-tdeWalletFromSourceDB tde_wallet_path]
   [-createListener new_database_listener]
   [-datafileDestination true_cache_control_file_path
   [-initParams initialization_parameters_list
      [-initParamsEscapeChar initialization_parameters_escape_character]]
   [-listeners listener_list]
   [-pgaAggregateTargetInMB pga_memory_size]
   [-sgaTargetInMB sga_memory_size]
   [-sid true_cache_sid]
   [-sourceTdeWalletPassword primary_db_wallet_password]
   [-tdeWalletLoginType {PASSWORD | AUTO_LOGIN | LOCAL_AUTO_LOGIN}]
   [-tdeWalletRoot tde_wallet_root_init_parameter]
   [-useWalletForDBCredentials {true | false}
      -dbCredentialsWalletLocation wallet_files_directory
      [-dbCredentialsWalletPassword wallet_account_password]]

Table 2-2 createTrueCache Parameters

Parameter	Required/Optional	Description
-dbUniqueName true_cache_unique_name or -gdbName true_cache_global_name	Required	Enter either the unique name for this True Cache or the global database name.
-sourceDBConnectionString primary_db_easy_connect_string	Required	Enter the Easy Connect (EZConnect) string to connect to the primary database. Example: host:port/service_name Note: For Oracle RAC primary databases, set the -sourceDBConnectionString parameter to SCAN:port/service_name.
-trueCacheBlobFromSourceDB true_cache_config_blob_path or -passwordFileFromSourceDB password_file_path	Required	Enter one of the following: The full path and file name for the configuration BLOB file that contains the primary database's password file or wallet. This is the path where the file is located on the True Cache node. The path to the primary database's password file that was copied to the True Cache node. If you use -passwordFileFromSourceDB, you can also enter the following additional parameter: -tdeWalletFromSourceDB: Enter the path to the primary database's Transparent Data Encryption (TDE) wallet file that was copied to the True Cache node. You can copy and use the TDE wallet file only if the primary (source) database has TDE enabled. Otherwise, the wallet file isn't required.
-createListener new_database_listener	Optional	Enter a new database listener to be created and to register the database in the form LISTENER_NAME:PORT.
-datafileDestination true_cache_control_file_path	Optional	Enter the location where the True Cache control file, standby redo log groups, and temporary data files are to be stored. If Oracle Automatic Storage Management (ASM) storage is used for True Cache, enter the disk group name for -datafileDestination and use the following additional parameter: -useOMF: Enter true to use Oracle-Managed Files (OMF). Otherwise, enter false.
-initParams initialization_parameters_list	Optional	Enter a comma-separated list of name=value pairs with additional initialization parameter values for this True Cache. You can also provide the -initParamsEscapeChar parameter for using a specific escape character between multiple values of an initialization parameter. If an escape character is not specified, backslash (\) is used as the default escape character.
-listeners listeners_list	Optional	If one or more listeners already exist, enter a comma-separated list of existing listeners that the database can be configured with. If you don't specify the existing listeners, DBCA creates a new listener.
-pgaAggregateTargetInMB pga_memory_size	Optional	Enter a value in MB for the target aggregate Program Global Area (PGA) memory to make available to all server processes that are attached to this True Cache.
-sgaTargetInMB sga_memory_size	Optional	Enter a value in MB for the System Global Area (SGA) memory size for this True Cache.
-sid true_cache_sid	Optional	Enter the system identifier (SID) for this True Cache.
-sourceTdeWalletPassword primary_db_wallet_password	Optional	If the primary database uses a TDE wallet, enter the password for the wallet.
-tdeWalletLoginType {PASSWORD | AUTO_LOGIN | LOCAL_AUTO_LOGIN}	Optional	Oracle recommends the AUTO_LOGIN or LOCAL_AUTO_LOGIN wallet for True Cache to avoid having to manually open a password wallet for each True Cache startup. To learn more about wallet types, see About Oracle Database Wallets
-tdeWalletRoot tde_wallet_root_init_parameter	Optional	Enter the location for the True Cache TDE wallet root initialization parameter, which specifies where to place the wallet for True Cache.
-useWalletForDBCredentials {true | false}	Optional	If the primary database uses Oracle Wallet for database credentials, enter true. The default is false. If you enter true, also enter the following additional parameters: -dbCredentialsWalletLocation: Enter the path of the directory that contains the Oracle Wallet files. -dbCredentialsWalletPassword: Enter the password for the Oracle Wallet account to open the wallet with auto-login disabled. This parameter is optional.