Please do NOT use SYS (or SYSTEM) account as a user schema to store/access RDF graph data. Instead, create your own user or use the "scott" account.
Thank you very much for your help.
My user was indeed an alias to sys. I created a new user with all concessions and no admin rights, and now I can connect from the plug-in. However, no plug-in menu option works beside the connection, I can not even save an ontology to start. I tried to grant the user full admin rights as well and even then got no answer from the plug-in -- no confirmation nor error dialog, nothing, nada. Is there a log file I can check for errors? I fell like I'm traveling blindfolded...
Did you enable RDF and create sem network?
Yes, I followed the procedures in the developer's guide. As instructed, I checked the results, and the query
select * from MDSYS.RDF_PARAMETER
COMPONENT RDFCTX INSTALLED Semantic (Text) Search component
COMPONENT RDFOLS INSTALLED RDF Optional component for OLS support
COMPONENT RDFVPD INSTALLED RDF Optional component for VPD support
MDSYS SEM_VERSION 22.214.171.124.0 VALID
Is there any extra procedure that is not in the guide? I assumed the plug-in would handle specific table creation etc.
I'm getting this exception on the Protégé window:
java.sql.SQLSyntaxErrorException: ORA-00942: a tabela ou view n├úo existe
which translated means "the table or view does not exist".
Looks there is some initialization needed besides the one on the developer's guide that I just reported (running catsem.sql).
Let's do a quick test using SQL*Plus. Please run the following and see if they pass OK.
create table test_tpl(triple sdo_rdf_triple_s);
exec sem_apis.create_sem_model('test', 'test_tpl', 'triple');
I got the following response. (Error messages behave erratically regarding language/locale. I [translated] the Portuguese portions.)
Table TEST_TPL criado. [table created]
Erro a partir da linha : 3 no comando - [Error beginning in line: 3 on command - ]
exec sem_apis.create_sem_model('test', 'test_tpl', 'triple')
Relatório de erros - [Error report - ]
ORA-13199: Tablespace "" does not exist
ORA-06512: em "MDSYS.MD", line 1723
ORA-06512: em "MDSYS.MDERR", line 17
ORA-06512: em "MDSYS.SDO_RDF", line 1899
ORA-06512: em "MDSYS.SDO_RDF", line 1953
ORA-06512: em "MDSYS.RDF_APIS", line 1230
ORA-06512: em line 1
13199. 00000 - "%s"
*Cause: This is an internal error.
*Action: Contact Oracle Support Services.
Did you run sem_apis.create_sem_network('<your_tablespace_name_here>') as sys?
I tried, and discovered the DBA had not created the tablespace as we asked for. Once the tablespace and network were set, the plug-in started to work as expected.
Thank you a lot! Your help was much appreciated.