1. Move to Oracle Cloud Using Zero Downtime Migration
  2. Zero Downtime Migration Hybrid Migration Response File Parameters Reference

G Zero Downtime Migration Hybrid Migration Response File Parameters Reference

The following topics describe the Zero Downtime Migration response file parameters used in hybrid migrations.

G.1 MIGRATION_METHOD

Specifies the method of migration.

Property Description

Syntax

MIGRATION_METHOD = {OFFLINE_XTTS}

Default value

OFFLINE_XTTS

Range of values

OFFLINE_XTTS

Required

Yes

Modifiable on Resume

No

G.2 DATA_TRANSFER_MEDIUM

Specifies how data will be transferred from the source database system to the target database system.

See also Configuring the Transfer Medium and Specifying Transfer Nodes

Property Description

Syntax

DATA_TRANSFER_MEDIUM = { NFS }

Default value

NFS

Range of values

NFS - Network File System

Required

Yes

Modifiable on Resume

No

G.3 TARGETDATABASE_ADMINUSERNAME

Specifies the target database administrator user name.

Parameter Relationships

For example, for a co-managed database, the migration user name can be system and for an Autonomous Database, the migration user name can be admin. The TARGETDATABASE_* parameters specify connection details for the target OCI database.

Property Description

Syntax

TARGETDATABASE_ADMINUSERNAME = username

Default value

There is no default value

Required

Yes

Modifiable on Resume

No

G.4 SOURCEDATABASE_ADMINUSERNAME

Specifies the source database administrator user name.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_ADMINUSERNAME = source administrator username

Default value

There is no default value

Required

Yes

Modifiable on Resume

No

G.5 DATAPUMPSETTINGS_DATAPUMPPARAMETERS_IMPORTPARALLELISMDEGREE

Specifies the maximum number of worker processes that can be used for a Data Pump Import job.

For migration to an Autonomous Database target, Zero Downtime Migration automatically queries its CPU core count and sets this parameter.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property Description

Syntax

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_IMPORTPARALLELISMDEGREE = integer

Default value

There is no default value

Valid values

An integer value is expected

Required

No

Modifiable on Resume

Until ZDM_DATAPUMP_IMPORT_TGT phase is COMPLETED.

G.6 DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXPORTPARALLELISMDEGREE

Specifies the maximum number of worker processes that can be used for a Data Pump Import job.

For migration to an Autonomous Database target, Zero Downtime Migration automatically queries its CPU core count and sets this parameter.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property Description

Syntax

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXPORTPARALLELISMDEGREE = integer

Default value

There is no default value

Valid values

An integer value is expected

Required

No

Modifiable on Resume

Until ZDM_DATAPUMP_EXPORT_SRC phase is COMPLETED.

G.7 DATAPUMPSETTINGS_DATAPUMPPARAMETERS_NOCLUSTER

Specifies whether all Data Pump workers are started on the current instance or on instances usable by the job.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property Description

Syntax

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_NOCLUSTER = [TRUE | FALSE]

Default value

FALSE

Valid values

TRUE all Data Pump workers are started on the current instance

FALSE Data Pump workers are started on instances usable by the job

Required

No

Modifiable on Resume

No

G.8 DATAPUMPSETTINGS_EXPORTVERSION

Specifies the Data Pump job export version.

See Oracle Data Pump documentation for Data Pump Export Version.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property Description

Syntax

DATAPUMPSETTINGS_EXPORTVERSION = ["COMPATIBLE","12","LATEST"]

Default value

COMPATIBLE, if the target database is of same or higher version than that of source database, and specific version, if the target database is a lower version than that of source database.

Required

No

G.9 DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME

Specifies the object name of a directory on server file system of an on-premises database.

In lieu of a network database link, a directory on the server file system of an on-premises database, specified with the DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_* properties is used to store Data Pump Export dump files.

Zero Downtime Migration creates this object if it does not already exist

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property Description

Syntax

DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME = Name

Default value

There is no default value

Range of values

Name of directory object in the database.

Required

No

Modifiable on Resume

