-gdbName global_database_name

Required

Global database name in the form database_name.domain_name.

-nodeName database_instance_node_name

Required

Node name of the database instance.

-instanceName database_instance_name

Optional

Database instance name.

-sysDBAUserName SYSDBA_user_name

Optional

User name of the database user having the SYSDBA privileges.

-sysDBAPassword SYSDBA_user_password

Optional

Password of the database user having the SYSDBA privileges.

-updateDirService

{true | false}

Optional

Specify true to register the database with a directory service, else specify false.

When true is specified, the following additional parameters are required:

• -dirServiceUserName: User name for the directory service.

• —dirServicePassword: Password for the directory service user.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-sourceDB database_sid

Required

The database system identifier (SID) of the database being configured.

-addDBOption

database_options

Optional

Specify one or more of the following Oracle Database options in the form of a comma separated list:

• JSERVER: Oracle JServer JAVA Virtual Machine

• ORACLE_TEXT: Oracle Text

• IMEDIA: Oracle Locator (fully supported) and Oracle Multimedia (desupported)

• CWMLITE: Oracle OLAP with Oracle Warehouse Builder (OWB)

• SPATIAL: Oracle Spatial and Graph

• OMS: Oracle Management Server

• APEX: Oracle Application Express

• DV: Oracle Database Vault

Example:

-addDBOption JSERVER,ORACLE_TEXT,OMS

Optional

Specify this parameter to configure Oracle Machine Learning for Python in the database.

-configureOracleR

Optional

Specify this parameter to configure Oracle R in the database.

Additionally, you can specify the -oracleRConfigTablespace parameter to assign a tablespace for the Oracle R configuration, such as SYSAUX tablespace.

-dvConfiguration

{true | false}

Optional

Specify true to enable and configure Database Vault, or specify false. Default is false.

When true is specified, the following additional Database Vault parameters are required:

• -dvUserName: Specify the Database Vault owner username.

• -dvUserPassword: Specify Database Vault owner password.

• -dvAccountManagerName: Specify a separate Database Vault account manager.

• -dvAccountManagerPassword: Specify the Database Vault account manager password.

-configureTDE{true | false}

Optional

Specify true to configure TDE wallet. Default is false.

When true is specified, the following additional parameters can be provided:

• -encryptPDBTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -encryptTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -primaryDBTdeWallet: Specify the location for TDE wallet of primary database.

• -sourceTdeWalletPassword: Specify password for source database TDE wallet.

• -tdeAlgorithm: Specify the TDE algorithm type.

• -tdeWalletLoginType: Specify the TDE wallet login type, PASSWORD | AUTO_LOGIN | LOCAL_AUTO_LOGIN. The default is PASSWORD for single-instance database and AUTO_LOGIN for Oracle RAC database.

• -tdeWalletPassword: Specify password for TDE wallet.

• -tdeWalletPathInTarFile: Specify the TDE wallet path in the tar file.

• -tdeWalletRoot: Specify the location for TDE wallet root init parameter.

-exportTDEKeys

Optional

Specify this parameter to export TDE master encryption keys.

Specify the following additional parameters:

• -tdeKeysFilePath: Location to export TDE master encryption keys

• -tdeKeysFileSecret: Secret to export TDE master encryption keys

• -tdeWalletPassword: Specify the password for TDE wallet

-moveDatabaseFiles

Optional

Specify this parameter to move database files from one storage location to another storage location. For example, to move database files from ASM to FS, or from FS to ASM.

Specify the following additional parameters:

• -datafileDestination: Destination directory for all the database files

• -sourceDB: Database system identifier (SID) for a single instance database or database unique name for an Oracle RAC database

• -initParams: Database initialization parameters in the form of comma separated list of name=value pairs

  Additionally, you can specify 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.

• -recoveryAreaDestination: Destination directory for the Fast Recovery Area, which is a backup and recovery area. Specify NONE to disable Fast Recovery Area.

  Additionally, you can specify the Fast Recovery Area size in megabytes using the parameter -recoveryAreaSize. This parameter is optional.

• -useOMF: Specify true to use Oracle-Managed Files (OMF), else specify false.

-olsConfiguration

{true | false}

Optional

Specify true to enable and configure Oracle Label Security, else specify false. Default is false.

When true is specified, you can additionally specify the -configureWithOID parameter to configure Oracle Label Security with Oracle Internet Directory (OID). This parameter is optional.

-regenerateDBPassword {true | false}

Optional

Specify true to regenerate Oracle Internet Directory (OID) server registration password, else specify false. Default is false.

-registerWithDirService

{true | false}

Optional

Specify true to register with a Lightweight Directory Access Protocol (LDAP) service, else specify false. Default is false.

When true is specified, the following additional parameters are required:

• -dirServiceUserName: User name for the LDAP service.

• -dirServicePassword: Password for the LDAP service.

• -databaseCN: Database common name.

• -dirServiceCertificatePath: Directory service certificate file path.

• -dirServiceUser: Directory service user name.

• -ldapDirectoryAccessType {PASSWORD | SSL}: LDAP directory access type.

• -useSYSAuthForLDAPAccess {true | false}: Specify whether to use SYS user authentication for LDAP access.

• -walletPassword: Password for the database wallet.

-sysDBAPassword SYSDBA_user_password

Optional

Password of a user having SYSDBA privileges.

-sysDBAUserName SYSDBA_user_name

Optional

User name of a user having SYSDBA privileges.

-unregisterWithDirService

{true | false}

Optional

Specify true to unregister with a Lightweight Directory Access Protocol (LDAP) service, else specify false. Default is false.

When true is specified, the following additional parameters are required:

• -dirServiceUserName: User name for the LDAP service.

• -dirServicePassword: Password for the LDAP service.

• -walletPassword: Password for the database wallet.

-tdeWalletPassword

Optional

Specify password for TDE wallet.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

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.

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.

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

• -trueCacheServiceName: Enter a name for the True Cache database application service.

-runDatapatch

Database runDatapatch

Optional

Specify the database on which to apply the data patch.

The following additional parameters are required:

• -sourceDB: Database unique name for Oracle RAC database or SID for single-instance database for the data patch.

• -pdbsToRunDatapatch: Option to run datapatch only on given PDBs. For example pdb1,pdb2.

• -skipClosedPDBs: Flag to skip the data patch on closed PDBs.

• -skipPDBs: A comma-separated list of PDBs to be skipped for current operation.

-sourceDB database_unique_name

Required

Specifies the source database name.

-enableDGDebug

Optional

Option to enable tracing for dgmrl command.

-switchOver

Optional

Specifies the option to switchover to the standby database.

-targetStandbyDB

Optional

Specifies the target standby database.

-pdbName pdb_name

Required

Name of the PDB.

-sourceDB cdb_sid

Required

The database system identifier (SID) of the CDB.

Optional

Specify this parameter to configure Oracle Machine Learning for Python in the database.

-configureOracleR

Optional

Specify this parameter to configure Oracle R for the PDB.

Additionally, you can specify the -oracleRConfigTablespace parameter to assign a tablespace for the Oracle R configuration, for example, SYSAUX tablespace.

-dvConfiguration {true | false}

Optional

Specify true to enable and configure Database Vault for the PDB, else specify false. Default is false.

When true is specified, the following additional Database Vault parameters are required:

• -dvUserName: Specify the Database Vault owner user name.

• -dvUserPassword: Specify Database Vault owner password.

• -dvAccountManagerName: Specify a separate Database Vault account manager.

• -dvAccountManagerPassword: Specify the Database Vault account manager password.

-lbacsysPassword

Optional

Specify the LBACSYS user password, if you want to configure OLS with a directory service.

-pdbInitParams

Optional

-pdbInitParams: Specify PDB specific initialization parameters.Comma-separated list of name=value pairs.

-initParamsEscapeChar: Specify escape character for comma when a specific initialization parameter has multiple values. If the escape character is not specified, then backslash is the default escape character.

-olsConfiguration {true | false}

Optional

Specify true to enable and configure Oracle Label Security (OLS) for the PDB, else specify false. Default is false.

When true is specified, you can additionally specify the -configureWithOID parameter to configure Oracle Label Security (OLS) with Oracle Internet Directory (OID). This parameter is optional.

Optional

Use this parameter to specify the time zone of the PDB.

