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
SQL
- Oracle/Drop if exists
- Oracle/Find duplicates
- Oracle/Merge
- Oracle/NLS
- Oracle/Select into table
- Oracle/Update join
Java
External Links
- ORACLE-BASE
- SS64 Oracle
- TECH on the Net Oracle/PLSQL Topics
- java2s Oracle PL/SQL Tutorial
- ask Tom Oracle