AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch
Please follow below steps to overcome this issue
- Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG are not as expected by running:
select ORACLE_USERNAME, READ_ONLY_FLAG, ENABLED_FLAG, ORACLE_ID, INSTALL_GROUP_NUM, last_update_date from FND_ORACLE_USERID where ORACLE_USERNAME in (‘XXXX’)
Set values as expected :
============================
READ_ONLY_FLAG to ‘A’
ENABLED_FLAG to ‘N’
2.1 If application is up and running:
- As an application user with sysadmin rights Navigate to Security–>Oracle–>Register
- Search for schema user and change the Privilege to Enabled.
- Save and check value in the table.
2.2 If application is not available
update fnd_oracle_userid set read_only_flag=’A’ where oracle_username in (‘XXXX’);
commit;
- Update (if necessary) ENABLED_FLAG
update fnd_oracle_userid set ENABLED_FLAG=’N’ where oracle_username in (‘XXXX’);
commit;
- Re-test the issue
Recommended Posts