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.