Forum Stats

  • 3,854,188 Users
  • 2,264,339 Discussions
  • 7,905,594 Comments

Discussions

Problems setting up Semantic tech in Orac le 11G running Linux.

260862
260862 Member Posts: 6
edited Jun 13, 2010 6:35PM in RDF Graph & Property Graph
Hi Every1,
Am a novice at this Semantic Techno stuff and am trying to overcome that. Am trying to set up an 11G semantic tech baseline on a Linux box and am having difficulties getting everything loaded. Here is where I am at:
1. Installed JDK V5.
2. Installed Oracle 11Gr2 w/spatial and partitioning.
3. Installed Jena V 2.6.2 (jena-2.6.2.zip) IAW Oracle Semantic Technologies Developers guide.
4. Installed Jena Adaptor (jena_adaptor_for_release11-2.zip) IAW Oracle Semantic Technologies Developers guide.
5. Installed Oracle WebLogic Server 11g Release 1(10.3.1).
6. Installed Java 6.1.
7. Installed Joseki 3.4.0 IAW Oracle Semantic Technologies Developers guide.
8. Created J2EE data source in WebLogic Server admin console IAW Oracle Semantic Technologies Developers guide.
9. Completed the autodeploy tasks IAW Oracle Semantic Technologies Developers guide.
10. Restarted WebLogic Server.
11. Attempted to verify the deployment via web browser (http://localhost.localdomain:7001/joseki) and received an Error 404—Not Found From RFC 2068 message vice the Oracle SPARQL Service Endpoint page as expected.
Am at a loss … can anyone identify where I went wrong and how to fix this problem?
«1

Answers

  • 681909
    681909 Member Posts: 14
    We did the same steps you described. We get joseki to display and run using this URL:

    http://localhost:7001/joseki/. Of course, substitute localhost for wherever you did the install.
  • alwu-Oracle
    alwu-Oracle Member Posts: 1,007
    Hi,

    Have you created the semantic network?

    http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11828/sem_enable.htm
    http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11828/sem_apis_ref.htm#BABFAFJC

    Thanks,

    Zhe Wu
  • 260862
    260862 Member Posts: 6
    Yes, semantic network was created and an example ontology was loaded.
  • alwu-Oracle
    alwu-Oracle Member Posts: 1,007
    Good. Is there any suspicious server log on WLS side?

    Thanks,

    Zhe
  • 260862
    260862 Member Posts: 6
    No suspicious logs....a thought just cxame to me that WLS admin console was up and running on same port....am thinking this may be why joseki page wouldn't display.
  • alwu-Oracle
    alwu-Oracle Member Posts: 1,007
    Actually they should be on the same port.

    Could you cut & paste the actions you did for the following step? Which directory did you
    copy all those files into?

    7. Installed Joseki 3.4.0 IAW Oracle Semantic Technologies Developers guide.

    Thanks,

    Zhe Wu
  • 260862
    260862 Member Posts: 6
    Here are the steps I used loading Joseki.

    1. Download and Install Oracle WebLogic Server 11g Release 1 (10.3.1). For details, see http://www.oracle.com/technology/products/weblogic/.

    2. Ensure that you have Java 1.6 installed, because it is required by Joseki 3.4.0.

    3. Download Joseki 3.4.0 (joseki-3.4.0.zip) from http://sourceforge.net/projects/joseki/files/Joseki-SPARQL/.

    4. Unpack joseki-3.4.0.zip into a temporary directory. For example:

    mkdir /tmp/joseki
    cp joseki-3.4.0.zip /tmp/joseki
    cd /tmp/joseki
    unzip joseki-3.4.0.zip

    5. Ensure that you have downloaded and unzipped the Jena Adaptor for Oracle Database, as explained in Section 7.1.

    6. Create a directory named joseki.war at the same level as the jena_adaptor directory, and go to it. For example:

    mkdir /tmp/joseki.war
    cd /tmp/joseki.war

    7. Copy necessary files into the directory created in the preceding step:

    cp /tmp/jena_adaptor/joseki/* /tmp/joseki.war
    cp -rf /tmp/joseki/Joseki-3.4.0/webapps/joseki/StyleSheets /tmp/joseki.war

    8. Create directories and copy necessary files into them, as follows:

    mkdir /tmp/joseki.war/WEB-INF
    cp /tmp/jena_adaptor/web/* /tmp/joseki.war/WEB-INF

    mkdir /tmp/joseki.war/WEB-INF/lib
    cp /tmp/joseki/Joseki-3.4.0/lib/*.jar /tmp/joseki.war/WEB-INF/lib
    cp /tmp/jena_adaptor/jar/*.jar /tmp/joseki.war/WEB-INF/lib


    cp $ORACLE_HOME/md/jlib/sdordf.jar /tmp/joseki.war/WEB-INF/lib
    cp $ORACLE_HOME/jdbc/lib/ojdbc6.jar /tmp/joseki.war/WEB-INF/lib

    Note that in the last command, you can specify ojdbc6.jar instead of ojdbc5.jar if you are using JDK 6.

    9. Using the WebLogic Server Administration console, create a J2EE data source named OracleSemDS. During the data source creation, you can specify a user and password for the database schema that contains the relevant semantic data against which SPARQL queries are to be executed.

    If you need help in creating this data source, see Section 7.2.1, "Creating the
    Required Data Source Using WebLogic Server".


    7.2.1 Creating the Required Data Source Using WebLogic Server

    If you need help creating the required J2EE data source using the WebLogic Server admin console, you can follow these steps:

    1. Login to: http://<hostname>:7001/console

    2. In the Domain Structure panel, click Services.

    3. Click JDBC

    4. Click Data Services.

    5. In the Summary of JDBC Data Sources panel, click New under the Data Sources table.

    6. In the Create a New JDBC Data Source panel, enter or select the following values.

    Name: OracleSemDS
    JNDI Name: OracleSemDS
    Database Type: Oracle
    Database Driver: Oracle's Driver (Thin) For Instance Connections Versions: 9.0.1,9.2.0,10,11

    7. Click Next twice.

    8. In the Connection Properties panel, enter the appropriate values for the Database Name, Host Name, Port, Database User Name (schema that contains semantic data), Password fields.

    DATABASE NAME: orcl
    HOST NAME: orcl.localdomain
    PORT: 1521
    DATABASE USWER NAME: nciuser
    PASSWORD: <password>
    CONFIRM PASSWORD: <password>



    9. Click Next.

    10. Select (check) the target server or servers) to which you want to deploy this OracleSemDS data source.

    11. Click Finish.

    You should see a message that all changes have been activated and no restart is necessary.


    10. Go to the autodeploy directory of WebLogic Server and copy files, as follows.(For information about auto-deploying applications in development domains, see: http://download.oracle.com/docs/cd/E11035_01/wls100/deployment/autodeploy.html)

    cd <domain_name>/autodeploy
    cp -rf /tmp/joseki.war <domain_name>/autodeploy


    In the preceding example, <domain_name> is the name of a WebLogic Server domain.

    Note that while you can run a WebLogic Server domain in two different modes, development and production, only development mode allows you use the auto-deployment feature.

    11. Check the files and the directory structure, as in the following example:

    autodeploy/% ls -1R ./joseki.war/

    ./joseki.war:
    application.xml
    index.html
    joseki-config.ttl
    StyleSheets/
    update.html
    WEB-INF/
    xml-to-html.xsl

    ./joseki.war/StyleSheets:
    joseki.css

    ./joseki.war/WEB-INF:
    lib/
    web.xml

    ./joseki.war/WEB-INF/lib:
    arq-2.8.0.jar
    arq-2.8.0-tests.jar
    icu4j-3.4.4.jar
    iri-0.7.jar
    jena-2.6.2.jar
    jenatest-2.6.2.jar
    jetty-6.1.10.jar
    jetty-util-6.1.10.jar
    joseki-3.4.0.jar
    junit-4.5.jar
    log4j-1.2.12.jar
    lucene-core-2.3.1.jar
    ojdbc5.jar
    sdordfclient.jar
    sdordf.jar
    servlet-api-2.5-6.1.10.jar
    servlet-api-2.5.jar
    slf4j-api-1.5.6.jar
    slf4j-log4j12-1.5.6.jar
    stax-api-1.0.1.jar
    wstx-asl-3.2.9.jar
    xercesImpl-2.7.1.jar

    12. Start or restart WebLogic Server.

    13. Verify your deployment by using your Web browser to connect to a URL in the following format (assume that the Web application is deployed at port 7001): http://<hostname>:7001/joseki

    You should see a page titled Oracle SPARQL Service Endpoint using Joseki, and the first text box should contain an example SPARQL query.


    This is where I got the http error message instead of the Oracle SPARQL Service Endpoint using Joseki screen.
  • alwu-Oracle
    alwu-Oracle Member Posts: 1,007
    What domain name did you choose for these two steps you performed?

    cd <domain_name>/autodeploy
    cp -rf /tmp/joseki.war <domain_name>/autodeploy

    Thanks,
    Zhe Wu
  • 260862
    260862 Member Posts: 6
    cd /home/oracle/Oracle/Middleware/wlserver_10.3/samples/domains/wlserver/autodeploy
    cp -rf /tmp/joseki.war /home/oracle/Oracle/Middleware/wlserver_10.3/samples/domains/wlserver/autodeploy
  • alwu-Oracle
    alwu-Oracle Member Posts: 1,007
    Please email me at alan dot wu at oracle dot com. I can then start a web conference to look at your configuration. It will be a lot easier that way.

    Thanks,

    Zhe Wu
This discussion has been closed.