Oracle semantic capability requires three technologies:
- Oracle Enterprise Edition
- Spatial Option
- Partitioning
Oracle Database Software Downloads
You can download Oracle Database 11 g Release 2 from here. Before you proceed, you need to determine which one to download from based on your platform. For example, I'll download "Linux x86-64" because I'm using a Linux system with 64 bit. To check out which Linux version of your system is, type the following command:>uname -mrsnThere are two zip files. Make sure to download and unzip both files to the same directory.
Linux aec6465414 2.6.18-164.0.0.0.1.el5xen x86_64
Installing Oracle Database
Some important notes before we begin:- Do not install Oracle Database 11g Release 2 (11.2) software into an existing Oracle home.
- You may need to shut down existing Oracle processes before you start the database installation. Refer to "Stopping Existing Oracle Processes" for more information.
- Take notes of any locations (i.e., "Oracle base", "Software location", etc.) or information (i.e., OSDBA Group, SID, etc) reported in the installation steps. You may need them later for debugging. Or, if you choose to save response file at the end of installation, all these information will be recorded in it (i.e., /scratch/oradba/db.rsp; you need to login as oradba to view it)
- Choose Enterprise Edition option in the installation.
- You may want to have MDSYS account unlocked in the installation.
My system is Linux. So, I'm following this installation guide. In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install Oracle Database. The instructions in this section explain how to run the Oracle Universal Installer GUI:
- Check preinstallation requirements
- Change directory to the directory where you have downloaded zip files (i.e., /scratch/xxx/oracle11)
- Unzip both files
cd /scratch/xxx/oracle11/database
- Run Oracle Universal Installer
- ./runInstaller
- At the "Prerequisite Checks" step, you may see some checks with failed status. Some of these are fixable. Click "Fix & Check Again" button to get the instructions. For example, I have to do these steps:
- Login as "root"
- cd /tmp/CVU_11.2.0.1.0_oradba
- ./runfixup.sh
- After the fixes, I do have one remaining issue related to swap space. However, I simply ignore it and the installation still finish without issue. If not, you need to increase your swap space.
- Save Response File (i.e.,
/scratch/oradba/db.rsp
)- This file holds all the information your have chosen for the installation.
- This file holds all the information your have chosen for the installation.
- Execute Root Scripts to setup environment
cd /scratch/oradba/app/oraInventory/
./orainstRoot.sh
Verifying the Installation
There are two options to be verified:- Spatial option
- Partitioning option
The RDF and OWL support are features of Oracle Spatial, which must be installed for these features to be used. However, the use of RDF and OWL is not restricted to spatial data.
To be able to do a successful Spatial 11g installation you need to have the following products already installed:
* JServer JAVA Virtual Machine
* Oracle interMedia
* Oracle XML Database
To verify if the products are installed and valid run:
SQL> select comp_id,version,status from dba_registry
where comp_id in ('JAVAVM','ORDIM','XDB');
The result should be similar to this:
COMP_ID VERSION STATUS
-------------------- ------------------------ -----------------
XDB 11.2.0.2.0 VALID
ORDIM 11.2.0.2.0 VALID
JAVAVM 11.2.0.2.0 VALID
After verifying the dependent products of Spatial are installed correctly, you can execute the following steps to verify if Spatial is installed correctly:
SQL> connect / as sysdba
SQL> set serveroutput on
SQL> execute validate_sdo;
SQL> select comp_id, control, schema, version, status, comp_name from dba_registry where comp_id='SDO';
SQL> select object_name, object_type, status from dba_objects where owner='MDSYS' and status <> 'VALID' order by object_name;
For example,
select object_name, object_type, status from dba_objects where owner='MDSYS' and status <> 'VALID' order by object_name;
Should return 0 entries and
select comp_id, control, schema, version, status, comp_name from dba_registry where comp_id='SDO';
Should return:
COMP_ID | CONTROL | SCHEMA | VERSION | STATUS | COMP_NAME |
---|---|---|---|---|---|
SDO | SYS | MDSYS | 11.2.0.2.0 | VALID | Spatial |
Verification of Oracle Partitioning Option
Partitioning comes with EE (enterprise edition) as an option on top of enterprise edition, not with SE (standard edition) or XE (express edition). To see if your Oracle has Partitioning, do:
select * from v$option;
PARAMETER VALUE
---------------------------------------------------------------- -------------------------------
Partitioning TRUE
Read More
If you want to start using semantic technology to store, manage, and query semantic data in the database, read Oracle Database Semantic Technologies Developer's Guide.This guide provides complete usage and reference information about Oracle Database Enterprise Edition support for semantic technologies, including storage, inference, and query capabilities for data and ontologies based on Resource Description Framework (RDF), RDF Schema (RDFS), and Web Ontology Language (OWL).
If you need extra adapters or plugin's, look here.
No comments:
Post a Comment