-registerWithDirService{true | false}

Optional

Specify true to register the PDB with a Lightweight Directory Access Protocol (LDAP) service, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dirServiceUserName: User name for the LDAP service.

• -dirServicePassword: Password for the LDAP service user.

• -walletPassword: Password for the database wallet.

• -databaseCN: Database common name.

• -dirServiceCertificatePath: Directory service certificate file path.

• -dirServiceUser: Active Directory account user name.

unregisterWithDirService {true | false}

Optional

Specify true to unregister the PDB with the Lightweight Directory Access Protocol (LDAP) service, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dirServiceUserName: User name for the LDAP service.

• -dirServicePassword: Password for the LDAP service user.

• -walletPassword: Password for the database wallet.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-configurePDBSnapshot{true | false}

Optional

Specify true to configure automatic snapshot for a PDB. Default is false.

When true is specified, the following additional parameters can be provided:

• -snapshotIntervalInMins: Specify interval in minutes for automatic snapshot creation.

• -maxPDBSnapshots: Specify maximum number of snapshots to be retained during automatic snapshot creation.

-configureTDE{true | false}

Optional

Specify true to configure TDE wallet. Default is false.

When true is specified, the following additional parameters can be provided:

• -encryptPDBTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -encryptTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -primaryDBTdeWallet: Specify the location for TDE wallet of primary database.

• -sourceTdeWalletPassword: Specify password for source database TDE wallet.

• -tdeAlgorithm: Specify the TDE algorithm type.

• -tdeWalletLoginType: Specify the TDE wallet login type, PASSWORD | AUTO_LOGIN | LOCAL_AUTO_LOGIN. The default is PASSWORD for single-instance database and AUTO_LOGIN for Oracle RAC database.

• -tdeWalletPassword: Specify password for TDE wallet.

• -tdeWalletPathInTarFile: Specify the TDE wallet path in the tar file.

• -tdeWalletRoot: Specify the location for TDE wallet root init parameter.

-sourceDB database_sid

Required

The database system identifier (SID) of the database being configured.

-sysPassword

SYS_user_password

Optional

SYS user password for the database.

-sourceSID source_database_sid

or

-sourceDB source_database_name

Required

Specify either the source database system identifier (SID) or the source database name.

-templateName new_database_template_name

Required

Name of the new database template.

-sysDBAUserName SYSDBA_user_name

Optional

User name of a user having the SYSDBA privileges.

-sysDBAPassword SYSDBA_user_password

Optional

Password of the user having the SYSDBA privileges.

-maxBackupSetSizeInMB maximum_backup_set_size_in_MB

Optional

Maximum backup set size in megabytes.

-rmanParallelism parallelism_integer_value

Optional

Parallelism integer value for RMAN operations.

-datafileJarLocation data_files_backup_directory

Optional

Complete directory path to store data files as a backup in a compressed format.

-backupTDEWalletAsAutoLogin {true | false}

Optional

Specify true to backup the TDE wallet as AUTO_LOGIN, else specify false.

-dataFileBackup {true | false}

Optional

Specify true to take the data files backup, else specify false.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

Optional

Creates a clone template and uploads it to Oracle Cloud Infrastructure. The structure and data of the database is stored in the template. DBCA can then use this template to create new databases.

To create a template to Oracle Cloud Infrastructure, you must subscribe to the Oracle Database Backup Cloud Service and install the Oracle Database Cloud Backup Module for OCI. Recovery Manager (RMAN) creates a backup containing the details of the clone template. The backup must be encrypted, so you must provide the RMAN encryption password to encrypt backups.

This option is only supported on Linux.

• opcLibPath: Directory in which the Oracle Database Cloud Backup Module for OCI is stored. The backup module is a system backup to tape (SBT) library that is used to integrate on-premise databases with Oracle Cloud Infrastructure. The file name is libopc.so on Linux.

• opcConfigFile: Name, with complete location, of the Oracle Database Cloud Backup Module for OCI configuration file. This file is created when you install the backup module.

• rmanEncryptionPassword: Password used to encrypt the RMAN backups to Cloud that contian the clone template.

See Administering Oracle Database Backup Cloud Service for information about installing and configuring the backup module.

Optional

Compresses the backup containing the clone template files.

Optional

Password of the TDE wallet that contains the keys used to encrypt backups. Specify this parameter if Transparent Data Encryption (TDE) must be used to encrypt backups.

Optional

Password of the TDE wallet.

Optional

Specify whether you want to maintain file locations.

-gdbName

global_database_name

Required

Global database name in the form database_name.domain_name.

-responseFile

response_file_directory

Required

Absolute directory path of the response file.

-templateName

database_template_name

Required

Name of an existing database template in the default location or the complete path to a database template that is not in the default location.

-adminManaged

Optional

Administrator-managed database.

-characterSet

database_character_set

Optional

Character set of the database.

configureTDE

Optional

Specify true to configure TDE during the database creation. Only software wallets are supported. You can create a wallet for the entire CDB or for a PDB.

• -encryptPDBTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -encryptTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• primaryDBTdeWallet: This option is not applicable when creating a database.

• sourceTdeWalletPassword: If the template that is being used is from a database that uses encryption, or if you are duplicating a database, specify the password of the wallet in the source database.

• tdeAlgorithm: Algorithm used to encrypt data. Can be one of the following: 3DES168, AES128, AES192, AES256.

• tdeWalletLoginType: Type of software wallet. PASSWORD or AUTO_LOGIN or LOCAL_AUTO_LOGIN.

• -tdeWalletPathInTarFile: Specify the TDE wallet path in the tar file.

• -tdeWalletRoot: Specify the location for TDE wallet root init parameter.

• tdeWalletPassword: The password used to open the wallet. This parameter is mandatory.

Note: Isolated PDBs can be deployed in customer-managed databases on customer-managed hardware, including Oracle Exadata environments.

-enableTwoStagePatches

Optional

Specify this flag to enable two stage patches.

-skipPdbServiceCreation

Optional

Specify -skipPdbServiceCreation flag to skip the PDB service creation.

-createAsContainerDatabase

{true | false}

Optional

Specify true to create a CDB. Specifying false is not supported starting with Oracle Database Release 20.3.

When true is specified, the following additional parameters are optional:

• -numberOfPDBs: Number of PDBs to create. The default is 0 (zero).

• -pdbName: Base name of each PDB. A number is appended to each name if -numberOfPDBs is greater than 1. This parameter must be specified if -numberOfPDBs is greater than 0 (zero).

• -pdbStorageMAXSizeInMB: Maximum storage size for the PDBs in megabytes.

• -pdbStorageMAXTempSizeInMB: Maximum temporary storage size for the PDBs in megabytes.

• -useLocalUndoForPDBs {true | false}: Specify whether local undo should be used for the PDBs.

• -pdbAdminPassword: PDB administrator password.

• -pdbOptions: Specify PDB options as comma separated list in name:value format.

  Example: JSERVER:true, DV:false

-createListener

new_database_listener

Optional

Database listener to register the database in the form listener_name:port.

-customScripts

custom_scripts_list

Optional

Specify a comma separated list of SQL scripts that needs to be run after the database creation. The scripts are run in the order they are listed.

-databaseConfigType

{SINGLE | RAC | RACONENODE}

Optional

Specify one of the following database configuration types:

• SINGLE: Single individual database.

• RAC: Oracle RAC database.

• RACONENODE: Oracle RAC One Node database.

  For Oracle RAC One Node database, you can specify the service name using the -RACOneNodeServiceName parameter.

-databaseType

{MULTIPURPOSE | DATA_WAREHOUSING | OLTP}

Optional

Specify MULTIPURPOSE if the database is for both OLTP and data warehouse purposes.

Specify DATA_WAREHOUSING if the primary purpose of the database is a data warehouse.

Specify OLTP if the primary purpose of the database is online transaction processing.

-datafileDestination

data_files_directory

Optional

Complete path to the location of the database data files.

-datafileJarLocation

data_files_backup_directory

Optional

Absolute directory path of the database backup data files stored in a compressed RMAN backup format (files with .dfb extensions).

-dbOptions

database_options

Optional

Specify database options as comma separated list of name:value pairs.

Example: JSERVER:true,DV:false

-dvConfiguration

{true | false}

