Verifying the Environment
Complete the steps before you begin duplication.
-
Ensure that the source database host is reachable from the destination host. You must be able to SSH between the two hosts.
-
On the destination host, use the TNSPING utility to verify the listener port on the source host works fine.
For example:tnsping source host:1521
-
On the destination host, use Easy Connect to verify the connection to the source database:
host:port/servicename
For example:sqlplus system@ip-address:1521/proddb
Ensure that the connection string does not exceed 64 characters.
-
Copy the required
sqlpatch
files (for rollback) from the source database home to the target database. -
Ensure that at least one archivelog has been created on the source database; otherwise, RMAN duplication fails with an error.
-
If the source database uses wallets, then back up the password-based wallet and copy it to the standard location on the destination host.
For example:/opt/oracle/dcs/commonstore/wallets/tde/db_unique_name/
-
Make sure the compatibility parameters in the source database are set to at least 11.2.0.4.0 for an 11.2.0.4 database and at least 12.1.0.2.0 for a 12.1.0.2 database.
Parent topic: Duplicating the Primary Oracle Database