When running autoconfig during adcfgclone.pl the adupdlobs.pl taken more than 30 min but it not completed. Also please use the below script to validate.
SELECT pctversion FROM dba_lobs WHERE table_name=’FND_LOBS’
AND column_name=’FILE_DATA’;
If the above sql returns zero then rebuild the index of FND_LOBS.
The script adupdlobs.sql performing full table scan on FND_LOBS
To resolve the issue please do the following:
EXECUTE IMMEDIATE ‘ALTER INDEX applsys.fnd_lobs_ctx REBUILD’;
Then try to rerun the same script manually
$ cd $OAD_TOP/admin/install/$CONTEXT_NAME/
$ sqlplus apps/apps
SQL> @adupdlobs.sql apps apps <SID>
If issues are still there then try to create custom index on fnd_lobs as below
CREATE INDEX applsys.fnd_lobs_cust ON applsys.fnd_lobs (file_name);
Now try again . This time it should complete normal in a minute .
