9 Replies Latest reply on Apr 28, 2016 6:02 PM by jaccoud

Connecting to Oracle from Protégé

jaccoud Apr 20, 2016 6:50 PM

Hi Guys,

I'm starting tests on Oracle RDF support. I've managed to install Sem&Graph on a lab VM and I can connect easily with SQL Developer, using a Basic connection and SYSDBA attributes. However, when trying to connect using the Protégé plug-in, I get multiple errors.

1) When tryin to use the sys account I get "connection as SYS should be as SYSDBA or SYSOPER", but there is no way to select attributes.

2) When trying to use any other username, I get "Server encountered problems accessing LDAP directory service", obviously because there is no such service, and also no way to select the connection type.

Any way around this? Requirements no manuals for the plug-in did not mention anything about connection limitations to LDAP and some attributes.

Any help would be much appreciated.

Best regards,

Marcelo Jaccoud

Petrobrás, Rio de Janeiro

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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions

Go to original post