TheSemanticBlog

The Semantic Web, Semantic Web Services and more…

Configuring Semantic Web Technology Support in Oracle 11g Release 1 on Windows XP

Posted by Aditya Thatte on January 4, 2009

The Oracle 11g platform offers a scalable, secure, robust platform for semantic web data management. Oracle 11g supports efficient
management of  RDF, OWL by executing simple queries. Data can be stored in the form of  RDF triples and queried easily. Here are a series
of steps to set up Semantic web support in Oracle 11g.

1. Install Oracle 11g and download the “JENADRV” patch from “http://www.oracle.com/technology/software/tech/semantic_technologies/files/jenadrv_patch111rdf.zip“.

2. Extract the JENADRV folder to some directory.
3. Goto Directory Your_Drive_Name:/>Oracle_Home/product/11.0.1.0/md/admin
4. Open SQLPLUS and connect as SYS user.
5. Type the following command at the SQL prompt

– SQL>@Your_Drive_Name:\>Oracle_Home\product\11.0.1.0\md\admin\catsem10i.sql;
1

This command restores Oracle 10 RDF data.

6. Now issue the following command at the SQL prompt

– SQL>@Your_Drive_Name:\>Oracle_Home\product\11.0.1.0\md\admin\catsem11i.sql;

This command installs 11 RDF, confirm with the snapshot given below to check if procedure has been executed successfully.

2

7. Now, alter the “mdsys” user by the following command

-SQL>ALTER USER mdsys ACCOUNT UNLOCKED IDENTIFIED BY mdsys;

3

8. Connect as user “mdsys” as show below
4

9. Now, apply the JENADRV patch to enable Semantic web Data support. Execute the following commands in the same sequence shown below

– SQL>@Your_Drive_Name:\>Extracted_Jenadrv_folder\sdordfh.sql;

5

–  SQL>@Your_Drive_Name:\>Extracted_Jenadrv_folder\sdordfxh.sql;

6

– SQL>@Your_Drive_Name:\>Extracted_Jenadrv_folder\sdordfa.sql;

7

-SQL>@Your_Drive_Name:\>Extracted_Jenadrv_folder\sdordfb.plb;

8

–  SQL>@Your_Drive_Name:\>Extracted_Jenadrv_folder\sdordfxb.plb;

9

– SQL>@Your_Drive_Name:\>Extracted_Jenadrv_folder\sdoseminfhb.plb;

10

– SQL>@Your_Drive_Name:\>Extracted_Jenadrv_folder\sdordfai.plb;

11

10. Connect sys as sysdba

12

11 . Create a new “rdf” tablespace by issuing the following command

CREATE TABLESPACE <<TABLESPACE_NAME>> DATAFILE ‘Your_Drive_Name:\>Oracle_Home\oradata\<SID>\<<TABLESPACE_NAME>>01.dbf’ SIZE 128M REUSE AUTOEXTEND ON NEXT 64M MAXSIZE UNLIMITED SEGMENT SPACE MANAGEMENT AUTO;

13

12. Similarly create a temporary tablespace

CREATE TEMPORARY TABLESPACE <<TEMP_TABLESPACE_NAME>> TEMPFILE ‘Your_Drive_Name:\>Oracle_Home\oradata\<SID>\<<TEMP_TABLESPACE_NAME>>01.dbf’ SIZE 128M REUSE AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED

14

13. Now, create a new “testuser” and grant required privileges as shown in     the snapshot

15

14. Create a semantic network to enable semantic data management

16

15. Create table

17

16. Create a semantic model to enable a semantic data environment

18

Once this is done, you have enabled the semantic web technology support in Oracle 11g Release 1. Happy Semantic Data management !!

Advertisements

8 Responses to “Configuring Semantic Web Technology Support in Oracle 11g Release 1 on Windows XP”

  1. John Knox said

    +1, Add an article in my bookmarks!

  2. […] Semantic data management on Windows XP and configure semantic web technology support in Oracle 11g. Related […]

  3. Right on !! Damn I’m getting addicted to your blog 🙂

  4. thx dude! you are the best!

  5. Sneha said

    hi..i m trying to configure oracle 11g R1 jus t the way u ve showed. but the SQL plus console disappears wen i type in the command
    SQL>@Your_Drive_Name:\>Oracle_Home\product\11.0.1.0\md\admin\catsem10i.sql;

    also, what does the patch JENADRV do?? we just extract t to some folder??

    can u please help me with this?? working on a deadline for m academic project.

    • Hi, I dont understand as to why the console vanishes. It works perfectly fine otherwise. I downloaded the Jenadrv patch 111 as the link suggests. Most of the people who have followed this procedure have been able to successfully install and configure oracle 11g r1

      • Sneha said

        I ve installed oracle in F drive (not in c) does that make any difference?? and upon installing a folder gets created called app.. so the entire command is
        SQL> @F:\app\Sneha\product\11.1.0\db_1\md\admin\catsem11i.sql;

        is there anything wrong in this command?
        About the patch, my question was, aren we supposed to use t anywhere during installation? are we supposed to just extract t to any folder or is there a particular folder to do so?

        Looking forward to a solution,

        Thank you

      • Sneha said

        how do i connect as a SYS user? coz everytime i try to, it says u need to connect as sysdba or sysoper. i tried running that command as system. maybe thats why t s closing by itself.

        plz plz plz reply back as soon as possible. 🙂
        Thanks and regards,
        Sneha

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: