Prerequisites before upgrading each module at Database level

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System Server


    APPLIES TO:

    AR System Server running on Oracle



    PROBLEM:

    Unable to proceed with 9.1.00 installation successfully.


    SOLUTION:

     

    Some prerequisites to follow before upgrading each module at Database level :

      

    1.    Compile invalid views :

      

    Method 1 :

      

    1.    If you are using Oracle Database import or export tools, recompile invalid objects after import or Database Restore:

      

    a.    At database level as ARAdmin, execute following SQL 

      

        select object_name from user_objects where status != 'VALID';

      

    b.    If the output is not zero, 

      

    select 'ALTER ' || OBJECT_TYPE || ' ' ||  'ARAdmin' || '.' || OBJECT_NAME || ' COMPILE;' from user_objects where  status = 'INVALID'

      

    c.    Execute the output of the above command to compile the invalid objects. 

      

    d.    Repeat steps a and b until you see the zero output or no change in the total count.

      

    e.    If the above SQL output is nonzero, investigate for the root cause and see if you can safely ignore invalid objects such as uncompelled packages, old views, etc., before proceeding to the next step (Take help from DBA to investigate issues with invalid objects).

      

        Method 2:

      

    If you have DBA permissions or take help from DBA to compile 

      

    EXEC DBMS_UTILITY.COMPILE_SCHEMA( schema => 'ARADMIN', compile_all => FALSE)

      

    2.    If you still see invalid views use following command to find the list of forms, export them using Dev studio and import same forms using Dev studio. AR System will drop the views and rebuild during import and would fix any discripancies.

      

    select distinct * from (
    select name,schemaid from arschema where 'T' || schemaid in (select OBJECT_NAME  from  user_objects  where  status = 'INVALID'  and object_type = 'VIEW')

      

    Union

      

    select name,schemaid from arschema where 'H' || schemaid in (select OBJECT_NAME  from  user_objects  where  status = 'INVALID'  and object_type = 'VIEW')

      

    Union

      

    select name,schemaid from arschema where 'B' || schemaid in (select OBJECT_NAME  from  user_objects  where  status = 'INVALID'  and object_type = 'VIEW'))

     


    Article Number:

    000115211


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles