OracleDB

Installation Oracle XE 11g

• Minimum: 2G Swap, Paket: bc muss existieren
• Als root: /etc/init.d/oracle-xe configure
• service oracle-xe start

User anlegen

#! /bin/bash
if [ "$2" = "" ] ; then
  echo "usage create_user <user> <password>"
else
  test -d "$ORACLE_HOME" || export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
  test -z "$ORACE_SID" || export ORACLE_SID=xe
  SCRIPT=/tmp/_create_user.inp
  test -f $SCRIPT && rm -rf $SCRIPT
  echo "CREATE USER $1 IDENTIFIED BY '$2';" >>$SCRIPT
  echo "GRANT CREATE SESSION TO $1;" >>$SCRIPT
  sqlplus "SYS/SYS AS SYSDBA" < $SCRIPT
fi