Until ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC phase is COMPLETED.

G.10 DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_PATH

Specifies the absolute object path of a directory on server file system of an on-premises database.

In lieu of a network database link, a directory on the server file system of an on-premises database, specified with the DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_* properties is used to store Data Pump Export dump files.

Zero Downtime Migration creates this object if it does not already exist

Note:

For Oracle Database 19c and later releases, the UTL_FILE_DIR initialization parameter is desupported, which means symbolic links for Data Pump directories are not supported.

If you attempt to use an affected feature configured with symbolic links, then you encounter ORA-29283: invalid file operation: path traverses a symlink. Oracle recommends that you instead use directory objects in place of symbolic links.

See How Does Oracle Data Pump Move Data? for more information.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property Description

Syntax

DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_PATH = Path

Default value

There is no default value

Range of values

Absolute path of directory on database server

Required

No

Modifiable on Resume

Until ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC phase is COMPLETED.

G.11 DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_NAME

Specifies the name of an import directory object.

In lieu of a network database link, a directory on the server file system of OCI database is used to store Data Pump dump files.

Zero Downtime Migration creates this object if it does not already exist.

For Autonomous Database migration targets, the DATA_PUMP_DIR object will already exist.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property Description

Syntax

DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_NAME = Name of the directory object

Default value

There is no default value

Range of values

Name of directory object in database

Required

No

Modifiable on Resume

Until ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT phase is COMPLETED.

G.12 DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_PATH

Specifies the absolute path of an import directory object.

In lieu of a network database link, a directory on the server file system of OCI database is used to store Data Pump dump files.

Zero Downtime Migration creates this object if it does not already exist.

For Autonomous Database migration targets, the DATA_PUMP_DIR object will already exist.

Note:

For Oracle Database 19c and later releases, the UTL_FILE_DIR initialization parameter is desupported, which means symbolic links for Data Pump directories are not supported.

If you attempt to use an affected feature configured with symbolic links, then you encounter ORA-29283: invalid file operation: path traverses a symlink. Oracle recommends that you instead use directory objects in place of symbolic links.

See How Does Oracle Data Pump Move Data? for more information.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property Description

Syntax

DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_PATH = Path of the directory object

Default value

There is no default value

Range of values

Absolute path of directory on database server

Required

No

Modifiable on Resume

Until ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT phase is COMPLETED.

G.13 DUMPTRANSFERDETAILS_PUBLICREAD

Specifies if the dump files on NFS are readable for others.

Parameter Relationships

This option allows target database user to read the dumps on the shared path when the dump files are allowed to be read by public.

This helps when the user accessing source database server is not allowed to change the group ownership on dumps on the shared path.

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

Property Description

Syntax

DUMPTRANSFERDETAILS_PUBLICREAD = {TRUE | FALSE}

Default value

FALSE

Range of values

TRUE: Dump files on NFS are readable by public.

FALSE: Dump files on NFS are not readable by public.

Required

No

Modifiable on Resume

Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

G.14 IGNOREEXPORTERRORS

Specifies comma separated list of ORA errors to be ignored for Oracle Data Pump export. For any new error to be ignored, suffix the new error to the list of default errors to be ignored.

Property Description

Syntax

IGNOREEXPORTERRORS = ORA_error_list

Default value

ORA-31684,ORA-39111,ORA-39082

Range of values

ORA-31684,ORA-39111,ORA-39082

Required

No

Modifiable on Resume

Until ZDM_DATAPUMP_EXPORT_SRC phase is COMPLETED.

G.15 IGNOREIMPORTERRORS

Specifies comma separated list of ORA errors to be ignored for Oracle Data Pump import. For any new error to be ignored, suffix the new error to the list of default errors to be ignored.

Property Description

Syntax

IGNOREIMPORTERRORS = ORA_error_list

Default value

ORA-31684,ORA-39111,ORA-39082

Range of values

ORA-31684,ORA-39111,ORA-39082

Required

No

Modifiable on Resume

Until ZDM_DATAPUMP_IMPORT_TGT phase is COMPLETED.