Optional

Specify true to enable and configure Database Vault, else specify false. Default is false.

When true is specified, the following additional Database Vault parameters are required:

• -dvUserName: Specify Database Vault owner name.

• -dvUserPassword: Specify Database Vault owner password.

• -dvAccountManagerName: Specify Database Vault account manager name.

• -dvAccountManagerPassword: Specify Database Vault account manager password.

-emConfiguration

{CENTRAL | NONE}

Optional

Enterprise Manager configuration settings.

When CENTRAL is specified, specify the following additional parameters:

• -dbsnmpPassword: DBSNMP user password.

• -omsHost: Oracle Management Server host name.

• -omsPort: Oracle Management Server port number.

• -emUser: User name for Enterprise Manager administrator.

• -emPassword: Password for Enterprise Manager administrator.

-enableArchive

{true | false}

Optional

Specify true to enable log file archive, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -archiveLogMode {AUTO | MANUAL}: Specify either the automatic archive mode or the manual archive mode. Default is automatic archive mode.

• -archiveLogDest: Directory path for storing the archive log files.

-initParams

initialization_parameters_list

Optional

A comma-separated list of name=value pairs of initialization parameter values for the database.

You can additionally 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

A comma-separated list of listeners for the database.

Optional

Use this parameter to set the database management policy.

The default policy is -adminManaged.

-memoryMgmtType

{AUTO | AUTO_SGA | CUSTOM_SGA}

Optional

Specify one of the following memory management types:

• AUTO: Automatic memory management for SGA and PGA.

• AUTO_SGA: Automatic shared memory management for SGA.

• CUSTOM_SGA: Manual shared memory management for SGA.

Note: If the total physical memory of a database instance is greater than 4 GB, then you cannot specify the Automatic Memory Management option AUTO during the database installation and creation. Oracle recommends that you specify the Automatic Shared Memory Management option AUTO_SGA in such environments.

-memoryPercentage

percentage_of_total_memory_to_assign_to_oracle_database

or

-totalMemory

total_memory_to_assign_to_oracle_database_in_MB

Optional

Specify either -memoryPercentage or -totalMemory.

• -memoryPercentage

  The percentage of physical memory that can be used by the database.

• -totalMemory.

  Total amount of physical memory, in megabytes, that can be used by the database.

-nationalCharacterSet

database_national_character_set

Optional

National character set of the database.

-nodelist

database_nodes_list

Optional

List of database nodes separated by comma.

-olsConfiguration

{true | false}

Optional

Specify true to enable and configure Oracle Label Security (OLS), else specify false. Default is false.

-oracleHomeUserName

Oracle_Home_user_name

-oracleHomeUserPassword

Oracle_Home_user_password

Optional

Oracle Home user name and password.

-recoveryAreaDestination

fast_recovery_area_directory

Optional

Destination directory for the Fast Recovery Area, which is a backup and recovery area. Specify NONE to disable Fast Recovery Area.

Additionally, you can specify the Fast Recovery Area size in megabytes using the parameter -recoveryAreaSize. This parameter is optional.

-redoLogFileSize

maximum_size_of_redo_log_file

Optional

Size of each online redo log in megabytes.

-registerWithDirService

{true | false}

Optional

Specify true to register with a Lightweight Directory Access Protocol (LDAP) service, else specify false. Default is false.

When true is specified, the following additional parameters are required:

• -dirServiceUserName: Username for the LDAP service.

• -dirServicePassword: Password for the LDAP service.

• -databaseCN: Database common name.

• -dirServiceCertificatePath: Directory path to the certificate file to use when configuring SSL between the database and the directory service.

• -dirServiceUser: Directory service user name.

• -ldapDirectoryAccessType {PASSWORD | SSL}: LDAP directory access type.

• -useSYSAuthForLDAPAccess {true | false}: Specify whether to use SYS user authentication for LDAP acces.

• -walletPassword: Password for the database wallet.

-runCVUChecks

{true | false}

Optional

Specify true to run Cluster Verification Utility checks periodically for Oracle RAC databases, else specify false. Default is false.

-sid

database_system_identifier

Optional

Database system identifier (SID).

The SID uniquely identifies the instance that runs the database. If it is not specified, then it defaults to the database name.

-storageType

{FS | ASM | EXASCALE | PMEMFS}

Optional

Specify the storage type of either FS or ASM.

• FS: File system storage type.

  When FS is specified, your database files are managed by the file system of your operating system. You can specify the directory path where the database files are to be stored using a database template or the -datafileDestination parameter. Oracle Database can create and manage the actual files.

• ASM: Oracle Automatic Storage Management (Oracle ASM) storage type.

  When ASM is specified, your database files are placed in Oracle ASM disk groups. Oracle Database automatically manages database file placement and naming.

  When ASM is specified, you can also specify the ASMSNMP password using the -asmsnmpPassword parameter. This parameter is optional.

• EXASCALE: Oracle Exascale storage type.

• PMEMFS: PMEMFS storage type.

The following additional parameters can be provided:

• -datafileDestination: Destination directory for all database files.

• -pmemMountPointPath: Mounted PMEM file store mount location.

• -pmemFSName: PMEM file store name.

• -pmemFSSizeDefinition: PMEM file store size definition. Specify value string such as InitialSize:ExtendSize:MaxSize E.G: -pmemFSSizeDefinition 8GB:16GB:100GB or -pmemFSSizeDefinition 2TB:8TB:UNLIMITED

-sysPassword

SYS_user_password

Optional

SYS user password for the new database.

-systemPassword

SYSTEM_user_password

Optional

SYSTEM user password for the new database.

-templateFromCloud

Optional

Creates a database using the clone template that is stored in Oracle Cloud Infrastructure. This option is supported only for Linux.

• opcLibPath: Directory in which the Oracle Database Cloud Backup Module for OCI is stored. The backup module is a system backup to tape (SBT) library that is used to integrate an on-premise database with Oracle Cloud Infrastructure.

  You must install the Oracle Database Cloud Backup Module for OCI before running this command.

• opcConfigFile: Name, with complete location, of the Oracle Database Cloud Backup Module for OCI configuration file. This file is created when you install the backup module.

• rmanDecryptionPassword: Password that must be used to decrypt the RMAN template file stored in Oracle Cloud Infrastructure. This is the same password that was used when creating an RMAN backup of the template.

See Administering Oracle Database Backup Cloud Service for information about installing and configuring the backup module.

-useOMF

{true | false}

Optional

Specify true to use Oracle-Managed Files (OMF), else specify false. Default is false.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-variables

variables_list

Optional

A comma-separated list of name=value pairs for the variables in the database template.

-variablesFile

variables_file

Optional

Name of the variables file with the complete directory path in the database template.

-enableForceLogging

{true | false}

Optional

Specify true to enable force logging at database level else specify false. Default is false.

-rmanParallelism

Optional

Specify the RMAN parallelism.

-sehaNodeList

Optional

Specify the node names separated by comma for the Standard Edition High Availability database.

Specify a value for the service name sehaServiceName.

-skipDatapatch

Optional

Specify the flag to skip data patch.

-useBigFileForTablespace

{true | false}

Optional

Specify true to enable bigfile property to all database tablespace or a comma-separated list of tablespace name:true|false pairs to enable or disable database tablespace bigfile property. For example: SYSTEM:false,SYSAUX:false,USERS:true.

Else, specify false. Default is false.

-gdbName global_database_name

Required

Global database name of the duplicate database in the form database_name.domain_name.

-remoteDBConnString easy_db_connection_string

Required

Easy connection string to connect to the database to be duplicated. Easy connection string must be in the following format:

"host[:port][/service_name][:server][/instance_name]"

-sid database_system_identifier

Required

Database system identifier (SID) of the duplicate database.

The SID uniquely identifies the instance that runs the database. If it is not specified, then it defaults to the database name.

-initParams

initialization_parameters_list

Optional

A comma-separated list of name=value pairs of initialization parameter values for the database.

You can additionally 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.

-sysPassword

SYS_user_password

Optional

SYS user password.

-adminManaged

Optional

Administrator-managed database.

Note: You can specify either policy-managed database or administrator-managed database.

-nodelist

database_nodes_list

Optional

For administrator-managed database, specify database nodes separated by comma.

-dgTNSNamesoraFilePath

