OracleDB

Installation Oracle XE 11g

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

Environment für Kommandos

ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
ORACLE_SID=xe
ORA_BIN=/u01/app/oracle/product/11.2.0/xe/bin

User anlegen

#! /bin/bash
if [ "$1" = "" ] ; then
  echo "usage create_user <user> [<password>]"
else
  CODE=$2
  test -z "$CODE" && CODE=$1
  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 "$CODE" QUOTA 50M ON SYSTEM;" >>$SCRIPT
  echo "GRANT CREATE SESSION TO $1;" >>$SCRIPT
  echo "GRANT CREATE table TO $1;" >>$SCRIPT
  echo "quit" >>$SCRIPT
  sqlplus "SYS/SYS@xe AS SYSDBA" < $SCRIPT
  rm -rf $SCRIPT
fi

QT-Plugin für Oracle

• instantclient-basiclite-linux.x64-11.2.0.4.0.zip
• instantclient-sdk-linux.x64-11.2.0.4.0.zip
• entpackt nach /opt/oracle_client/instantclient_11_2

cd /opt/Qt-mint/5.6/Src/qtbase/src/plugins/sqldrivers/oci
OCI_BASE=/opt/oracle_client/instantclient_11_2
OCI_INC_HOME=OCI_BASE/sdk/include
OCI_LIB_HOME=$OCI_BASE
qmake "INCLUDEPATH+=$OCI_INC_HOME/" "LIBS+=-L$OCI_LIB_HOME -lclntsh" oci.pro
make
cd /opt/Qt-mint/5.6/Src/qtbase/plugins/sqldrivers
cp libqsqloci.so /opt/Qt-mint/5.6/gcc_64/plugins/sqldrivers