ORA-12899: value too large for column APPLSYS.FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE
Error:
While running autoconfig after upgrade there might be below error.
ORA-12899: value too large for column "APPLSYS"."FND_PROFILE_OPTION_VALUES"."PROFILE_OPTION_VALUE"
Cause:
This is due to incorrect parameter s_db_util_filedir value in the DB context file. The parameter length should be defined to less than 240 chars.
<dbutilfiledir oa_var="s_db_util_filedir" osd="unix">/usr/tmp</dbutilfiledir>
Solution
To implement the solution, please execute the following steps:
1 - Change the value dbutilfiledir in the database context file ($ORACLE_HOME/appsutil/$CONTEXT_NAME.xml)
2 - run autoconfig again.
ORA-12899: value too large for column "APPLSYS"."FND_PROFILE_OPTION_VALUES"."PROFILE_OPTION_VALUE"
Cause:
This is due to incorrect parameter s_db_util_filedir value in the DB context file. The parameter length should be defined to less than 240 chars.
<dbutilfiledir oa_var="s_db_util_filedir" osd="unix">/usr/tmp</dbutilfiledir>
Solution
To implement the solution, please execute the following steps:
1 - Change the value dbutilfiledir in the database context file ($ORACLE_HOME/appsutil/$CONTEXT_NAME.xml)
2 - run autoconfig again.
Post a Comment
Post a Comment