8 Replies Latest reply on Apr 8, 2010 5:02 PM by Matperry-Oracle

    errors creating rdf network

    638832
      Hello.

      I have installed an Oracle 11.2 and didn't knew that the patch for semantic technologies comes different than for release 11.1. So i copied all the necesary files from the Oracle_home/md/admin from the release 11.1 and executed catsem10i.sql and catsem11i.sql. After i realised that the patch for release 11.2 exists on the oracle website.

      ........I have runned semremov.sql to remove any semantic technology support. After that i runned catsem.sql....

      The problem is the following:

      I am trying to create an RDF network. I connect with sys as sysdba to the database and I execute the following:

      EXECUTE SDO_RDF.CREATE_RDF_NETWORK('rdf_tblspace');

      and i get:

      BEGIN SDO_RDF.CREATE_RDF_NETWORK('rdf_tblspace'); END;

      *
      ERROR at line 1:
      ORA-55321: network already exists
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 7726
      ORA-06512: at "MDSYS.SDO_RDF", line 1089
      ORA-06512: at line 1

      After that, when i log in the database with mdsys user and try to create the semantic model, i execute the following:

      SQL> EXECUTE SDO_RDF.CREATE_RDF_MODEL('articles', 'articles_rdf_data', 'triple');
      BEGIN SDO_RDF.CREATE_RDF_MODEL('articles', 'articles_rdf_data', 'triple'); END;

      *
      ERROR at line 1:
      ORA-13199: Tablespace "" does not exist
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF", line 974
      ORA-06512: at line 1

      Can you please tell me what is the problem?

      Thank you.
      Catali
        • 1. Re: errors creating rdf network
          Matperry-Oracle
          Hi,

          Please run the following query as sysdba and post the results:

          select * from mdsys.rdf_parameter;

          Thanks,
          -Matt
          • 2. Re: errors creating rdf network
            638832
            Hi. Here is the result.


            NAMESPACE ATTRIBUTE
            ------------------------------ ------------------------------
            VALUE
            --------------------------------------------------------------------------- -----
            DESCRIPTION
            --------------------------------------------------------------------------- -----
            COMPONENT RDFCTX
            INSTALLED
            Semantic (Text) Search component

            COMPONENT RDFOLS
            INSTALLED
            RDF Optional component for OLS support

            NAMESPACE ATTRIBUTE
            ------------------------------ ------------------------------
            VALUE
            --------------------------------------------------------------------------- -----
            DESCRIPTION
            --------------------------------------------------------------------------- -----

            COMPONENT RDFVPD
            INSTALLED
            RDF Optional component for VPD support

            MDSYS SEM_VERSION
            112

            NAMESPACE ATTRIBUTE
            ------------------------------ ------------------------------
            VALUE
            --------------------------------------------------------------------------- -----
            DESCRIPTION
            --------------------------------------------------------------------------- -----
            VALID

            Catalin
            • 3. Re: errors creating rdf network
              Matperry-Oracle
              If there is no data in the semantic network that you need, you can try the following as sysdba to drop the RDF Network.

              exec sem_apis.drop_sem_network(cascade=>true);

              Then, please try to create the network again.
              • 4. Re: errors creating rdf network
                638832
                Hi.....here is what i get:


                SQL>
                SQL> exec sem_apis.drop_sem_network(cascade=>true);

                PL/SQL procedure successfully completed.

                SQL> exec sem_apis.create_sem_network('rdf_tblspace');
                BEGIN sem_apis.create_sem_network('rdf_tblspace'); END;

                *
                ERROR at line 1:
                ORA-13199: Error during RDF Network creation: step_num=2 SQLERRM=ORA-00439:
                feature not enabled: Partitioning. Error backtrace is: ORA-06512: at
                "MDSYS.SDO_RDF_INTERNAL", line 8083
                ORA-06512: at "MDSYS.MD", line 1723
                ORA-06512: at "MDSYS.MDERR", line 17
                ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 8565
                ORA-06512: at "MDSYS.SDO_RDF", line 1146
                ORA-06512: at "MDSYS.SDO_RDF", line 1162
                ORA-06512: at "MDSYS.RDF_APIS", line 1034
                ORA-06512: at line 1

                Catalin
                • 5. Re: errors creating rdf network
                  Matperry-Oracle
                  Hi,

                  Oracle Semantic Technologies requires Oracle Database 11g Enterprise Edition with Oracle Spatial and Oracle Partitioning options. It looks like the Partitioning option is not set up properly in your Oracle Database installation. Please ensure that your installation of Oracle Database 11g Release 2 includes the Partitioning option.

                  You can find more information on the prerequisites for Semantic Technologies here:
                  http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11828/sem_enable.htm#CHDHIAAF

                  Thanks,
                  Matt
                  • 6. Re: errors creating rdf network
                    638832
                    Hello.

                    I thought that Oracle Spatial and Oracle Partitioning options are already installed.

                    "If you are upgrading to Oracle Database 11g, Oracle Spatial is automatically upgraded as part of the operation."

                    http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11830/sdo_migrat.htm#i621386

                    Thanks,
                    Catalin
                    • 7. Re: errors creating rdf network
                      638832
                      Hi.

                      If i don't have partitioning enabled, what do i actually have to do to enable it.

                      Thanks,
                      Catalin
                      • 8. Re: errors creating rdf network
                        Matperry-Oracle
                        Hi Catalin,

                        Please email me at matthew dot perry at oracle dot com with the details of how you upgraded from 11.1 to 11.2.

                        Thanks,
                        Matt