9 Replies Latest reply on Jan 6, 2015 6:21 AM by shifu.zheng

    Failed to set up sparql service on oracle 12c

    shifu.zheng

      According to the user guide of RDF Semantic Graph Support for Apache Jena, I always failed in step 7 of section 7.2 Setting Up the SPARQL Service. I find the following error in weblogic nohup.out:

       

      SEVERE: Constructing GraphOracleSem:

      java.sql.SQLException: ORA-13199:  Error in SDO_RDF.CREATE_RDF_MODEL: SQLERRM=ORA-04063: table "SYSTEM.M_NAMED_GRAPHS_TPL" has errors dss=LOCK TABLE "M_NAMED_GRAPHS_TPL" IN SHARE MODE NOWAIT

      ORA-06512: at "MDSYS.MD", line 1723

      ORA-06512: at "MDSYS.MDERR", line 17

      ORA-06512: at "MDSYS.SDO_RDF", line 1834

      ORA-06512: at line 1

       

      It worked when I set it up in at first time. To alter data file directory, I dropped all table spaces, and created table spaces and users again. Then I always failed to run sparql query on web console.

       

      Could anyone help on this?

       

      Many thanks!