Skip to main content

I am migrating my IFS 10 database from Oracle 12G to 19C using the export import method (along with other steps to convert the database).  After migrating the database to a new server, I ran the “Prepare Database” step from the IFS Build on the new application server.  After that process completes (without any errors), I am trying to do a simple query from the database:

Select * from customer_info as the IFSAPP user.  When doing this, I receive an ORA-01031:  Insufficient privileges error.

 

Any idea what the issue might be?  

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.

Terms & ConditionsCookie settings