Oracle Database Migration to AWS Cloud

Take a full backup of the database
db_full.tz

check the checksum of the backupfile
md5sum db_full.tz

split backup into multiple file size 100mb
split -b 100M db_full.tz db_split_

scp/copy each file to the server
aws s3 cp db_split_ s3://bucket_name

Merge the files.
cat db_split_* > db_full.tz

check the checksum of the backup file
md5sum db_full.tz

12.2.6 :: ERROR: txkWfClone.sh execution failed, exit code 1

Logs from the autoconfig file:

START: Executing /u01/EBSDEV/fs1/inst/apps/EBSDEV_grcldm/admin/install/txkWfClone.sh -nopromptmsg
txkWfClone.sh exited with status 1
ERROR: txkWfClone.sh execution failed, exit code 1

Solution:

1. Connect to database server with apps user and run below command

exec fnd_conc_clone.setup_clean;

2. run autoconfig

orasmk@sgofa03:/u02/EBSDEV/db/tech_st/12.1.0/appsutil/scripts/EBSDEV_sgofa03$ ./adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /u02/EBSDEV/db/tech_st/12.1.0/appsutil/log/EBSDEV_sgofa03/05091543/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

        Using ORACLE_HOME location : /u02/EBSDEV/db/tech_st/12.1.0

        Classpath                   : :/u02/EBSDEV/db/tech_st/12.1.0/jdbc/lib/ojdbc6.jar:/u02/EBSDEV/db/tech_st/12.1.0/appsutil/java/xmlparserv2.jar:/u02/EBSDEV/db/tech_st/12.1.0/appsutil/java:/u02/EBSDEV/db/tech_st/12.1.0/jlib/netcfg.jar:/u02/EBSDEV/db/tech_st/12.1.0/jlib/ldapjclnt12.jar

        Using Context file          : /u02/EBSDEV/db/tech_st/12.1.0/appsutil/EBSDEV_sgofa03.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db121

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

3. Clear the failed session

rm -Rf /u01/EBSDEV/fs1/FMW_Home

rm -Rf /u01/EBSDEV/oraInventory

4. re-run cloning steps

cd /u01/EBSDEV/fs1/EBSapps/comn/clone/bin

perl adcfgclone.pl appsTier /u01/EBSDEV/fs1/inst/apps/EBSDEV_grcldm/appl/admin/EBSDEV_grcldm.xml