SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0 in R12.0.4

In this blog, I want to discuss about an critical error while adcfgclone on appsTier which may end your show.

SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0'

during clone, and you may get the message as adclone failed in the target system.

After seeing the log file of the clone, I got one clue that the forms ORACLE HOME is not able to connect with DB as apps user. But sys and system can connect with RDBMS ORACLE HOME.

CAUSE:

SQL*Plus is unable to access required file. The error message is indicating following file is missing from install or inadequate permissions to access this file/directory:

$ORACLE_HOME/oracore/zoneinfo [directory].

$ORACLE_HOME/oracore/zoneinfo/timezone.dat [file].

The file has the following privileges after the DST patch is applied:

-rw-r----- 1 oracle dba 161096 Feb 8 10:34 oracore/zoneinfo/timezone.dat

As non-oracle user does not have dba privileges, they are not able to read/write the file above. It needs at least read privileges on other unix group.

FIX:

1. Manually change the privileges for the forms $ORACLE_HOME/oracore/zoneinfo directory and files.

chmod o+r oracore
chmod o+r oracore/zoneinfo/timezone.dat

or just type from forms $ORACLE_HOME directory
chmod -R 755 oracore

afcfgclone.pl should complete normal now.