2 Replies Latest reply on Jun 16, 2018 2:11 AM by Beauty_and_dBest

    adstats.sql after the upgrading 10.2.0.5 to 12.1.0.2

    Beauty_and_dBest

      EBS 12.0.6

      upgrade 10.2.0.5  to 12.1.0.2

      OL6

       

       

      Hi ALL,

       

      One of the post upgrade task is to run adstats.sql. Is this correct?

      I run the adstats.sql from EBS 12.0.6 version(year 2005)  and its header says :

       

      REM

      REM +=========================================================================+

      REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, California, USA

      REM |                         All Rights Reserved

      REM |                        Applications Division

      REM +=========================================================================+

      REM |

      REM | $Header: adstats.sql 120.3.12000000.3 2007/12/13 13:29:21 mkumandu ship $

      REM |

      REM |

      REM | FILENAME

      REM |   adstats.sql

      REM |

      REM | DESCRIPTION

      REM |   SQL script that gathers stats in 10g database.

      REM |   This should be run immediately after the 10g upgrade.

      REM |   This SQL script must be run as SYS user, from the ORACLE_HOME

      REM |   on the Database Server.

      REM |

      REM | USAGE

      REM |

      REM |   sqlplus  '/ as sysdba' @adstats.sql

      REM |

      REM | HISTORY

      REM |      04-25-2005   RAHKUMAR    CREATED

      REM +=========================================================================+

       

       

      I am running it to upraded 12.1.0.2

      Is it applicable to 12c? or will my statistics be corrupted?

       

      Please shed lights...

       

       

      Kind regards,

      jc

        • 1. Re: adstats.sql after the upgrading 10.2.0.5 to 12.1.0.2
          mdtaylor

          Hi jc,

           

          Yes, for 12.0/12.1, you still need to gather stats for sys schema by running adstats.sql per the interop doc.  This will not corrupt any product statistics you have, but will help to avoid performance issues due to stale dictionary (sys) stats.

           

          Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)

           

          25. Gather statistics for SYS schema

           

          Regards,

          Michael

          • 2. Re: adstats.sql after the upgrading 10.2.0.5 to 12.1.0.2
            Beauty_and_dBest

            Thanks Michael,

             

            Is there new version of this adstats.sql? Maybe a copy from 12.2.7 Appl Top will do?

             

            By the way, the next step is:

             

            Create the new MGDSYS schema:

            • $ cd $ORACLE_HOME/rdbms/admin/catmgd.sql

            $sqlplus / as sysdba

            SQL> @catmgd.sql

             

            But I got error below

             

            Exception in thread "Root Thread" java.lang.SecurityException: policy table

            update SYS:javax.management.MBeanServerPermission, createMBeanServer

                    at

            oracle.aurora.rdbms.security.PolicyTableManager.checkPermission(PolicyTableManag

            er.java:132)

                    at

            oracle.aurora.rdbms.security.PolicyTableManager.activate(PolicyTableManager.java

            :547)

                    at

            oracle.aurora.rdbms.security.PolicyTableManager.grant(PolicyTableManager.java:59

            8)

            call dbms_java.grant_permission( 'MGDSYS', 'SYS:javax.management.MBeanServerPermission', 'createMBeanServer', '' )

                 *

            ERROR at line 1:

            ORA-29532: Java call terminated by uncaught Java exception:

            java.lang.SecurityException: policy table update

            SYS:javax.management.MBeanServerPermission, createMBeanServer

             

             

            Exception in thread "Root Thread" java.lang.SecurityException: policy table

            update SYS:javax.management.MBeanPermission,

            oracle.jdbc.driver.OracleLog#-[com.oracle.jdbc:type=diagnosability]

                    at

            oracle.aurora.rdbms.security.PolicyTableManager.checkPermission(PolicyTableManag

            er.java:132)

                    at

            oracle.aurora.rdbms.security.PolicyTableManager.activate(PolicyTableManager.java

            :547)

                    at

            oracle.aurora.rdbms.security.PolicyTableManager.grant(PolicyTableManager.java:59

            8)

            call dbms_java.grant_permission( 'MGDSYS', 'SYS:javax.management.MBeanPermission', 'oracle.jdbc.driver.OracleLog#-[com.oracle.jdbc:type=diagnosability]', 'registerMBean' )

                 *

            ERROR at line 1:

            ORA-29532: Java call terminated by uncaught Java exception:

            java.lang.SecurityException: policy table update

            SYS:javax.management.MBeanPermission,

            oracle.jdbc.driver.OracleLog#-[com.oracle.jdbc:type=diagnosability]

             

             

             

            Please help....

             

            Kind regards,