data_guard_location

Optional

Specifies the location to create tnsnames.ora for configuration of Oracle Data Guard.

-datafileDestination

data_files_directory

Optional

Complete directory path for database data files.

-recoveryAreaDestination

fast_recovery_area_directory

Optional

Destination directory for the Fast Recovery Area, which is a backup and recovery area. Specify NONE to disable Fast Recovery Area.

Additionally, you can specify the Fast Recovery Area size in megabytes using the parameter -recoveryAreaSize. This parameter is optional.

-databaseConfigType

{SINGLE | RAC | RACONENODE}

Optional

Specify one of the following database configuration types:

• SINGLE: Single individual database.

• RAC: Oracle RAC database.

• RACONENODE: Oracle RAC One Node database.

  For Oracle RAC One Node database, you can specify the service name using the -RACOneNodeServiceName parameter.

-standbyBlobFileLocFromPrimaryDB

Optional

Specify the location of primary database blob file. You must then specify the passwordFileFromPrimaryDB option, for the password file location of primary database.

Specify primaryDBTdeWallet option for the location for TDE wallet of primary database.

-standbyScanName | -standbyHostName

Optional

Specify either of the options. Use the -standbyScanName option to specify a comma-separated list of SCAN names or SCAN IP addresses of standby database for Oracle Data Guard configuration. Use the -standbyHostName option to specify comma-separated list of host names or IP addresses of standby database host for Oracle Data Guard configuration in case of single-instance database.

-standbyScanPort | -standbyListenerPort

Optional

-createAsStandby

Optional

Specifies that the duplicate database is a standby database for the primary database.

Optionally, use the -dbUniqueName parameter to set the unique database name for the standby database. If the -dbUniqueName parameter is not specified, then the value of the DB_NAME initialization parameter is used.

-customScripts custom_sql_scripts_to_run_after_database_creation

Optional

A comma separated list of SQL scripts that should be run after the duplicate database is created. The scripts are run in the order listed.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

configureTDE

Optional

Specify true to configure TDE during the database creation. Only software wallets are supported. You can create a wallet for the entire CDB or for a PDB.

• encryptPDBTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example, SYSTEM:true,SYSAUX:false.

• encryptTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example, SYSTEM:true,SYSAUX:false.

• primaryDBTdeWallet: This option is not applicable when creating a database.

• sourceTdeWalletPassword: If the template that is being used is from a database that uses encryption, specify the password of the wallet in the source database.

• tdeAlgorithm: Algorithm used to encrypt data. Can be one of the following: 3DES168, AES128, AES192, AES256.

• tdeWalletLoginType: Type of software wallet. PASSWORD or AUTO_LOGIN or LOCAL_AUTO_LOGIN.

• tdeWalletPathInTarFile: Location in which the TDE wallet is stored.

• tdeWalletPassword: The password used to open the wallet. This parameter is mandatory.

• tdeWalletRoot: The location for the TDE wallet root initialization parameters.

Note: Isolated wallets are supported only in Oracle Cloud or Exadata environments.

-pdbName pdb_database_name

Required

-pdbSnapshotName pdb_snapshot_name

Required

Specifies the PDB snapshot name.

-sourceDB source_database

Required

Specifies the name of the source database.

-pdbName

name_of_the_pdb_to_create

Required

Name of the new PDB to create.

Note: For Oracle RAC databases, the PDB name must be unique in the cluster.

-sourceDB

cdb_sid

Required

The database system identifier (SID) of the CDB.

configureTDE

Optional

Specify true to configure TDE during the database creation. Only software wallets are supported. You can create a wallet for the entire CDB or for a PDB.

• -encryptPDBTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -encryptTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• primaryDBTdeWallet: This option is not applicable when creating a database.

• sourceTdeWalletPassword: If the template that is being used is from a database that uses encryption, or if you are duplicating a database, specify the password of the wallet in the source database.

• -tdeWalletPathInTarFile: Specify the TDE wallet path in the tar file.

• tdeAlgorithm: Algorithm used to encrypt data. Can be one of the following: 3DES168, AES128, AES192, AES256.

• tdeWalletLoginType: Type of software wallet. PASSWORD or AUTO_LOGIN or LOCAL_AUTO_LOGIN.

• tdeWalletLocation: Location in which the TDE wallet is stored.

• tdeWalletPassword: The password used to open the wallet. This parameter is mandatory.

• -tdeWalletRoot: Specify the location for TDE wallet root init parameter.

Note: Isolated wallets are supported only in Oracle Cloud or Exadata environments.

-createAsClone

{true | false}

Optional

Specify true if the files you plan to use to create the new PDB are the same files that were used to create an existing PDB. Specifying true ensures that Oracle Database generates unique PDB DBID, GUID, and other identifiers expected for the new PDB.

Specify false, the default, if the files you plan to use to create the new PDB are not the same files that were used to create an existing PDB.

-createFromRemotePDB

Optional

Create a PDB by cloning a remote PDB.

Specify the following parameters:

• -remotePDBName: Name of the remote PDB to clone.

• -remoteDBConnString: Database connection string of the remote PDB.

• -createAsRefreshablePDB: Value can be true or false. Specify true to create the pluggable database as a refreshable PDB.

• -refreshInterval: Specify time interval in minutes to perform automatic refresh of the PDB.

• -refreshMode: AUTO|MANUAL Specify the refresh mode of the pluggable database.

• -createNewPDBAdminUser: Specify this argument if a new PDB Administrator user needs to be created after plugging in PDB from Archive or File Set.

• -createPDBInStandby: Value can be true or false. Specify true to create PDB in standby database.

• -enableAutomaticSnapshot: Option to enable automatic backup in a PDB.

• -snapshotIntervalInMins: Specify interval in minutes for automatic snapshot creation.

• -maxPDBSnapshots: Specify maximum number of snapshots to be retained during automatic snapshot creation.

• -pdbInitParams: Specify PDB specific initialization parameters.Comma-separated list of name=value pairs.

• -initParamsEscapeChar: Specify escape character for comma when a specific initialization parameter has multiple values. If the escape character is not specified, then backslash is the default escape character.

• -pdbNodelist: Specify the PDB nodelist.

• -skipPdbServiceCreation: Flag to skip the PDB service creation.

• -pdbReadOnlyServiceName: Specify the name of the PDB read-only service to be created on Oracle Data Guard configuration.

• -pdbServiceName: Specify the name of the PDB service to be created.

• -sysDBAUserName: Name of the SYSDBA user.

• -sysDBAPassword: Password of the SYSDBA user.

• -dbLinkName: Name of the database that connects to the remote PDB.

• -dbLinkUsername: Name of the database link user of the remote PDB.

• -dbLinkUserPassword: Password of the database link user of the remote PDB.

• -excludePDBData: Specify if you want to exclude PDB data.

• -excludePDBTablespaces: Specify if you want to exclude PDB tablespace.

• -pdbAdminPassword: Password of the PDB admin.

• -pdbAdminUserName: User name of the PDB admin.

• -remoteDBSYSDBAUserName: User name with SYSDBA privileges of remote database.

• -remoteDBSYSDBAUserPassword: Password for remote DB SYSDBA user of remote database.

• -remotePDBExportedTDEKeyFile: TDE key of the remote PDB.

• -remotePDBExportedTDEKeyPassword: Password for the TDE key of the remote PDB.

• -skipDatapatch: Flag to skip the data patch run.

• -sourcePDBServiceConvertList: Specify comma-separated list of source PDB services with new service name. For example, service_1:new_service_1,service_2:new_service_2

• -updateDBBlockCacheSize: Option to enable application to set db block cache size initialization parameters in order to support data copy with different block size.

Note:

• The database user of the local CDB must have the CREATE PLUGGABLE DATABASE privileges in the root container.

• The remote CDB must be in the local undo mode.

• The remote PDB must be in the archivelog mode.

• The database user of the remote PDB to which the database link connects to must have the CREATE PLUGGABLE DATABASE and CREATE SESSION privileges.

-createFromSnapshot | -snapshot

Optional

Create a PDB from a snapshot.

Specify the following parameters:

• -pdbSnapshotName: Name of the PDB snapshot.

• -copyDataFiles: Value can be true or false. Specify true to skip snapshot copy.

