Oracle Spatial and Graph 12c has Arrived
Jean Ihm posted on Google+ today that Oracle Spatial and Graph 12c is available. This post is an update to my post earlier this month How to Install Oracle Spatial and Graph (11g) on OEL 6.4. Bear in mind that the context of my blog is a home spatial learning lab written by a Java developer, not a DBA, so please take what I say with a grain of salt.
Oracle 12c Gotcha
The Oracle 12c installation has “Create as Container database” checked by default. Container databases and PDB (Pluggable Database) didn’t exist in 11g and are a real paradigm shift. Unless you mean to add that complexity to your installation, be sure to uncheck the box circled in red below on the fifth screen show.
Complete the Pre-install Steps for Oracle Spatial and Graph 12c
To start out I cloned an Oracle VirtualBox snapshot I took of OEL 6.4 (Oracle Enterprise Linux) just prior to installing Oracle 11g. I performed the prerequisite steps as documented my 11g install post:
- Define the hostname.
- Install the dependencies. I didn’t find a 12c pre-install RPM for OEL, so I used the 11g RPM: oracle-rdbms-server-11gR2-preinstall.
- Change the secure Linux policy in /etc/selinux/config to permissive.
Install Oracle Spatial and Graph 12c
Download the two Linux zip files from the Oracle Spatial and Graph 12c page.
As root, create the directory shown below, and unzip both files into that directory.
# mkdir /home/OraDB12c/ $ cp [your path]/linuxamd64_12c_database_1of2.zip /home/OraDB12c/ $ cp [your path]/linuxamd64_12c_database_2of2.zip /home/OraDB12c/ $ cd /home/OraDB12c/ $ unzip linuxamd64_12c_database_1of2.zip $ unzip linuxamd64_12c_database_2of2.zip
Add Permission for Oracle User to xhost
Next, to avoid a common display error during the Oracle 11g installation run the following command as root.
# xhost +SI:localuser:oracle localuser:oracle being added to access control list
Edit /home/oracle/.bash_profile with your preferred editor and add the following environment variables (substituting your host name and other installation preferences).
# Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=gps12c.localdomain ORACLE_UNQNAME=orcl ORACLE_BASE=/home/oracle/app/oracle ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0/dbhome_1 ORACLE_SID=orcl export ORACLE_SID ORACLE_HOME ORACLE_BASE ORACLE_UNQNAME ORACLE_HOSTNAME PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH LD_LIBRARY_PATH
Switch to the oracle user and change to the OraDB12c directory to run the install.
# su - oracle # cd /home/OraDB12c/database # ./runInstaller
Since mine is a home machine I accepted the default values on most screens. I’ve included all the screenshots below.
Leave the first-page blank unless you have an Oracle Support account.
This page is different from 11g. I skipped the software updates since I had none to install.
This option will launch the database configuration assistant after the software is installed.
A desktop class is sufficient for a home spatial learning lab.
Be sure to deselect “Create as Container database” unless you need to manage PDB (Pluggable Databases). If you leave this op
Take the default inventory directory.
With the three pre-install steps noted above, my system passed all the prerequisite checks and skipped directly to the summary page.
Run the two scripts shown as root.
Go have a cup of coffee. The database configuration takes awhile. When it’s complete the following window will appear.
Test the Oracle Installation
Try connecting to the database while still signed in as the user oracle using the commands shown below. Run the test query shown to pull back the database SID.
$ sqlplus / as sysdba SQL*Plus: Release 220.127.116.11.0 Production on Tue Jun 25 22:01:38 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select instance_name from v$instance; INSTANCE_NAME ---------------- orcl SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
That is good enough for tonight. In my future posts, I’ll be using 12c instead of 11g, despite the fact that it will probably be a long while before we upgrade at work. I want access to the latest spatial features as I am learning.