OracleDB: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| (4 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
[[Kategorie:ServerApplikation]] | [[Kategorie:ServerApplikation]] | ||
[[Kategorie:DB]] | |||
= Installation Oracle XE 11g = | = Installation Oracle XE 11g = | ||
* Minimum: 2G Swap, Paket: bc muss existieren | * Minimum: 2G Swap, Paket: bc muss existieren | ||
* Als root: /etc/init.d/oracle-xe configure | * Als root: /etc/init.d/oracle-xe configure | ||
* service oracle-xe start | * service oracle-xe start | ||
= Environment für Kommandos = | |||
<pre>ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe | |||
ORACLE_SID=xe | |||
ORA_BIN=/u01/app/oracle/product/11.2.0/xe/bin | |||
</pre> | |||
= User anlegen = | = User anlegen = | ||
<pre>#! /bin/bash | <pre>#! /bin/bash | ||
if [ "$ | if [ "$1" = "" ] ; then | ||
echo "usage create_user <user> <password>" | echo "usage create_user <user> [<password>]" | ||
else | else | ||
CODE=$2 | |||
test -z "$CODE" && CODE=$1 | |||
test -d "$ORACLE_HOME" || export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe | test -d "$ORACLE_HOME" || export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe | ||
test -z "$ORACE_SID" || export ORACLE_SID=xe | test -z "$ORACE_SID" || export ORACLE_SID=xe | ||
SCRIPT=/tmp/_create_user.inp | SCRIPT=/tmp/_create_user.inp | ||
test -f $SCRIPT && rm -rf $SCRIPT | test -f $SCRIPT && rm -rf $SCRIPT | ||
echo "CREATE USER $1 IDENTIFIED BY | echo "CREATE USER $1 IDENTIFIED BY "$CODE" QUOTA 50M ON SYSTEM;" >>$SCRIPT | ||
echo "GRANT CREATE SESSION TO $1;" >>$SCRIPT | echo "GRANT CREATE SESSION TO $1;" >>$SCRIPT | ||
sqlplus "SYS/SYS AS SYSDBA" < $SCRIPT | echo "GRANT CREATE table TO $1;" >>$SCRIPT | ||
echo "quit" >>$SCRIPT | |||
sqlplus "SYS/SYS@xe AS SYSDBA" < $SCRIPT | |||
rm -rf $SCRIPT | |||
fi | fi | ||
</pre> | |||
= 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 | |||
<pre>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 | |||
</pre> | |||
Aktuelle Version vom 16. Februar 2017, 09:32 Uhr
Installation Oracle XE 11g[Bearbeiten]
- Minimum: 2G Swap, Paket: bc muss existieren
- Als root: /etc/init.d/oracle-xe configure
- service oracle-xe start
Environment für Kommandos[Bearbeiten]
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[Bearbeiten]
#! /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[Bearbeiten]
- 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