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

    Connecting to Oracle from Protégé

    jaccoud

      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

          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

            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

              Hi Marcelo,

               

              Did you enable RDF and create sem network?

               

              Thanks,

               

              Zhe

              • 4. Re: Connecting to Oracle from Protégé
                jaccoud

                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

                  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

                    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

                      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

                        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

                          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.