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

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

While cloning database Tier

Error :
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…

 ERROR: Failed to execute /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl

  Please check logfile.

Solution 1

Which unzip should point to $ORACLE_HOME/bin/unzip

Take the backup of existing unzip from $ORACLE_HOME/bin

cd $ORACLE_HOME/bin

mv unzip unzip_bkp

cp /usr/bin/unzip to $ORACLE_HOME/bin

Make sure the unzip utility under /usr/bin should be of version 5.X and not 6

Solution 2

As root user, rename the default unzip (/usr/bin/unzip) to a temporary filename (e.g. /usr/bin/unzip-ver6), perform the task, and then rename unzip-ver6 to the original name when completed.

# mv /usr/bin/unzip /usr/bin/unzip-ver6

Solution 3

unzip utility
https://oss.oracle.com/el4/unzip/unzip.html


 

While cloning, adcfgclone.pl error:RC-50014: Fatal: Execution of AutoConfig was failed in R12.

While cloning, adcfgclone.pl error:RC-50014: Fatal: Execution of AutoConfig was failed in R12.
When we check the log file we can see the error like below
AutoConfig could not successfully instantiate the following files:


adcrdb.sh INSTE8

AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed


Solution: Copy adcrdb.sh file ($ORACLE_HOME/appsutil/template) from
Source to target ($ORACLE_HOME/appsutil/template) then
we run the adcfgclone.pl dbTier again.

Oracle’s OS Watcher tool (oswbb)

Oracle’s OS Watcher tool (oswbb)

Oracle’s OS Watcher tool (oswbb) runs shell scripts that run the operating system tools (ps, top, ifconfig, mpstat, iostat, netstat, traceroute, vmstat, meminfo (Linux Only), slabinfo (Linux Only)) to collect CPU, Memory, I/O and Network usage and collate the results. OSWatcher Analyzer (oswbba) presents these results graphically.

oswbb and oswbba require installation, however this is relatively simple and there is little overhead.

By default the diagnostics are only retained for 48 hours, but this can be configured.

Note that it is a unix / linux based utility.

OSWatcher (Includes: [Video]) (Document 301137.1)

OS Watcher User's Guide (Document 1531223.1)

OSWatcher Analyzer User Guide (Document 461053.1)

Node ID does not exist for the current application server id.

Node ID  does not exist for the current application server id.

On entering Oracle Applications on the web, the following error appears:

Node ID  does not exist for the current application server id.

Cause:

There is a mismatch between server_id in the  fnd_nodes table and appl_server_id in the dbc file and
hence we are getting this  "node id does not exist" error.

Solution:

Stop application.
Run adgendbc.sh script to configure apps tier dbc file with the correct id from the database instance.
Start the application and retest.

Location of script:
11i: $COMMON_TOP/admin/install/$CONTEXT_NAME
R12: $INST_TOP/admin/install

[appl@test install]$ sh adgendbc.sh

[EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-00600: internal error code, arguments: [kqludp2], [0x9EAFC1B0], [0], [], [], [], [], [] ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85

[EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-00600: internal error code, arguments: [kqludp2], [0x9EAFC1B0], [0], [], [], [], [], []
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85

OPP LOG

[EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-00600: internal error code, arguments: [kqludp2], [0x9EAFC1B0], [0], [], [], [], [], []
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85
ORA-06512: at line 1

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)

SOLUTION

1. Shut down all services
Verify NO CP processes are running on OS. This includes FNDLIBR, FNDSM, etc.

IMPORTANT: BE SURE TO RUN THESE SCRIPTS AS THE CORRECT USERS SYSTEM and APPLSYS ONLY.

2. Run $FND_TOP/patch/115/sql/afopp001.sql as SYSTEM.

3. Run $FND_TOP/patch/115/sql/afopp002.sql as APPLSYS.  Commit.

4. Restart managers and test again.