Specify -snapshot option to clone a PDB by thin clone.

-createPDBFrom

{DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML | PDB}

Optional

Specify DEFAULT to create the PDB from the CDB's seed. When you specify DEFAULT, the following additional parameters are required:

• -pdbAdminUserName: The user name of the PDB's local administrator.

• -pdbAdminPassword: The password for the PDB's local administrator.

Specify FILEARCHIVE to create the PDB from an unplugged PDB's files. When you specify FILEARCHIVE, the following additional parameters are required:

• -pdbArchiveFile: Complete path and name for unplugged PDB's archive file.

  The archive file contains all of the files for the PDB, including its XML metadata file and its data files. Typically, the archive file has a .gz extension.

• -createNewPDBAdminUser: Specify true to create a new PDB administrator or false to avoid creating a new PDB administrator.

• -workArea: Specify the directory location where the PDB archive files need to be unzipped.

Specify RMANBACKUP to create the PDB from a Recovery Manager (RMAN) backup. When you specify RMANBACKUP, the following additional parameters are required:

• -pdbBackUpfile: Complete path and name for the PDB backup file.

• -pdbMetadataFile: Complete path and name for the PDB's XML metadata file.

Specify USINGXML to create the PDB from an unplugged PDB's XML metadata file. When you specify USINGXML, the following additional parameter is required:

• -pdbMetadataFile: Complete path and name for the PDB's XML metadata file.

Specify PDB to create a new PDB by cloning an existing PDB. When you specify PDB, the following additional parameter is required:

• -sourcePDB: Name of an existing PDB to clone.

Specify the following optional parameters, if required:

• -sourceFileNameConvert: This parameter specifies how to locate PDB files listed in the PDB XML metadata file.

  See SOURCE_FILE_NAME_CONVERT clause of the CREATE PLUGGABLE DATABASE statement described in Oracle Multitenant Administrator's Guide.

• -fileNameConvert: This parameter specifies the names of the PDB’s files.

  See FILE_NAME_CONVERT clause of the CREATE PLUGGABLE DATABASE statement described in Oracle Multitenant Administrator's Guide.

• -pdbStorageMAXSizeInMB: Specify the maximum storage size for the PDB in megabytes.

  See information about PDB storage described in Oracle Multitenant Administrator's Guide.

• -pdbStorageMAXTempSizeInMB: Specify the maximum temporary storage size for the PDB in megabytes.

• -copyPDBFiles {true | false}: Specify true if the PDB data files need to be copied, else specify false.

-createUserTableSpace

{true | false}

Optional

Specify true if a default user tablespace needs to be created in the new PDB.

-customScripts

lcustom_sql_scripts_to_run_after_PDB_creation

Optional

Specify a list of custom SQL scripts to run after the PDB creation.

-dvConfiguration

{true | false}

Optional

Specify true to enable and configure Database Vault, else specify false. Default is false.

When true is specified, the following additional Database Vault parameters are required:

• -dvUserName: Specify the Database Vault owner name.

• -dvUserPassword: Specify Database Vault owner password.

• -dvAccountManagerName: Specify a separate Database Vault account manager name.

• -dvAccountManagerPassword: Specify the Database Vault account manager password.

-lbacsysPassword

LBACSYS_user_password

Optional

Specify the LBACSYS user password if you want to configure OLS with a directory service.

-pdbDatafileDestination

pdb_data_files_directory

Optional

Compete directory path to the new PDB data files.

When this parameter is not specified, either Oracle Managed Files or the PDB_FILE_NAME_CONVERT initialization parameter specifies how to generate the names and locations of the files. If you use both Oracle Managed Files and the PDB_FILE_NAME_CONVERT initialization parameter, then Oracle Managed Files takes precedence.

When this parameter is not specified, Oracle Managed Files is not enabled, and the PDB_FILE_NAME_CONVERT initialization parameter is not set, by default a path to a subdirectory with the name of the PDB in the directory for the root's files is used.

-pdbStorageMAXSizeInMB

maximum_storage_size_for_the_pdb_in_MB

Optional

Specify the maximum storage size for the PDB in megabytes.

-pdbStorageMAXTempSizeInMB

maximum_temporary_storage_size_for_the_pdb_in_MB

Optional

Specify the maximum temporary storage size for the PDB in megabytes.

Optional

Use this parameter to specify the time zone of the PDB.

-pdbUseMultipleBackup

number_of_pdb_backups_to_create

Optional

Specify the number of PDB backups to create.

-registerWithDirService

{true | false}

Optional

Specify true to register the PDB with a Lightweight Directory Access Protocol (LDAP) service, else specify false. Default is false.

When true is specified, the following additional parameters are required:

• -dirServiceUserName: User name for the LDAP service.

• -dirServicePassword: Password for the LDAP service.

• -dirServiceUser: User name for the Active Directory account.

• -dirServiceCertificatePath: Certificate file path of the directory service.

• -databaseCN: Common name of the directory service database.

• -walletPassword: Password for the database wallet.

-useMetaDataFileLocation

{true | false}

Optional

Specify true to use the data file path defined in XML metadata file within a PDB archive when extracting data files.

Specify false, the default, to not use the data file path defined in XML metadata file within a PDB archive when extracting data files.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-pdbTDEKeyTransportSecret value

Required

Name of the PDB TDE key transport secret.

-sourceDB source_database_sid

Required

The source database system identifier (SID).

-templateName new_database_template_name

Required

Name of the new database template.

-sysDBAUserName SYSDBA_user_name

Optional

User name of a user that has SYSDBA privileges.

-sysDBAPassword SYSDBA_user_password

Optional

Password of the user that has SYSDBA privileges.

-maintainFileLocations {true | false}

Optional

Specify true to use the file locations of the database in the template.

Specify false, the default, to use different file locations in the template. The file locations are determined by Oracle Flexible Architecture (OFA).

-connectionString easy_connect_string

Optional

Easy connect string for connecting to a remote database in the following format:

"host[:port][/service_name][:server][/instance_name]"

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-sourceTemplateName

existing_template_name

Required

Name of an existing database template in the default location or the complete path to a database template that is not in the default location.

-templateName

new_template_name

Required

Name for a new database template.

-variables

variables_list

Optional

A comma-separated list of name=value pairs for the variables in the database template.

-characterSet

database_character_set

Optional

Character set of the database.

-nationalCharacterSet

database_national_character_set

Optional

National character set of the database.

-recoveryAreaDestination

fast_recovery_area_directory

Optional

Directory path for the Fast Recovery Area, which is a backup and recovery area.

-datafileDestination

data_files_directory

Optional

Directory path for the data files.

-useOMF

{true | false}

Optional

Specify true to use Oracle-Managed Files (OMF), else specify false.

-datafileJarLocation

database_backup_files_directory

Optional

Location of the database offline backup (for clone database creation only).

The data files for the seed database are stored in compressed RMAN backup format in a file with a .dfb extension.

-memoryPercentage

percentage_of_total_memory_to_assign_to_oracle_database

or

-totalMemory

total_memory_to_assign_to_oracle_database

Optional

Specify either -memoryPercentage or -totalMemory .

• -memoryPercentage

  The percentage of physical memory that can be used by the database.

• -totalMemory

  The amount of physical memory in megabytes that can be used by the database.

-dbOptions

database_options

Optional

Specify database options as comma separated list of name:value pairs.

Example: JSERVER:true,DV:false

-variablesFile

variables_file

Optional

File name with complete directory path to the file that contains the variables and their values in the database template.

-redoLogFileSize

redo_log_file_size

Optional

Size of each online redo log file in megabytes.

-initParams

initialization_parameters_list

Optional

A comma-separated list of name=value pairs of the database initialization parameters and their values.

-storageType

{FS | ASM | EXASCALE | PMEMFS}

Optional

Specify FS for file system and ASM for Oracle Automatic Storage Management (Oracle ASM) system.

When FS is specified, your database files are managed by the file system of your operating system. You specify the directory path where the database files are to be stored using the -datafileDestination parameter.

When ASM is specified, your database files are placed in the Oracle ASM disk groups. Oracle Database automatically manages database file placement and naming. You also specify the ASMSNMP password for ASM monitoring using the -asmsnmpPassword parameter.

EXASCALE: Oracle Exascale storage type.

PMEMFS: PMEMFS storage type.

