Do you have more than 240 characters in your utl_file_dir? if so, you should read this before applying patch 5985992 'TXK AUTOCONFIG RUP Q (Jul/Aug 2007)'. After applying this patch, AutoConfig on database tier failed with the following error: [PROFILE PHASE] AutoConfig is exiting with status 1 It wasn't clear why afdbprf.sh failed so I ran it manually from ssh terminal and I got this: afdbprf.sh started at Tue Jan 29 17:43:21 IST 2008 The environment settings are as follows ... ORACLE_HOME : .... Application Id : 0 Looking into afdbprf.sql (executed by afdbprf.sh) reveals the problem: ....... --Setting BIS_DEBUG_LOG_DIRECTORY -- This profile option was earlier set in addbprf.sql via bug 2843457, Now moved here for bug 5722442 In order to fix bug 5722442, the UTL_FILE_LOG updated with the value of s_db_util_filedir from the database context file and a new bug was created (not a bug according to Bug 6404909). If the s_db_util_filedir contains more than 240 characters it can't be stored in a profile since the PROFILE_OPTION_VALUE column defined as varchar2(240). The s_db_util_filedir initialized when creating the database context file by adbldxml.pl, and set up with the value of utl_file_dir database parameter. I'm not sure why it should be updated with all directories within utl_file_dir and not with the relevant directories only...?! The solution according to Note:458511.1 - "After patch 5985992 AutoConfig On Database Tier Fails with script afdbprf.sh" is to change the value of s_db_util_filedir in the database context file to a value less the 240 characters and run AutoConfig again. And it works, of course... What should I do if I my utl_file_dir contains more than 240 characters?! Actually I don't have a good answer to this question but I will try to locate all the places on which this issue might affect when s_db_util_filedir will be updated with a value less than 240 chars.
You are welcome to leave a comment or update with additional information regarding this issue. Aviad |
Monday, February 4, 2008
UTL_FILE_DIR issue after applying patch 5985992 'TXK AUTOCONFIG RUP Q'
Posted by Aviad at 5:10 PM
Labels: AutoConfig, Patches, Troubleshooting
Subscribe to:
Post Comments (Atom)
2 comments:
hey aviad,
my utl_file_dir contains 252 characters,but run db autoconfig successfully.
I'm amasing..
Hi Bit-tree,
Interesting...
Is your s_db_util_filedir within the DB context file contains 252 characters?
What is your TXK AUTOCONFIG RUP level?
Have you applied patch 5985992 - "TXK AUTOCONFIG RUP Q" ?
Aviad
Post a Comment