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;
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 !!
John Knox said
+1, Add an article in my bookmarks!
Oracle Semantic Technologies « Semantic Web, a web of meaningful relations said
[…] Semantic data management on Windows XP and configure semantic web technology support in Oracle 11g. Related […]
Internet Leashed said
Right on !! Damn I’m getting addicted to your blog 🙂
freeinternetpalestine said
thx dude! you are the best!
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.
Aditya Thatte said
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