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