12 Replies Latest reply on Jul 29, 2019 6:14 AM by Maaz Khan

    ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3

    Maaz Khan

      Hi All,

       

       

      We have recently migrated uat instance from Linux x86_64 to Solaris 11.3.

      DB Version 11.2.0.4

       

      However, I see multiple invalid objects under ODM schema and they are not getting validated even after running utlrp

      All of them are of object_type Java Class.

       

      Appreciate your support in resolving this. Attached invalid object list for your reference.

       

      Note: Doc ID 784828.1 already tried but no luck.

       

      Regards,

      MAaz

        • 1. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
          Kanda-Oracle

          can you check

           

          SQL> select  comp_name,version,status from dba_registry


          Thanks!

          • 2. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
            Maaz Khan

            COMP_NAME                                     VERSION                        STATUS

            --------------------------------------------- ------------------------------ ---------

            Oracle Text                                   11.2.0.4.0                     VALID

            OLAP Catalog                                  11.2.0.4.0                     VALID

            Spatial                                       11.2.0.4.0                     VALID

            Oracle Multimedia                             11.2.0.4.0                     VALID

            Oracle XML Database                           11.2.0.4.0                     VALID

            Oracle Database Catalog Views                 11.2.0.4.0                     VALID

            Oracle Database Packages and Types            11.2.0.4.0                     VALID

            Oracle Real Application Clusters              11.2.0.4.0                     INVALID

            JServer JAVA Virtual Machine                  11.2.0.4.0                     VALID

            Oracle XDK                                    11.2.0.4.0                     VALID

            OLAP Analytic Workspace                       11.2.0.4.0                     VALID

            Oracle OLAP API                               11.2.0.4.0                     VALID

            Oracle Data Mining                            11.2.0.4.0                     VALID

            • 3. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
              Kanda-Oracle

              everything is fine except Oracle Real Application Clusters

              • 4. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
                Kanda-Oracle

                Hi

                 

                Can you check the objects.

                 

                SQL> select DBMS_JAVA.LONGNAME(OBJECT_NAME) JAVA_NAME

                from dba_objects

                where object_type in ('JAVA CLASS','JAVA RESOURCE','JAVA SOURCE')

                and status='INVALID';

                 

                Thanks!

                • 5. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
                  Maaz Khan

                  Yes, we are not using Real Application Clusters.

                   

                   

                  Regards,

                  Maaz

                  • 6. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
                    Kanda-Oracle

                    if you check out  DBMS_JAVA.LONGNAME(OBJECT_NAME) JAVA_NAME you may get some clue.

                    • 7. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
                      Maaz Khan

                      SQL> select DBMS_JAVA.LONGNAME(OBJECT_NAME) JAVA_NAME
                      from dba_objects
                      where object_type in ('JAVA CLASS','JAVA RESOURCE','JAVA SOURCE')
                      and status='INVALID';  2    3    4

                      JAVA_NAME
                      --------------------------------------------------------------------------------
                      oracle/dmt/odm/DataMiningServer
                      oracle/dmt/odm/ODMConnection
                      oracle/dmt/odm/internal/util/EISUtils$ODM_MINING_TRANSFORMATION
                      oracle/dmt/odm/internal/util/EISUtils
                      oracle/dmt/odm/transformation/Transformation$Constants
                      oracle/dmt/odm/transformation/Transformation$SqlStatements
                      oracle/dmt/odm/transformation/Transformation
                      oracle/dmt/odm/result/ClassificationTestResult
                      oracle/dmt/odm/result/MiningApplyResult
                      oracle/dmt/odm/result/MiningBuildResult
                      oracle/dmt/odm/result/MiningLiftResult
                      oracle/dmt/odm/result/MiningResult
                      oracle/dmt/odm/result/MiningTestResult
                      oracle/dmt/odm/result/ModelSeekerResult
                      oracle/dmt/odm/result/ModelSeekerResultEntry
                      oracle/dmt/odm/model/AdaptiveBayesNetworkModel$RuleComparator
                      oracle/dmt/odm/model/AdaptiveBayesNetworkModel$TargetNode
                      oracle/dmt/odm/model/AdaptiveBayesNetworkModel
                      oracle/dmt/odm/internal/result/ODMModelSeekerResultEntry
                      oracle/dmt/odm/internal/result/ODMModelSeekerResult
                      oracle/dmt/odm/internal/result/ODMClassificationTestResult
                      oracle/dmt/odm/internal/model/ODMAdaptiveBayesNetworkModel
                      oracle/dmt/odm/internal/model/PMMLARModelExport
                      oracle/dmt/odm/internal/model/PMMLARModelImport
                      oracle/dmt/odm/internal/model/PMMLModelExport$XMLString
                      oracle/dmt/odm/internal/model/PMMLModelExport
                      oracle/dmt/odm/internal/model/PMMLModelImport
                      oracle/dmt/odm/internal/model/PMMLNBModelExport$ODM_NAIVE_BAYES_MODEL
                      oracle/dmt/odm/internal/model/PMMLNBModelExport
                      oracle/dmt/odm/internal/model/PMMLNBModelImport
                      oracle/dmt/odm/task/ClassificationTestTask
                      oracle/dmt/odm/task/CrossValidateTask
                      oracle/dmt/odm/task/MiningApplyTask
                      oracle/dmt/odm/task/MiningBuildTask
                      oracle/dmt/odm/task/MiningDataTask
                      oracle/dmt/odm/task/MiningLiftTask
                      oracle/dmt/odm/task/MiningTask
                      oracle/dmt/odm/task/ModelExportTask
                      oracle/dmt/odm/task/ModelImportTask
                      oracle/dmt/odm/task/ModelSeekerTask
                      oracle/dmt/odm/internal/task/DMSApplyTask
                      oracle/dmt/odm/internal/task/DMSBuildTask$MODEL_TYPE$A
                      oracle/dmt/odm/internal/task/DMSBuildTask$MODEL_TYPE
                      oracle/dmt/odm/internal/task/DMSBuildTask$ODM_ABN_MODEL
                      oracle/dmt/odm/internal/task/DMSBuildTask$ODM_ASSOCIATION_RULE_MODEL
                      oracle/dmt/odm/internal/task/DMSBuildTask$ODM_ATTRIBUTE_IMPORTANCE_MODEL
                      oracle/dmt/odm/internal/task/DMSBuildTask$ODM_CLUSTERING_MODEL
                      oracle/dmt/odm/internal/task/DMSBuildTask$ODM_NAIVE_BAYES_MODEL
                      oracle/dmt/odm/internal/task/DMSBuildTask
                      oracle/dmt/odm/internal/task/DMSLiftTask
                      oracle/dmt/odm/internal/task/DMSModelExportTask
                      oracle/dmt/odm/internal/task/DMSModelImportTask
                      oracle/dmt/odm/internal/task/DMSModelSeekerTask
                      oracle/dmt/odm/internal/task/DMSCrossValidateTask
                      oracle/dmt/odm/internal/task/DMSMonitor
                      oracle/dmt/odm/internal/task/DMSTask
                      oracle/dmt/odm/internal/task/DMSBuildTableSet
                      oracle/dmt/odm/internal/task/DMSTestTask
                      oracle/dmt/odm/internal/task/ODMMiningTask

                      59 rows selected.

                      • 8. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
                        Kanda-Oracle

                        Hi,

                         

                        For Similar issue...you may explore (Doc ID 821623.1) . Please check it out in TEST instance first and share the results.

                         

                        Hope this helps!

                         

                        Thanks!

                        • 9. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
                          Maaz Khan

                          Hi Kanda,

                           

                          Please find below -

                          SQL> select owner, object_name,object_type from dba_objects where status='INVALID' and owner='DMSYS';
                          no rows selected

                          SQL>

                          Objects under ODM schema are invalid. Doc ID 821623.1 suggests to drop 21 invalid java class objects under DMSYS, however in my case, there are 59 invalid java class objects under ODM.

                           

                          I would like to make sure there are no implications after dropping these objects as our issue seems to be different.

                           

                          Regards,

                          Maaz

                          • 10. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
                            Kanda-Oracle

                            Hi

                             

                            Yes. Let us check before you proceed.

                             

                            Can you check, Do you have 'Enum' exists in DMSYS schema ?


                            Thanks!

                            • 11. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
                              Maaz Khan

                              Hi Kanda,

                               

                              Please find below, dmsys schema itself doesn't exist.

                               

                              SQL> select count(*) from dba_objects
                                2  where owner like 'DMSYS';

                                COUNT(*)
                              ----------
                                       0

                              SQL> select count(*) from dba_objects
                                2  where owner like 'ODM';

                                COUNT(*)
                              ----------
                                     463

                              SQL> select count(*) from dba_objects
                                2  where owner like 'DM%';

                                COUNT(*)
                              ----------
                                       0

                              SQL> select username from dba_users
                                2  where username like 'DM%';

                              no rows selected

                              • 12. Re: ebs r12.1.3 cross platform migration from Linux x86_64 to Solaris 11.3
                                Maaz Khan

                                I have one SR opened, will keep you posted.

                                 

                                 

                                Regards,

                                MAaz