G.16 RMANSETTINGS_SRCCHANNELS

Specifies the number of RMAN channels to be allocated at the source for performing RMAN backups.

Property Description

Syntax

RMANSETTINGS_SRCCHANNELS = integer

Default value

10

Range of values

0 to

10

Required

No

Modifiable on Resume

Until ZDM_XTTS_BACKUP_INCR_RO_SRC phase is COMPLETED.

G.17 RMANSETTINGS_TGTCHANNELS

Specifies the number of RMAN channels to be allocated at the source for performing RMAN backups.

Property Description

Syntax

RMANSETTINGS_TGTCHANNELS = integer

Default value

10

Range of values

0 to

10

Required

No

Modifiable on Resume

Until ZDM_XTTS_RESTORE_INCR_TGT phase is COMPLETED.

G.18 RMANSETTINGS_RETENTIONWINDOW

Specifies the number of days after which backups created by ZDM become obsolete.

Property Description

Syntax

RMANSETTINGS_RETENTIONWINDOW = integer

Default value

Range of values

Required

No

Modifiable on Resume

Until ZDM_XTTS_BACKUP_INCR_RO_SRC phase is COMPLETED.

G.19 RMANSETTINGS_BACKUPTAG

Specifies the backup tag to create or use backup. By default ZDM will generate a job# specific backup tag.

Property Description

Syntax

RMANSETTINGS_BACKUPTAG = integer

Default value

Range of values

Required

No

Modifiable on Resume

Until ZDM_XTTS_BACKUP_FULL_SRC phase is COMPLETED.

G.20 RMANSETTINGS_SECTIONSIZE

Specifies the backup tag RMAN section size to use for backups. Specify the value as 0 to skip using section size.

Property Description

Syntax

RMANSETTINGS_SECTIONSIZE = <integer>{K|M|G|T}>

Default value

64G

Range of values

Required

No

Modifiable on Resume

Until ZDM_XTTS_BACKUP_INCR_RO_SRC phase is COMPLETED.

G.21 RMANSETTINGS_COMPRESSIONALGORITHM

Specifies the RMAN Compression algorithm to use for backups.

Property Description

Syntax

RMANSETTINGS_COMPRESSIONALGORITHM = BASIC| LOW | HIGH | MEDIUM | NONE

Default value

MEDIUM

Range of values
  • BASIC: Basic Compression Algorithm
  • LOW: Least impact on backup throughput and suited for environments where CPU resources are the limiting factor.
  • HIGH: Best suited for backups over slower networks where the limiting factor is network speed.
  • MEDIUM: Recommended for most environments. Good combination of compression ratios and speed.
  • NONE: Do not use compression.

Required

No

Modifiable on Resume

Until ZDM_XTTS_BACKUP_INCR_RO_SRC phase is COMPLETED.

G.22 RMANSETTINGS_PUBLICREAD

Specifies the backup files on shared storage to be made readable for others. This option allows target database user to read backups on shared path as the backup file directory is allowed to be read by public. This helps if the user accessing source database server is not allowed to change the group ownership on backups on shared path.

Property Description

Syntax

RMANSETTINGS_PUBLICREAD = TRUE| FALSE

Default value

FALSE

Range of values

TRUE or FALSE

Required

No

Modifiable on Resume

Until ZDM_XTTS_BACKUP_INCR_RO_SRC phase is COMPLETED.

G.23 SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE

Specifies the identity file to access the bastion for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE = identity file

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.24 SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP

Specifies the IP address of the bastion host for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP = ip address

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.25 SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT

Specifies the port number of the bastion host for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT = port_number

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.26 SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP

Specifies the remote host IP address to access from the bastion for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP = ip_address

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.27 SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME

Specifies the user name to access the bastion for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME = username

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.28 SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME

Specifies the proxy host name to connect to the source database through an HTTPS proxy.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME = proxy host name

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.29 SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT

Specifies the HTTP proxy port number to connect to the source database through an HTTPS proxy.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT = proxy port number

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.30 SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PROTOCOL

