Oracle 유저 및 Schema 생성 쉘스크립트

현재 학부 서버에 설치된 oracle 용 유저 생성 쉘스크립트입니다.

#!/bin/bash
# Usage : ./addoracle id password
# 2007/03/19 작성

dateis=$(date +%Y/%m/%d)
timeis=$(date | awk '{print $4}')

# 아규먼트를 체크한다
if [ $# = 0 ]
then
echo "Usage: ./addoracle.sh id pass"
exit 1
fi

# Oracle 에 새로운 TableSpace 를 추가한다
echo -n "ORACLE TableSpace Create? - [y/n](default n) : "
read db
if [ "$db" = "y" ] || [ "$db" = "Y" ]; then
echo -n "ORACLE system password: "
read pass
touch /tmp/oracle_dbusersetup_temp
echo "CREATE TABLESPACE $1 datafile '/data/oracle/orcl/$1.dbf' size 10M;" >> /tmp/oracle_dbusersetup_temp
echo "CREATE USER $1 identified by $2 DEFAULT TABLESPACE $1;" >> /tmp/oracle_dbusersetup_temp
echo "GRANT CONNECT, RESOURCE TO $1;" >> /tmp/oracle_dbusersetup_temp
/oracle/product/10.2.0/db_1/bin/sqlplus system/$pass@orcl < /tmp/oracle_dbusersetup_temp
rm -f /tmp/oracle_dbusersetup_temp
fi