6 Replies Latest reply on Mar 11, 2008 3:20 PM by JorgeB-Oracle

    EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');

    447384
      I just installed oracle 11g on my windows laptop and I'm trying to follow the instructions on page 1-21 of the Semantic Technologies Developer's Guide but I'm getting the following:

      Error starting at line 1 in command:
      EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
      Error report:
      ORA-06550: line 1, column 7:
      PLS-00201: identifier 'SEM_APIS.CREATE_SEM_NETWORK' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored
      06550. 00000 - "line %s, column %s:\n%s"
      *Cause:    Usually a PL/SQL compilation error.
      *Action:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
        • 1. Re: EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
          Mannamal-Oracle
          Hi,

          An additional step needs to be performed after the install. Please see: Problems with SDO_RDF package

          Melli
          • 2. Re: EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
            622983
            I have attempted to initialize semantic technologies as instructed for newly installed Oracle 11g database. First I ran the script catsem11i.sql, which produced mostly benign output, but also things like:

            Warning: execution completed with warning
            PACKAGE BODY rdf_apis_internal Compiled.
            0/0 PLS-00753: malformed or corrupted wrapped unit
            (there are several warning like this)

            After this I created the tablespace:


            CREATE TABLESPACE rdf_tblspace
            DATAFILE '/oracle/oracle/oradata/testdb/rdf_tblspace.dat' SIZE 1024M REUSE
            AUTOEXTEND ON NEXT 256M MAXSIZE UNLIMITED
            SEGMENT SPACE MANAGEMENT AUTO

            CREATE TABLESPACE succeeded.


            And then tried to create semantic network:


            EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');

            Error starting at line 1 in command:
            EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
            Error report:
            ORA-13199: Error during RDF Network creation: step_num=10 SQLERRM=ORA-13199: RDF: Error in load_predefined_rulebases(): SQLERRM=ORA-06508: PL/SQL: could not find program unit being called
            ORA-06512: at "MDSYS.MD", line 1723
            ORA-06512: at "MDSYS.MDERR", line 17
            ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 5307
            ORA-06512: at "MDSYS.SDO_RDF", line 910
            ORA-06512: at "MDSYS.SDO_RDF", line 926
            ORA-06512: at "MDSYS.RDF_APIS", line 715
            ORA-06512: at line 1
            13199. 00000 - "%s"
            *Cause:    This is an internal error.
            *Action:   Contact Oracle Support Services.


            The result quite crearly is not what it is supposed to be. Does anyone have any idea what I might be doing wrong? For now I'm doing all these logged in under SYS AS SYSDBA, but I also tried creating the tablespace and network as regular DBA, and the results are the same. The result is also same both on Windows and Redhat platforms. I have not worked with Oracle databases before, so there might be something really basic that I'm overlooking. The spatial module is installed and database block size is 8K, which are only things I have seen mentioned as prequisites for the semantic functionality.

            -- Matti
            • 3. Re: EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
              Mannamal-Oracle
              Hi Matti,

              You should not get the first error:

              Warning: execution completed with warning
              PACKAGE BODY rdf_apis_internal Compiled.
              0/0 PLS-00753: malformed or corrupted wrapped unit
              (there are several warning like this)

              That sounds as though the install did not go through cleanly, and some of the files were corrupted. Did the database install go through cleanly? If not, would it be possible to cleanup and re-install the database?

              Melli
              • 4. Re: EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
                JorgeB-Oracle
                Hi Matti,

                As suggested by Melli, I would try a new database. That would be faster than troubleshooting that error.

                One thing that can be done also is to review the DBA_REGISTRY and the invalid objects in the database:

                select comp_name, status, version
                from dba_registry;

                select owner, object_name, object_type
                from dba_objects
                where status='INVALID';

                If there are some invalids try running
                connected as sys as sysdba

                @?/rdbms/admin/utlrp.sql

                and try the queries again:

                select comp_name, status, version
                from dba_registry;

                select owner, object_name, object_type
                from dba_objects
                where status='INVALID';

                Regards!
                Jorge
                • 5. Re: EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
                  JorgeB-Oracle
                  I think I found the reason of the problem.

                  For unknwon reason there are a couple of pakages that were created under SYS that should have got created under MDSYS

                  Those are:

                       RDF_APIS_INTERNAL
                       RDF_APIS

                  Those are created in script sdordfai.sql


                  Drop the packages under SYS

                  conn / as sysdba
                  drop package RDF_APIS_INTERNAL;
                  drop package      RDF_APIS;

                  If there are other RDF objects under SYS, drop them as well:

                  select object_name from dba_objects
                  where object_name like '%RDF%'
                  and owner='SYS';

                  Then re-run catsem11i.sql
                  • 6. Re: EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
                    JorgeB-Oracle
                    I think the reason why the packages are created under SYS instead of MDSYS is because the script is executed from another tool that is not sqlplus. Maybe SQL Developer GUI tool or TOAD