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

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;

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.

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

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

8. Connect as user “mdsys” as show below

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;

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

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

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

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

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

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

10. Connect sys as sysdba

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;

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

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

14. Create a semantic network to enable semantic data management

15. Create table

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

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