Specifies the proxy protocol to connect to the source database through a proxy.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PROTOCOL = HTTP or HTTPS

Default value

HTTP

Required

No

Modifiable on Resume

Yes

G.31 SOURCEDATABASE_ENVIRONMENT_DBTYPE

Indicates the type of database to migrate from the specified environment.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_ENVIRONMENT_DBTYPE = dbtypeValue

Default value

ORACLE

Required

No

Modifiable on Resume

No

G.32 SOURCEDATABASE_ENVIRONMENT_NAME

Specifies the environment of the source database.

You can specify whether the source database environment is Oracle (ORACLE).

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_ENVIRONMENT_NAME = nameValue

Default value

ORACLE

Required

No

Modifiable on Resume

No

G.33 TARGETDATABASE_CONNECTIONDETAILS_HOST

Specifies the listener host name or IP address.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS parameters specify connection details for the target OCI database.

These properties are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_HOST = hostname_or_ip

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.34 TARGETDATABASE_CONNECTIONDETAILS_PORT

Specifies the listener port number.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_PORT = listener port number

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.35 TARGETDATABASE_CONNECTIONDETAILS_SERVICENAME

Specifies the fully qualified service name.

This parameter is optional for Oracle Autonomous Database targets; however if an HTTP proxy is required to connect, specify it.

In addition, for Oracle Autonomous Database on Dedicated Exadata Infrastructure and Oracle Autonomous Database on Exadata Cloud@Customer with fractional OCPU service you must specify the appropriate service alias in the parameter.

You can specify any predefined fractional service alias available; however, for Autonomous Transaction Processing workloads TP* services are preferred over LOW* services because LOW* is meant for low priority batch jobs.

  • TP_TLS, TP, LOW_TLS or LOW (for Autonomous Transaction Processing workloads)
  • LOW_TLS or LOW (for Autonomous Data Warehouse workloads)

See also Connecting to a DB System and About Connecting to a Dedicated Autonomous Database

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_SERVICENAME = service_name_or_alias

Default value

There is no default value

Valid values

For non-Autonomous, specify the fully qualified service name.

For Autonomous, you can specify the service alias for fractional OCPU service as:

  • TP_TLS, TP, LOW_TLS or LOW (for Autonomous Transaction Processing workloads)
  • LOW_TLS or LOW (for Autonomous Data Warehouse workloads)

Required

No

Modifiable on Resume

No

G.36 SOURCEDATABASE_CONNECTIONDETAILS_HOST

Specifies the source database listener host name or IP address. Required for all except environment.name = ORACLE and environment.dbType = ADBS|ADBD. In case of Oracle RAC database, the scan name can be specified.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_HOST = hostname_or_ip

Default value

There is no default value

Required

Yes*

*Not required for Autonomous Database.

Modifiable on Resume

Yes

G.37 SOURCEDATABASE_CONNECTIONDETAILS_PORT

Specifies the source database listener port number. Required for all except environment.name = ORACLE and environment.dbType = ADBS|ADBD.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_PORT = listener port number

Default value

There is no default value

Required

Yes*

*Not required for Autonomous Database.

Modifiable on Resume

Yes

G.38 SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME

Specifies the source database fully qualified service name. Required for all except environment.name = ORACLE and environment.dbType = ADBS|ADBD.

Parameter Relationships

Example, <service_name>.<DB_domain> for all Environment.DbType except ORACLE.ADBS and ORACLE.ADBD <service_name> for Environment.DbType = ORACLE.ADBS OR ORACLE.ADBD. See Overview of Connecting to a DB System for more information.

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property Description

Syntax

SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME = service name

Default value

There is no default value

Required

Yes*

*Not required for Autonomous Database

Modifiable on Resume

No

G.39 TABLESPACEDETAILS_EXCLUDE

Specifies tablespaces to be excluded for automatic remap or automatic creation of tablespaces at target database during import of user schemas.

See Automatic Tablespace Creation for more information.

Example

TABLESPACEDETAILS_EXCLUDE=B2B_LOB_TS,B2B_HR_TS

Parameter Relationships

