Install Oracle11G semantic network patch in Linux

Note: You should download OracleDatabase11gRelease1

Note: You should download Oracle Database 11g Release 1-Patch Set for 11.1.0.6 my system environment: linux (ubuntu 8.04) + oracle

To enable Oracle 11g release 1 to support full DL reasoning, install oracle Jena Adaptor patch for Oracle 11g.

Official installation documentation:
Patch:
Note: You should download the Oracle Database 11g Release 1-Patch Set for 11.1.0.6

My system environment: linux (Ubuntu 8.04) + oracle 11g release 1

The following describes how to install the Oracle Jena Adaptor semantic web patch:
----------------------------------------------------------

0. Start the database:
Wuxi @ ubuntu :~ $ Sqlplus/as sysdba
SQL> startup
...
SQL> quit

1. Confirm the values of your installation parameters: $ ORACLE_HOME and $ ORACLE_SID.
Wuxi @ ubuntu :~ $ Echo $ ORACLE_HOME
/U01/app/oracle/product/11.1.0/db_1
Wuxi @ ubuntu :~ $ Echo $ ORACLE_SID
Mydb

2. Run the catsem11i. SQL script:
Cd $ ORACLE_HOME/md/admin
Wuxi @ ubuntu: admin $ sqlplus/as sysdba
SQL * Plus: Release 11.1.0.6.0-Production on Wed Oct 31 07:57:19 2007
SQL> @ catsem11i. SQL
... Omitted...
Session altered.
Call completed.
Install 11 RDF... DONE

SQL> quit

3. decompress the installation package:
Wuxi @ ubuntu: admin $ mkdir/tmp/work
Wuxi @ ubuntu: admin $ cd/tmp/work
Wuxi @ ubuntu: work $ unzip jenadrv_patch111rdf.zip
Archive: jenadrv_patch111rdf.zip
Creating: java/
Inflating: java/sdordf. jar
Creating: SQL/
Inflating: SQL/sdoseminfhb. plb
Inflating: SQL/sdordfxb. plb
Inflating: SQL/sdordfxh. SQL
Inflating: SQL/sdordfai. plb
Inflating: SQL/sdordfa. SQL
Inflating: SQL/sdordfh. SQL
Inflating: SQL/sdordfb. plb

4. update database schema: first, unlock the MDSYS user. We strongly recommend that you use a secure password. However, during the following installation process ,, currently, you can use mdsys as the password (the password is red below). After installation, you can change the password to your own safe password using the following method.

Go to the SQL directory in the extracted directory:

Wuxi @ ubuntu: work $ cd/tmp/work/SQL
/Tmp/work/SQL
Wuxi @ ubuntu: SQL $ sqlplus/as sysdba
SQL * Plus: Release 11.1.0.6.0-Production on Wed Oct 31 07:59:08 2007
Copyright (c) 1982,200 7, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Unlock the MDSYS User:

SQL> alter user mdsys account unlock identified by mdsys;
User altered.

Use the MDSYS user to log on and execute the script:

SQL> conn mdsys/mdsys
Connected.

SQL> @ sdordfh. SQL
SQL> @ sdordfxh. SQL
SQL> @ sdordfa. SQL
SQL> @ sdordfb. plb
SQL> @ sdordfxb. plb
SQL> @ sdoseminfhb. plb
SQL> @ sdordfai. plb
Package created.
...
SQL>
Package body created.
No errors.

5. Update the jar file:

Wuxi @ ubuntu: SQL $ cd ..
Wuxi @ ubuntu: SQL $ pwd
/Tmp/work
Wuxi @ ubuntu: work $ ORACLE_HOME/bin/loadjava-u MDSYS/mdsys-resolve-force-synonym-schema MDSYS-grant PUBLIC java/sdordf. jar

6. test whether the installation is successful:
Use a user with the permission to create a tablespace to log on to ORACLE 11 GB, for example, sysman

Wuxi @ ubuntu: work $ sqlplus sysman/your_password
SQL * Plus: Release 11.1.0.6.0-Production on Wed Jul 9 10:48:57 2008

Copyright (c) 1982,200 7, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Create a tablespace:

Create tablespace sem_family
DATAFILE '/u01/app/oracle/oradata/mydb/sem_family.dbf' SIZE 100 M
Autoextend on next 32 m maxsize 512 M
EXTENT MANAGEMENT LOCAL
Segment space management auto;

Create a semantic web table:

EXECUTE sem_apis.create_sem_network ('sem _ family ');

If both operations are successful, your semantic web patch has been installed successfully :)