Configuring Semantic Web Technology for Oracle 11g

In order to enable semantic web technology for Oracle 11g, follow the following steps

1. Oracle 11g should be installed on your machine.
    
2. Download 156998.zip from http://goo.gl/U7yJv 
3. Extract 156998.zip to some folder [i.e. c:\156998]
    
4. Go to Windows Command Line
• Start => Run
• Type cmd
   
5. From Command Line, goto to Oracle Home Directory
• cd $Oracle_Home/product/11.0.1.0/md/admin
   
6. connect as SYS user
• Assume that sys password is sys
• sqlplus sys/sys as sysdba
   
7. Execute the command that restores Oracle 10 RDF data.
• @c:\156998\catsem10i.sql;
   
8. Execute the command that installs 11 RDF, confirm with the snapshot given below to check if procedure has been executed successfully.
• @c:\156998\catsem11i.sql; 
   
9. Now, alter the “mdsys” user by the following command
• ALTER USER mdsys IDENTIFIED BY mdsys;
• ALTER USER mdsys ACCOUNT UNLOCK;
   
10. Connect via mdsys user
• conn mdsys/mdsys
   
11. Now, apply the patch to enable Semantic web Data support. Execute the following commands in the same sequence shown below
• @c:\156998\sdordfh.sql;
• @c:\156998\sdordfxh.sql;
• @c:\156998\sdordfa.sql;
• @c:\156998\sdordfb.plb;
• @c:\156998\sdordfxb.plb;
• @c:\156998\sdoseminfhb.plb;
• @c:\156998\sdordfai.plb;
   
12. connect as SYS user
• Assume that sys password is sys
• sqlplus sys/sys as sysdba
   

Configuring weblogic with postgresql Database

Follow these steps to connect Weblogic with Postgresql database:

1. Download postgresql setup from here
2. Download postgresql connection jar  file from here
3. install postgres database on your PC [during setup, you will enter database password]
4. create a database using postgres pgadmin interface [ex: database name: tdb]
5. put jar file some where on your pc [ex: C:\jars\postgresql-9.0-801.jdbc3.jar]
6. edit file setDomainEnv.cmd under integration directory inside weblogic home directory  [ex: C:\bea\weblogic81\samples\domains\integration]
7. add jar file path [C:\jars\postgresql-9.0-801.jdbc3.jar] at line 1999.
   [ex: set CLASSPATH=%ARDIR%\ant\ant.jar;%JAVA_HOME%\jre\lib\rt.jar;C:\jars\postgresql-9.0-801.jdbc3.jar]
8. open weblogic and start weblogic server
9. click on tools menu, then weblogic server=> data source viewer
10. click on New Data Source
11. fill data source form:
    data Source:postgres
    pool : postgresbool
    driver: select [org.postgresql.Driver]
    url: jdbc://postgresql://localhost:5432/tdb
    user: postgres
    password: password that you entered in postgres installation