Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported(RC-20200: )

while cloning oracle application database using cold backup iam getting below error:

  0% completed       RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.
Please make sure you have UnZip 5.X in your path and try again...

ERROR while running Apply..

This error due to different unzip version of source and target,

First check the unzip version on source and target,

Cause:
Source:
unzip -version
caution:  both -n and -o specified; ignoring -o
UnZip 5.52 of 28 February 2005, by Info-ZIP.  Maintained by C. Spieler.  Send
bug reports using http://www.info-zip.org/zip-bug.html; see README for details.

Target:
unzip -version
caution:  both -n and -o specified; ignoring -o
UnZip 6.0 of 28 February 2005, by Info-ZIP.  Maintained by C. Spieler.  Send
bug reports using http://www.info-zip.org/zip-bug.html; see README for details.

Solution:
Copy the unzip file from source to target or local system
/usr/bin/unzip
/data/db/tech_st/11.2.0/bin/unzip

MyOracle Support offers a solution with a patch:
RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported [ID 1410514.1]

Check the unzip version now on target:

unzip -version
caution:  both -n and -o specified; ignoring -o
UnZip 5.52 of 28 February 2005, by Info-ZIP.  Maintained by C. Spieler.  Send
bug reports using http://www.info-zip.org/zip-bug.html; see README for details.

After solving the unzip version you proceed the cloning steps (if you proceed you might get error)

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
          

  [INSTANTIATE PHASE]
  AutoConfig could not successfully instantiate the following files:
    Directory: /data/db/tech_st/11.2.0/appsutil/install/PRODAR_ebsdbprd
      adcrdb.sh               INSTE8
   
  AutoConfig is exiting with status 1
  
  RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDBTechStack

Cause:

/data/db/tech_st/11.2.0/appsutil/template/adcrdb.sh  file in deleted from the first failed cloning process becuase of this you getting above error,

Solution:

Copy the specfic file "/data/db/tech_st/11.2.0/appsutil/template/adcrdb.sh" from the target database or copy the template folder from the target system.

Run again the cloning steps:

perl adcfgclone.pl dbTier

cloning completed successful.

Best Regards.

Changing archivelog location:

Choose the FRA for archivelog location,

While creating database if we enabled archivelog without create FRA oracle placed archive logs in a default directory of $ORACLE_HOME/dbs

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            $ORACLE_HOME/dbs/archive
Oldest online log sequence     45
Next log sequence to archive   46
Current log sequence           46
SQL>

Suppose if we created FRA and then choose FRA for archive log location,

For example so many facing issues on arechivelog location because while executing command like below,

alter system set  log_archive_dest_1='LOCATION=DB_RECOVERY_FILE_DEST'

SQL> sho parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      LOCATION=DB_RECOVERY_FILE_DEST
log_archive_dest_10                  string
SQL>

It will not take FRA for archivelog location, it will use old location.

if we set location "LOCATION=USE_DB_RECOVERY_FILE_DEST" then only it will choose FRA for archivelog location.

alter system set  log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     42
Next log sequence to archive   44
Current log sequence           44


SQL> select destination from V$ARCHIVE_DEST;

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /data/DEV/fast_recovery_area
db_recovery_file_dest_size           big integer 6930M
recovery_parallelism                 integer     0
SQL>


If you want to change the different archivelog location:


SQL> alter system set log_archive_dest_1='LOCATION=/u20/oracle/data1';

System altered.

Best Regards