• Find us:
    +1 415 655 1723   |   +91-844-844-8901
  • Free Newsletter

     
     

  • Archive

  • Categories


  • OID Configuration process failed to load OID Schema

    Posted by "" in "oid" on 2015-02-07

    Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

    While Configuring OID  , an error came up at the time of Configuration process checks screen wherein the option “Load Oracle Internet Directory Schema” got failed.

    blog1

    Log file rcu.log at $ORACLE_HOME/rcu/log  shows the issue was with  ODS.TSPURGE.

     1062 2015-01-16 02:41:16.013 ERROR rcu:      oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-  Ignorable Error: ORA-04063: package body “ODS.TSPURGE” has errors

     1063 ORA-06508: PL/SQL: could not find program unit being called: “ODS.TSPURGE”

     1064 ORA-06512: at line 3

     1065 

     1066 2015-01-16 02:41:16.014 NOTIFICATION rcu:  oracle.sysman.assistants.common.util.SilentMessageHandler::writeToLog: ORA-04063: package body  “ODS.TSPURGE” has errors

    1067 ORA-06508: PL/SQL: could not find program unit being called: “ODS.TSPURGE”

     1068 ORA-06512: at line 3

     1069 

     1077 2015-01-16 02:41:16.036 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU  Operation Failed   1078 oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6136:Error  while trying to execute SQLPlus action.   1079         at  oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:302)

     1080         at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)   1081         at        java.lang.Thread.run(Thread.java:662)

     1082 Caused by: oracle.sysman.assistants.common.task.ActionFailedException: RCU-6136:Error while trying  to execute SQLPlus action.

     1083         at oracle.sysman.assistants.rcu.backend.action.SQLPlusAction.perform(SQLPlusAction.java:260)

     1084         at  oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:245)

     1085         … 2 more

     1086 Caused by: oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: ORA-04063: package body  “ODS.TSPURGE” has errors

     1087 ORA-06508: PL/SQL: could not find program unit being called: “ODS.TSPURGE”

     1088 ORA-06512: at line 3

     1089 

    This was because the grant was missing before running RCU and fix it to grant execute on dbms_job and  dbms_reputil to public .

    To Resolve this error, we need to run the following commands in database:

    Sqlplus “/as sysdba”

    SQL> grant execute on sys.dbms_job to PUBLIC ;

    SQL> grant execute on dbms_reputil to PUBLIC ;

    and then Retry again.

    blog2

     

    On retry the error still occurred . In such scenario drop the Schema using RCU and start again (creating schema using OID configuration screen) and it should work this time .

    blog3

    Happy Learning!!!

     

    Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

    Leave a Reply

    Your email address will not be published. Required fields are marked *



  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.
  • CONTACTS

    K21 Technologies
    128 Uxbridge Road, Hatchend,,
    London, HA5 4DS

    US: +1 415 655 1723
    India: +91-844-844-8901

  • Copyright 2019, K21 Technologies. All rights reserved
  • TOP
    TOP