7 Replies Latest reply on Aug 20, 2008 1:48 PM by 487020

    Problems applying patch for Jena adapter

    637657
      I got errors when applying the patch to 11g (11.1.0.6) for the Jena Driver (from OTN). I executed each .sql/.plb file in the order stated by the patch instructions:
      jenadrv_patch_ig.txt: Step-by-step instructions (new Oracle Database 11g installation). When I executed sdordfxb.plb I got the folowing:

      SQL> @sdordfxb.plb

      Warning: Package Body created with compilation errors.

      Errors for PACKAGE BODY SDO_RDF:

      LINE/COL ERROR
      -------- -----------------------------------------------------------------
      1243/5 PL/SQL: Statement ignored
      1243/28 PLS-00302: component 'ANALYZE_MODEL' must be declared
      1272/5 PL/SQL: Statement ignored
      1272/28 PLS-00302: component 'ANALYZE_RULES_INDEX' must be declared
      1298/5 PL/SQL: Statement ignored
      1298/28 PLS-00302: component 'DELETE_MODEL_STATS' must be declared
      1317/5 PL/SQL: Statement ignored
      1317/28 PLS-00302: component 'DELETE_RULES_INDEX_STATS' must be declared

      Synonym created.


      Synonym created.


      Grant succeeded.


      After this the SDO_RDF package could not be found when making semantic API calls.

      Any idea what I did wrong? I rolled back from the patch by re-executing the backed up (pre-patch) versions of the .sql and .plb files which successfully restored the SDO_RDF package but I still can't install the patch.

      Thanks.
        • 1. Re: Problems applying patch for Jena adapter
          alwu-Oracle
          which DB schema (user) did you run the sql/plb in?
          • 2. Re: Problems applying patch for Jena adapter
            637657
            MDSYS, as instructed.
            • 3. Re: Problems applying patch for Jena adapter
              alwu-Oracle
              Have you run catsem11i as shown in the Example section (step2)?

              If you don't mind, please re-run the whole patching process (starting from catsem11i) and cut&paste the whole sqlplus session.

              Thanks.
              • 4. Re: Problems applying patch for Jena adapter
                637657
                After trying to re-run the patch process I couldn't get catsem11i to run successfully. I have dropped my models, network, and removed the model data tables (that I originally created) containing SDO_RDF_TRIPLE data types so I'm not sure why I'm getting the error below. Any idea where else these dependenices could be or how to fully clean?


                C:\app\skagels\product\11.1.0\db_2\md\admin>sqlplus / as sysdba

                SQL*Plus: Release 11.1.0.6.0 - Production on Thu May 8 14:51:46 2008

                Copyright (c) 1982, 2007, Oracle. All rights reserved.


                Connected to:
                Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                SQL> @catsem11i.sql
                install 11 RDF
                check privileges

                PL/SQL procedure successfully completed.


                PL/SQL procedure successfully completed.





                Uninstall 10.2 RDF? => ?/rdbms/admin/nothing.sql
                declare
                *
                ERROR at line 1:
                ORA-20000: Cannot proceed. Dependencies for RDF 11 type SDO_RDF_TRIPLE[_S]
                (count=6)
                ORA-06512: at line 81


                Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                C:\app\skagels\product\11.1.0\db_2\md\admin>
                • 5. Re: Problems applying patch for Jena adapter
                  alwu-Oracle
                  Send email to alan dot wu at oracle dot com. And I will help you off line. We will put a summary here after the problem is fixed.
                  • 6. Re: Problems applying patch for Jena adapter
                    alwu-Oracle
                    The problem is fixed as follows.

                    As SYS or MDSYS, do the following (be sure that there is no RDF data in the database)

                    SQL> drop type mdsys.sdo_rdf_triple force;
                    SQL> drop type mdsys.sdo_rdf_triple_s force;
                    SQL> commit;

                    Then re-run catsem11i as documented.
                    • 7. Re: Problems applying patch for Jena adapter
                      487020
                      This almost worked for me, but I also had to drop one additional type that was giving me problems (see below). After doing this, I was able to run catsem11i without errors, and then I ran all of the additional patch files without a hitch.

                      SQL> drop type mdsys.sdo_rdf_triple force;
                      SQL> drop type mdsys.sdo_rdf_triple_s force;
                      SQL> drop type mdsys.sdo_bt_handle force;
                      SQL> commit;