-
1. Re: Connecting to Oracle from Protégé
alwu-Oracle Apr 21, 2016 7:54 PM (in response to jaccoud)Hi,
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.
Thanks,
Zhe Wu
-
2. Re: Connecting to Oracle from Protégé
jaccoud Apr 22, 2016 1:48 PM (in response to alwu-Oracle)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...
Best regards,
Marcelo
-
3. Re: Connecting to Oracle from Protégé
alwu-Oracle Apr 25, 2016 5:16 AM (in response to jaccoud)Hi Marcelo,
Did you enable RDF and create sem network?
Thanks,
Zhe
-
4. Re: Connecting to Oracle from Protégé
jaccoud Apr 25, 2016 1:23 PM (in response to alwu-Oracle)Hi
Yes, I followed the procedures in the developer's guide. As instructed, I checked the results, and the query
select * from MDSYS.RDF_PARAMETER
returns
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 12.1.0.2.0 VALID
as expected.
Is there any extra procedure that is not in the guide? I assumed the plug-in would handle specific table creation etc.
Best regards,
Marcelo Jaccoud
-
5. Re: Connecting to Oracle from Protégé
jaccoud Apr 25, 2016 6:45 PM (in response to alwu-Oracle)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).
Any light?
[]s
Marcelo
-
6. Re: Connecting to Oracle from Protégé
alwu-Oracle Apr 26, 2016 3:56 PM (in response to jaccoud)Hi Marcelo,
Let's do a quick test using SQL*Plus. Please run the following and see if they pass OK.
conn <your_user_name>/<your_user_password>
create table test_tpl(triple sdo_rdf_triple_s);
exec sem_apis.create_sem_model('test', 'test_tpl', 'triple');
Thanks,
Zhe Wu
-
7. Re: Connecting to Oracle from Protégé
jaccoud Apr 27, 2016 4:54 PM (in response to alwu-Oracle)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.
Any insight?
Cheers.
-
8. Re: Connecting to Oracle from Protégé
alwu-Oracle Apr 27, 2016 10:10 PM (in response to jaccoud)Hi,
Did you run sem_apis.create_sem_network('<your_tablespace_name_here>') as sys?
Thanks,
Zhe -
9. Re: Connecting to Oracle from Protégé
jaccoud Apr 28, 2016 6:02 PM (in response to alwu-Oracle)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.
Best regards.