The following additional parameters can be provided:

• -datafileDestination: Destination directory for all database files.

• -pmemMountPointPath: Mounted PMEM file store mount location.

• -pmemFSName: PMEM file store name.

• -pmemFSSizeDefinition: PMEM file store size definition. Specify value string such as InitialSize:ExtendSize:MaxSize E.G: -pmemFSSizeDefinition 8GB:16GB:100GB or -pmemFSSizeDefinition 2TB:8TB:UNLIMITED

-useBigFileForTablespace

{true | false}

Optional

Specify true to enable bigfile property to all database tablespace or a comma-separated list of tablespace name:true|false pairs to enable or disable database tablespace bigfile property. For example: SYSTEM:false,SYSAUX:false,USERS:true.

Else, specify false. Default is false.

-enableArchive

{true | false}

Optional

Specify true to enable log file archive. Default is false.

When true is specified, the following additional parameters can be provided:

• -archiveLogMode {AUTO | MANUAL}: Specify either the automatic archive mode (AUTO) or the manual archive mode (MANUAL). Default is automatic archive mode (AUTO).

• -archiveLogDest: Directory path for storing the archive log files.

-memoryMgmtType

{AUTO | AUTO_SGA | CUSTOM_SGA}

Optional

Specify one of the following memory management types:

• AUTO: Automatic memory management for SGA and PGA.

• AUTO_SGA: Automatic shared memory management for SGA.

• CUSTOM_SGA: Manual shared memory management for SGA.

Note: If the total physical memory of a database instance is greater than 4 GB, then you cannot specify the Automatic Memory Management option AUTO during the database installation and creation. Oracle recommends that you specify the Automatic Shared Memory Management option AUTO_SGA in such environments.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-dbUniqueName

true_cache_unique_name

or

-gdbName

true_cache_global_name

-sourceDBConnectionString

primary_db_easy_connect_string

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

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

-datafileDestination

true_cache_control_file_path

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

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

-pgaAggregateTargetInMB

pga_memory_size

-sgaTargetInMB

sga_memory_size

-sid

true_cache_sid

-sourceTdeWalletPassword

primary_db_wallet_password

-tdeWalletLoginType

{PASSWORD | AUTO_LOGIN | LOCAL_AUTO_LOGIN}

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

-useWalletForDBCredentials

{true | false}

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.

-sourceDB database_name_or_sid

Required

Database unique name for an Oracle RAC database or database system identifier (SID) for a single instance database.

-sysDBAUserName SYSDBA_user_name

Optional

User name of the user having the SYSDBA privileges.

-sysDBAPassword SYSDBA_password

Optional

Password of the user having the SYSDBA privileges.

-tdeWalletPassword

Optional

Specify password for TDE wallet.

-forceArchiveLogDeletion

Optional

Specify this parameter to delete the database archive logs.

-deRegisterEMCloudControl

Optional

Specify this parameter along with the following parameters to unregister the database with Enterprise Manager Cloud Control:

• -omsHost: Oracle Management Server host name.

• -omsPort: Oracle Management Server port number.

• -emUser: User name for Enterprise Manager administrator.

• -emPassword: Password for Enterprise Manager administrator.

-unregisterWithDirService {true | false}

Optional

Specify this parameter along with the following parameters to unregister the database with the directory service:

• -dirServiceUserName: User name for the directory service.

• -dirServicePassword: Password for the directory service user.

• -walletPassword: Password for the database wallet.

-sid database_system_identifier

Optional

Database system identifier (SID).

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-gdbName global_database_name

Required

Global database name in the form database_name.domain_name.

-instanceName database_instance_name

Required

Database instance name.

-nodeName node_name_of_database_instance

Optional

Node name of the database instance.

-sysDBAUserName SYSDBA_user_name

Optional

User name of the database user having the SYSDBA privileges.

-sysDBAPassword SYSDBA_user_password

Optional

Password of the database user having the SYSDBA privileges.

-updateDirService

{true | false}

Optional

Specify true to unregister the database with the directory service, else specify false. Default is false.

When true is specified, the following additional parameters are required:

• -dirServiceUserName: User name for the directory service.

• —dirServicePassword: Password for the directory service user.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-pdbName pdb_database_name

Required

-pdbSnapshotName pdb_snapshot_name

Required

Specifies the PDB snapshot name.

-sourceDB source_database

Required

Specifies the name of the source database.

-sourceDB cdb_sid

Required

The database system identifier (SID) of the CDB.

-pdbName pdb_name

Required

Name of the PDB to delete.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters must be provided:

• -dbCredentialsWalletPassword (Optional): Password for the Oracle Wallet account. If you omit this parameter, DBCA prompts for the password.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-tdeWalletPassword

Optional

Specify password for TDE wallet.

-unregisterWithDirService {true | false}

Optional

Specify this parameter along with the following parameters to unregister the database with the directory service:

• -dirServiceUserName: User name for the directory service.

• -dirServicePassword: Password for the directory service user.

• -walletPassword: Password for the database wallet.

-templateName

name_of_an_existing_database_template

Required

Name of an existing database template to delete. Specify an existing template in default location or the complete template path for database creation or provide a new template name for template creation.

-templateFromCloud

Optional

Indicates that the template is a Cloud template.

• opcLibPath: Provide the directory containing the odbsrmt.py script for the delete template operation or provide the directory containing libopc.so.

• opcConfigFile: Specify the OPC configuration file.

• rmanDecryptionPassword: Password that must be used to decrypt the RMAN template file stored in Oracle Cloud Infrastructure. This is the same password that was used when creating an RMAN backup of the template.

-databaseConfigType {SINGLE | RAC | RACONENODE}

Required

Specify one of the following database configuration types:

• SINGLE: Single individual database.

• RAC: Oracle RAC database.

• RACONENODE: Oracle RAC One Node database.

  For Oracle RAC One Node database, you can specify the service name using the -RACOneNodeServiceName parameter.

-nodelist

database_nodes_list

Optional

List of database nodes separated by comma.

-templateName database_template_name

Required

Name of an existing database template in the default location or the complete path of a template that is not in the default location.

-gdbName global_database_name

Required

Global database name in the form database_name.domain_name.

-sid

database_system_identifier

Optional

Database system identifier (SID).

The SID uniquely identifies the instance that runs the database. If it is not specified, then it defaults to the database name.

-scriptDest scripts_directory

Optional

Complete directory path to store the scripts.

-createAsContainerDatabase

{true | false}

Optional

Specify true to create a CDB. Specifying false is not supported starting with Oracle Database Release 21c.

When true is specified, the following optional parameters can be provided:

• -numberOfPDBs: Number of PDBs to create. Default is 0 (zero).

• -pdbName: Name of each PDB. A number is appended to each PDB name if -numberOfPDBs value is greater than 1. This parameter must be specified if -numberOfPDBs value is greater than 0 (zero).

• -pdbStorageMAXSizeInMB: Maximum storage size for a PDB in megabytes.

• -pdbStorageMAXTempSizeInMB: Maximum temporary storage size for a PDB in megabytes.

• -useLocalUndoForPDBs {true | false}: Flag indicating whether local undo should be used for the PDBs.

• -pdbAdminPassword: PDB administrator password.

• -pdbOptions: PDB options in the form of comma separated list. Each option must be specified in the name:value format.

  Example: JSERVER:true,DV:false

-sysPassword

SYS_user_password

Optional

SYS user password for the new database.

-systemPassword

SYSTEM_user_password

Optional

SYSTEM user password for the new database.

-emConfiguration

{CENTRAL | NONE}

Optional

Enterprise Manager configuration settings.

When CENTRAL is specified, specify the following additional parameters:

• -dbsnmpPassword: DBSNMP user password.

• -omsHost: Oracle Management Server host name.

• -omsPort: Oracle Management Server port number.

• -emUser: User name for Enterprise Manager administrator.

• -emPassword: Password for Enterprise Manager administrator.

-dvConfiguration

{true | false}

Optional

Specify true to enable and configure Database Vault, else specify false. Default is false.

When true is specified, the following additional Database Vault parameters are required:

• -dvUserName: Database Vault owner name.

• -dvUserPassword: Database Vault owner password.

• -dvAccountManagerName: Database Vault account manager name.

