Skip to main content
Solved

IFSAPP user getting ORA-01031 Insufficient privileges

  • September 4, 2025
  • 8 replies
  • 108 views
T
Do Gooder (Customer)
Forum|alt.badge.img+7

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?  

Best answer by maheshmuz

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.

    8 replies

    maheshmuz
    Hero (Partner)
    Forum|alt.badge.img+9
    • maheshmuz
    • Hero (Partner)
    • September 8, 2025

    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?

    T
    Do Gooder (Customer)
    Forum|alt.badge.img+7
    • tjhendrikse
    • Author
    • Do Gooder (Customer)
    • September 10, 2025

    ​@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).

    maheshmuz
    Hero (Partner)
    Forum|alt.badge.img+9
    • maheshmuz
    • Hero (Partner)
    • September 10, 2025

    What error do you get when you try to launch the installer from inside the ifs_home?

    T
    Do Gooder (Customer)
    Forum|alt.badge.img+7
    • tjhendrikse
    • Author
    • Do Gooder (Customer)
    • September 10, 2025

    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.

    K
    Superhero (Partner)
    Forum|alt.badge.img+17
    • knepiosko
    • Superhero (Partner)
    • September 11, 2025

    Who is the owner of the IFS views?

    Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
    maheshmuz
    Hero (Partner)
    Forum|alt.badge.img+9
    • maheshmuz
    • Hero (Partner)
    • Answer
    • September 11, 2025

    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.

    T
    Do Gooder (Customer)
    Forum|alt.badge.img+7
    • tjhendrikse
    • Author
    • Do Gooder (Customer)
    • October 1, 2025

    ​@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

    T
    Do Gooder (Customer)
    Forum|alt.badge.img+7
    • tjhendrikse
    • Author
    • Do Gooder (Customer)
    • October 2, 2025

    I was able to resolve this issue.  All is working now.

    maheshmuz
    Terms & ConditionsCookie settingsAccessibility statement