OracleDB: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „Kategorie:ServerApplikation = Installation Oracle XE 11g = * Minimum: 2G Swap, Paket: bc muss existieren * Als root: /etc/init.d/oracle-xe configure * serv…“) |
|||
| Zeile 4: | Zeile 4: | ||
* Als root: /etc/init.d/oracle-xe configure | * Als root: /etc/init.d/oracle-xe configure | ||
* service oracle-xe start | * service oracle-xe start | ||
= User anlegen = | |||
<pre>#! /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 | |||
Version vom 13. Februar 2017, 23:44 Uhr
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