• -dvAccountManagerPassword: Database Vault account manager password.

-olsConfiguration

{true | false}

Optional

Specify true to enable and configure Oracle Label Security (OLS), else specify false. Default is false.

When true is specified, you can additionally specify the -configureWithOID parameter to configure Oracle Label Security (OLS) with Oracle Internet Directory (OID). This parameter is optional.

-datafileDestination

data_files_directory

Optional

Complete path to the location of the database's data files.

-redoLogFileSize

maximum_size_of_online_redo_log

Optional

Size of each online redo log file in megabytes.

-recoveryAreaDestination

fast_recovery_area_directory

Optional

Directory for the Fast Recovery Area, which is a backup and recovery area. Specify NONE to disable the Fast Recovery Area.

Additionally, you can specify the Fast Recovery Area size in megabytes using the parameter -recoveryAreaSize. This parameter is optional.

-datafileJarLocation

data_files_backup_directory

Optional

Directory of the database backup data files in a compressed RMAN backup format (files with .dfb extensions).

-responseFile

response_file_directory

Optional

Directory path of the response file.

-storageType

{FS | ASM}

Optional

Specify the storage type of either FS or ASM.

• FS: File system storage type.

  When FS is specified, your database files are managed by the file system of your operating system. You can specify the directory path where the database files are to be stored using a database template or the -datafileDestination parameter. Oracle Database can create and manage the actual files.

• ASM: Oracle Automatic Storage Management (Oracle ASM) storage type.

  When ASM is specified, your database files are placed in Oracle ASM disk groups. Oracle Database automatically manages database file placement and naming.

  When ASM is specified, you can also specify the ASMSNMP password using the -asmsnmpPassword parameter. This parameter is optional.

-runCVUChecks

{true | false}

Optional

Specify true to run Cluster Verification Utility checks periodically for Oracle RAC databases, else specify false. Default is false.

-nodelist

database_nodes_list

Optional

List of database nodes separated by comma.

-enableArchive

{true | false}

Optional

Specify true to enable log file archive, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -archiveLogMode {AUTO | MANUAL}: Specify either the automatic archive mode or the manual archive mode. Default is automatic archive mode.

• -archiveLogDest: Directory for storing the archive log files.

-memoryMgmtType

{AUTO | AUTO_SGA | CUSTOM_SGA}

Optional

Specify one of the following memory management types:

• AUTO: Automatic memory management for SGA and PGA.

• AUTO_SGA: Automatic shared memory management for SGA.

• CUSTOM_SGA: Manual shared memory management for SGA.

Note: If the total physical memory of a database instance is greater than 4 GB, then you cannot specify the Automatic Memory Management option AUTO during the database installation and creation. Oracle recommends that you specify the Automatic Shared Memory Management option AUTO_SGA in such environments.

-createListener

new_database_listener

Optional

Database listener to register the database with in the form listener_name:port.

-useOMF

{true | false}

Optional

Specify true to use Oracle-Managed Files (OMF), else specify false.

-dbOptions

database_options

Optional

Specify database options as a comma separated list of name:value pairs.

Example: JSERVER:true,DV:false

-customScripts

custom_sql_scripts_list

Optional

Specify a comma separated list of SQL scripts that need to be run after the database creation. The scripts are run in the order they are listed.

-adminManaged

Optional

Administrator-managed database.

-databaseConfigType

{SINGLE | RAC | RACONENODE}

Optional

Specify one of the following database configuration types:

• SINGLE: Single individual database.

• RAC: Oracle RAC database.

• RACONENODE: Oracle RAC One Node database.

  For Oracle RAC One Node database, you can specify the service name using the -RACOneNodeServiceName parameter.

-characterSet

database_character_set

Optional

Character set of the database.

-nationalCharacterSet

database_national_character_set

Optional

National character set of the database.

-registerWithDirService

{true | false}

Optional

Specify true to register with a Lightweight Directory Access Protocol (LDAP) service, else specify false. Default is false.

When true is specified, the following additional parameters are required:

• -dirServiceUserName: User name for the LDAP service.

• -dirServicePassword: Password for the LDAP service.

• -databaseCN: Database common name.

• -dirServiceCertificatePath: Directory service certificate file path.

• -dirServiceUser: Directory service user name.

• -ldapDirectoryAccessType {PASSWORD | SSL}: LDAP directory access type.

• -useSYSAuthForLDAPAccess {true | false}: Specify whether to use SYS user authentication for LDAP acces.

• -walletPassword: Password for the database wallet.

-listeners

listeners_list

Optional

A comma-separated list of listeners for the database.

-variablesFile

variables_file

Optional

Directory path to the file that contains the variables and their values for the database template.

-variables

variables_list

Optional

A comma-separated list of name=value pairs of variables for the database template.

-initParams

initialization_parameters_list

Optional

A comma-separated list of name=value pairs of initialization parameter values of the database.

You can additionally 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.

-sampleSchema

{true | false}

Optional

Specify true to include the HR sample schema (EXAMPLE tablespace) in your database, else specify false. Default is false.

Oracle guides and educational materials contain examples based on the sample schemas. Oracle strongly recommends that you do not install the sample schemas in a production database.

-memoryPercentage

percentage_of_total_memory_assigned_to_the_database

Optional

The percentage of physical memory that can be used by the database.

-totalMemory

total_memory_assigned_to_the_database_in_MB

Optional

Total amount of physical memory, in megabytes, that can be used by the database.

-databaseType

{MULTIPURPOSE | DATA_WAREHOUSING | OLTP}

Optional

Specify MULTIPURPOSE if the database is for both OLTP and data warehouse purposes.

Specify DATA_WAREHOUSING if the primary purpose of the database is a data warehouse.

Specify OLTP if the primary purpose of the database is online transaction processing.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

configureTDE

Optional

Specify true to configure TDE during the database creation. Only software wallets are supported. You can create a wallet for the entire CDB or for a PDB.

• primaryDBTdeWallet: This option is not applicable when creating a database.

• sourceTdeWalletPassword: If the template that is being used is from a database that uses encryption, or if you are duplicating a database, specify the password of the wallet in the source database.

• tdeAlgorithm: Algorithm used to encrypt data. Can be one of the following: 3DES168, AES128, AES192, AES256.

• tdeWalletLoginType: Type of software wallet. PASSWORD or AUTO_LOGIN or LOCAL_AUTO_LOGIN.

• tdeWalletLocation: Location in which the TDE wallet is stored.

• tdeWalletPassword: The password used to open the wallet. This parameter is mandatory.

• -encryptPDBTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -encryptTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -tdeWalletPathInTarFile: Specify the TDE wallet path in the tar file.

Note: Isolated wallets are supported only in Oracle Cloud or Exadata environments.

-sehaNodeList

Optional

Specify the node names separated by comma for the Standard Edition High Availability database.

Specify a value for the service name sehaServiceName.

-storageType

{FS | ASM | EXASCALE | PMEMFS}

Optional

Specify the storage type of either FS or ASM.

• FS: File system storage type.

  When FS is specified, your database files are managed by the file system of your operating system. You can specify the directory path where the database files are to be stored using a database template or the -datafileDestination parameter. Oracle Database can create and manage the actual files.

• ASM: Oracle Automatic Storage Management (Oracle ASM) storage type.

  When ASM is specified, your database files are placed in Oracle ASM disk groups. Oracle Database automatically manages database file placement and naming.

  When ASM is specified, you can also specify the ASMSNMP password using the -asmsnmpPassword parameter. This parameter is optional.

• EXASCALE: Oracle Exascale storage type.

• PMEMFS: PMEMFS storage type.

The following additional parameters can be provided:

• -datafileDestination: Destination directory for all database files.

• -pmemMountPointPath: Mounted PMEM file store mount location.

• -pmemFSName: PMEM file store name.

• -pmemFSSizeDefinition: PMEM file store size definition. Specify value string such as InitialSize:ExtendSize:MaxSize E.G: -pmemFSSizeDefinition 8GB:16GB:100GB or -pmemFSSizeDefinition 2TB:8TB:UNLIMITED

-registerUser

Option to register SSO user in Patch Planner service.

-unregisterUser

Option to deregister SSO user from Patch Planner service.

-checkPatchStatus

Option to check the health of the Oracle home.

-generateGoldImage

