Thursday, October 13, 2011

American English upgrade patch driver failed while perform upgrade Release 11i to 12.0.4 on

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: American English upgrade patch driver failed while perform upgrade Release 11i to 12.0.4 on
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column


Symptoms:
On : 12.0.4 version, ISSUES WITH FUNCTIONALITY OF AD UTILITIES

When attempting to apply 12.0.4 upgrade driver (6394500) the following error occurs.

ERROR
-----------------------
A database error occurred:
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
Log files:
u6394500.log

ATTENTION: All workers either have failed or are waiting:

FAILED: file payzzcncprg00514.ldt on worker 1.
FAILED: file bomprg.ldt on worker 2.
FAILED: file jg12acp.ldt on worker 3.
FAILED: file pqpzzcncprg00025.ldt on worker 4.

adwork001.log

Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @PAY:patch/115/import/US/payzzcncprg00514.ldt -

Connecting to APPS......Connected successfully.

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /u01/oracle/R12/apps/apps_st/appl/admin/VIS/log/US_payzzcncprg00514_ldt.log
Error calling FNDLOAD function.

US_payzzcncprg00514_ldt.log

A database error occurred:
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

Solution:



NLS_LANG (application system env variable) differed from that of NLS_CHARACTERSET DB parameter.
Set NLS_LANG to match db characterset (UTF8)
Setting NLS_LANG correctly allows FNDLOAD to complete without error.
apply patch 6333519



Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: