Have you gone through the remaining steps updating the user passwords, verifying the IFS application related user status in the database, and running the reconfiguration to recreate the middleware component?
@maheshmuz yes, we have updated the passwords and verified the IFS application user in the database. I am able to log into the database as the IFSAPP user and can query data from the tables, but not from the views. I have not been able run the reconfigure step as I have the ORA-01031: Insufficient privileges error.
We have run the Prepare Database step from the Application Setup (IFS Build) and have also fixed all but a small number of invalid objects (all MTK views).
What error do you get when you try to launch the installer from inside the ifs_home?
I don’t receive any errors on the Prepare Database step, but I get the insufficient privileges error when running the deploy database objects step. Because of those errors, I never even attempted the build step.
Who is the owner of the IFS views?
It seems you are performing an additional step. Since you migrated the database from 12c to 19c using the export/import method, you don’t need to run the Deploy Database Objects step in the installer. Once you complete the Prepare Database step and fix any invalid objects, you can proceed directly to the Create IFS Home step from the installer.
@maheshmuz sorry, I was traveling for work and am just getting back to this. I re-ran the import and then ran the prepare database operation. Both of those tasks completed successfully. However, when I run the “create IFS home” operation I am getting this error:
ORA-12012: error on auto execute of job "IFSAPP"."F1JOB_1402"
ORA-20105: Domain.NO_CONTEXT: Context [FndBoolean_CTX] seems to be missing.
ORA-06512: at "IFSAPP.ERROR_SYS", line 138
ORA-06512: at "IFSAPP.ERROR_SYS", line 331
ORA-06512: at "IFSAPP.DOMAIN_SYS", line 790
ORA-06512: at "IFSAPP.DOMAIN_SYS", line 794
ORA-06512: at "IFSAPP.FND_BOOLEAN_API", line 424
ORA-06512: at "IFSAPP.FND_BOOLEAN_API", line 428
ORA-06512: at line 1
ORA-06512: at "IFSAPP.DOMAIN_SYS", line 687
ORA-06512: at "IFSAPP.DOMAIN_SYS", line 150
ORA-06512: at "IFSAPP.FND_BOOLEAN_API", line 439
ORA-06512: at "IFSAPP.FND_BOOLEAN_API", line 443
ORA-06512: at "IFSAPP.FND_BOOLEAN_API", line 447
ORA-06512: at "IFSAPP.DOMAIN_SYS", line 678
ORA-06512: at "IFSAPP.DOMAIN_SYS", line 150
ORA-06512: at "IFSAPP.LOG_CATEGORY_API", line 368
ORA-06512: at "IFSAPP.LOG_CATEGORY_API", line 372
ORA-06512: at "IFSAPP.LOG_CATEGORY_API", line 376
ORA-06512: at "IFSAPP.LOG_SYS", line 65
ORA-06512: at "IFSAPP.TRACE_SYS", line 267
ORA-06512: at "IFSAPP.TRACE_SYS", l
I was able to resolve this issue. All is working now.