Option to generate gold image with the required Release Update (RU).

-downloadGoldImage

Option to download the newly-built gold image to specified location.

-sourceDB database_sid

Required

Database unique name for Oracle RAC database or SID for single-instance database.

-continueWithDBDowntime

Optional

Specifies the flag to indicate the move operation with database downtime when there is only one active instance running.

Optional

Specify the comma-separated list of absolute directory paths that are to be copied from source Oracle home to target Oracle home.

-drainTimeoutInSeconds

Optional

Specify time in seconds to complete the resource draining while stopping the database.

-filePathsToCopy

Optional

Specify the A comma-separated list of absolute file paths that are to be copied from source Oracle home to target Oracle home.

-listenersToMove

Optional

Specify the comma-separated list of listeners that are to be moved.

-nodeListForMove

Optional

Specify the comma-separated list of nodes if operation has to be performed on subset of nodes.

-nonRolling

Optional

Specify the flag to indicate the database move would be performed by shutting down the database.

-oracleHomeUserPassword

Optional

Specify the Oracle home user password.

-postMoveScripts SYSDBA_user_password

Optional

Specify the comma-separated list of scripts to be run post move database. The scripts are run in the order they are listed.

Use the -postRollbackScripts SYSDBA_user_name option to specify the comma-separated list of scripts to be run post move database rollback. The scripts are run in the order they are listed.

-resume

Optional

Resume the previous operation.

-sessionID

Optional

Specify the session ID of the failed session.

-revert

Optional

Revert the previous operation.

-skipClosedPDBs

Optional

Specify the flag to skip the datapatch on closed PDBs.

-skipDatapatch

Optional

Specify the flag to skip the datapatch run.

-continueWithDBDowntime

Optional

Specify the flag to indicate the move operation with database downtime when there is only one active instance running.

-doNotEnableTwoStagePatches

Optional

Specify this flag to not enable two stage patches.

-errorOnMissingPatches

Optional

Specify this flag to stop the move operation in case of missing patches in target Oracle home.

Use the -exceptionPatchList option to specify the list of patch IDs to be ignored when checking missing patches in target Oracle home.

-skipMissingPatchValidation

Optional

Specify this flag to proceed with move operation in case of missing patches in target Oracle home.

-skipPDBs

Optional

Specify the comma-separated list of PDBs to be skipped for current operation.

-sqlnetConfigPreference {SOURCE | TARGET}

Optional

Specify the sqlnet.ora file move preference.

-sysDBAPassword

Optional

Specify the password for sysDBAUserName user name.

-sysDBAUserName

Optional

Specify the user name with SYSDBA privileges.

-pdbName name_of_the_local_pdb_to_create

Required

Name of the local PDB to create after relocating the remote PDB.

-sourceDB database_name_of_the_local_pdb

Required

Database name of the local PDB.

-remotePDBName name_of_the_remote_pdb_to_relocate

Required

Name of the remote PDB to relocate.

-remoteDBConnString db_connection_string_of_the_remote_pdb

Required

Database connection string of the remote PDB.

-sysDBAUserName name_of_the_sysdba_user

Optional

Name of the SYSDBA user.

-sysDBAPassword password_of_the_sysdba_user

Optional

Password of the SYSDBA user.

-dbLinkUsername name_of_the_dblink_user_of_the_remote_pdb

Optional

Name of the database link user of the remote PDB.

-dbLinkUserPassword password_of_the_dblink_user_of_the_remote_pdb

Optional

Password of the database link user of the remote PDB.

-configureTDE{true | false}

Optional

Specify true to configure TDE wallet. Default is false.

When true is specified, the following additional parameters can be provided:

• -encryptPDBTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -encryptTablespaces: Specify ALL to encrypt all tablespaces or a comma-separated list of name:value pairs with tablespace encryption to true or false. For example: SYSTEM:true,SYSAUX:false.

• -primaryDBTdeWallet: Specify the location for TDE wallet of primary database.

• -sourceTdeWalletPassword: Specify password for source database TDE wallet.

• -tdeAlgorithm: Specify the TDE algorithm type.

• -tdeWalletLoginType: Specify the TDE wallet login type, PASSWORD | AUTO_LOGIN | LOCAL_AUTO_LOGIN. The default is PASSWORD for single-instance database and AUTO_LOGIN for Oracle RAC database.

• -tdeWalletPassword: Specify password for TDE wallet.

• -tdeWalletPathInTarFile: Specify the TDE wallet path in the tar file.

• -tdeWalletRoot: Specify the location for TDE wallet root init parameter.

-createNewPDBAdminUser

Optional

Specify this argument if a new PDB Administrator user needs to be created after plugging in PDB from Archive or File Set.

-dbLinkName

Optional

Name of the database that connects to the remote PDB.

-pdbAdminPassword

Optional

Specify PDB Administrator user password, required only while creating new PDB.

-pdbAdminUserName

Optional

Specify PDB Administrator user name, required only while creating new PDB.

-pdbInitParams

Optional

Specify PDB specific initialization parameters as comma-separated list of name=value pairs.

-initParamsEscapeChar: Specify escape character for comma when a specific initialization parameter has multiple values. If the escape character is not specified, then backslash is the default escape character.

-pdbNodelist

Optional

Specify PDB node list.

-pdbReadOnlyServiceName

Optional

Specify the name of the PDB read-only service to be created on Oracle Data Guard configuration.

-pdbServiceName

Optional

Specify the name of the PDB service.

-pdbStorageMAXSizeInMB

Optional

Specify the maximum storage size for the PDB in megabytes.

-pdbStorageMAXTempSizeInMB

Optional

Specify the maximum temporary storage size for the PDB in megabytes.

-remoteDBSYSDBAUserName

Optional

Specify the user name with SYSDBA privileges of remote database.

-remoteDBSYSDBAUserPassword

Optional

Specify the password for remote DB SYSDBA user of remote database.

-skipDatapatch

Optional

Flag to skip the data patch run.

-skipPdbServiceCreation

Optional

Flag to skip the PDB service creation.

-sourcePDBReadOnlyServices

Optional

Comma-separated source PDB read-only services.

-sourcePDBServices

Optional

Comma-separated source PDB services.

-updateDBBlockCacheSize

Optional

Option to enable application to set db block cache size initialization parameters in order to support data copy with different block size.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

-sourceDB cdb_sid

Required

The database system identifier (SID) of the CDB.

-pdbName pdb_name

Required

Name of the PDB.

-maxBackupSetSizeInMB

Optional

Specifies the maximum backup set size in MB.

-archiveType {TAR | RMAN | NONE}

Optional

Specify TAR to store the unplugged PDB files in a tar file.

Specify RMAN to store the unplugged PDB files in an RMAN backup.

Specify NONE to store the unplugged PDB files without using a tar file or an RMAN backup.

Specify any of the following parameters:

• -pdbArchiveFile: Specify absolute file path and name for the PDB Archive file.

• -pdbBackUpfile: Specify absolute file path and name for the PDB backup file when archive type is RMAN. specify comma separated file paths, if there are multiple backups to be taken when creating the PDB.

• -pdbMetadataFile: Specify absolute file path and name for the PDB metadata file when archive type is RMAN or NONE.

• -rmanParallelism: Specify the RMAN parallelism integer value.

-unregisterWithDirService {true | false}

Optional

Specify true to unregister the PDB from the LDAP service, else specify false. Default is false.

When true is specified, the following additional parameters are required:

• -dirServiceUserName: User name for the LDAP service.

• -dirServicePassword: Password for the LDAP service user.

• -walletPassword: Password for the database wallet.

-useWalletForDBCredentials

{true | false}

Optional

Specify true to use Oracle Wallet for database credentials, else specify false. Default is false.

When true is specified, the following additional parameters can be provided:

• -dbCredentialsWalletPassword: Password for the Oracle Wallet account.

• -dbCredentialsWalletLocation: Directory location for the Oracle Wallet files.

Note:

If you are using Oracle Unified Directory (OUD), then the OUD passwords should be stored in the wallet using the following keys:

• oracle.dbsecurity.walletPassword

• oracle.dbsecurity.userDNPassword

-pdbTDEKeyTransportSecret value

Required

Name of the PDB TDE key transport secret.

-tdeWalletPassword value

Required

Specify the TDE wallet password.