Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Tuesday, February 10, 2009

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.

No comments:

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Recent Comments