In a logical migration, the TABLESPACEDETAILS_* parameters specify details that allow Zero Downtime Migration to automatically create the required tablespaces at target database.

Property Description

Syntax

TABLESPACEDETAILS_EXCLUDE=tablespace_names

Default value

By default SYSTEM, SYSAUX, and USERS tablespaces are excluded.

Required

No

Modifiable on Resume

Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED

G.40 TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE

Specifies the identity file to access the bastion for bastion-based access to the target database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE = bastion_id_file

Default value

There is no default value

Required

Not mandatory for migration jobs

Modifiable on Resume

Yes

G.41 TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP

Specifies the IP address of the bastion host for bastion-based access to database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP = ip address

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.42 TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT

Specifies the port number of the bastion host for bastion-based access to database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT = port_number

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.43 TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP

Specifies the remote host IP address to access from the bastion for bastion-based access to database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP = ip_address

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.44 TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME

Specifies the user name to access the bastion for bastion-based access to database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME = username

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.45 TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME

Specifies the proxy host name for connecting to the target database through an HTTPS proxy.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME = proxy host name

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.46 TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT

Specifies the HTTP proxy port number for connecting to the source database through an HTTPS proxy.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT = proxy port number

Default value

There is no default value

Required

No

Modifiable on Resume

Yes

G.47 TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PROTOCOL

Specifies the proxy protocol to connect to the target database through a proxy.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS parameters specify connection details for the target OCI database.

Property Description

Syntax

TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PROTOCOL = HTTP or HTTPS

Default value

HTTP

Required

No

Modifiable on Resume

Yes

G.48 TARGETDATABASE_DBTYPE

Specifies the target database type if OCID of the target database is not provided.

Parameter Relationships

The TARGETDATABASE_* parameters specify connection details for the target OCI database.

Property Description

Syntax

TARGETDATABASE_DBTYPE = dbtypeValue

Default value

There is no default value

The following values are supported:
  • ORACLE
  • EXADATA
  • ODA

Required

No

Modifiable on Resume

No

G.49 WALLET_DATAPUMPENCRYPTION

Specifies the absolute path to the directory that contains the auto login wallet file cwallet.sso, which is used to get the Data Pump encryption password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property Description

Syntax

WALLET_DATAPUMPENCRYPTION = wallet_path

Default value

There is no default value

Required

No

Modifiable on Resume

Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.

G.50 WALLET_SOURCEADMIN

Specifies the absolute path to the directory that contains the auto login wallet file cwallet.sso, which is used to get the source database administrative admin password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property Description

Syntax

WALLET_SOURCEADMIN = wallet_path

Default value

There is no default value
Range of value

Full path to the wallet.

Required

No

Modifiable on Resume

No

G.51 WALLET_TARGETADMIN

Specifies the absolute path to the directory that contains the auto login wallet file cwallet.sso, which is used to get the target database administrative admin password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property Description

Syntax

WALLET_TARGETADMIN = wallet_path

Default value

There is no default value

Required

No

Modifiable on Resume

Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.

G.52 WALLET_TDEKEYSTORE

Specifies the absolute path location for wallet to be used for TDE keystore that contains the auto login wallet file cwallet.sso for specifying the source database TDE keystore password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property Description

Syntax

WALLET_TDEKEYSTORE = wallet_path

Default value

There is no default value
Range of value

Full path to the wallet.

Required

No

Modifiable on Resume

No

G.53 WALLET_TGTTDEKEYSTORE

Specifies the absolute path location for wallet to be used for the target TDE keystore that contains the auto login wallet file cwallet.sso for specifying the target database TDE keystore password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property Description

Syntax

WALLET_TGTTDEKEYSTORE = wallet_path

Default value

There is no default value
Range of value

Full path to the wallet.

Required

No

Modifiable on Resume

No

G.54 WALLET_USERACTION

Allows you to provide the auto login wallet path, which contains the username and its password which should run the useraction.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property Description

Syntax

WALLET_USERACTION = wallet_path

Default value

There is no default value

Required

No

Modifiable on Resume

Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.