Oracle

Oracle Database

XE

Ubuntu 64bit Installation

<source lang="bash"> axel -a http://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb axel -a http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/oracle-xe-universal_10.2.0.1-1.1_i386.deb sudo dpkg -i --force-architecture libaio_0.3.104-1_i386.deb sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb sudo /etc/init.d/oracle-xe configure </source lang="bash">

Add the following to your shell's rc (e.g. ~/.bashrc): <source lang="bash"> ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server PATH=\$PATH:\$ORACLE_HOME/bin export ORACLE_HOME export ORACLE_SID=XE export PATH </source lang="bash">

The host and port configuration can be found in the following files (if you want to bind the service to a different address/hostname):

• /etc/default/oracle-xe
• $ORACLE_HOME/network/admin/listener.ora
• $ORACLE_HOME/network/admin/tnsnames.ora

HowTos

System

• Oracle/Create tablespace
• Oracle/Drop all user tables

SQL

• Oracle/Drop if exists
• Oracle/Find duplicates
• Oracle/Merge
• Oracle/NLS
• Oracle/Select into table
• Oracle/Update join

Java

• Oracle/Java

External Links

• ORACLE-BASE
• SS64 Oracle
• TECH on the Net Oracle/PLSQL Topics
• java2s Oracle PL/SQL Tutorial
• ask Tom Oracle