그냥

CentOS
Release 6.5
Kernel Linux 2.6.32
GNOME 2.28.2



ps -ef | grep "gmaster" | grep $LOGNAME | kill -9 `awk '{print $2}'` 2> /dev/null
ps -ef | grep "gserver" | grep $LOGNAME | kill -9 `awk '{print $2}'` 2> /dev/null
ps -ef | grep "gdispatcher" | grep $LOGNAME | kill -9 `awk '{print $2}'` 2> /dev/null
ps -ef | grep "gbalancer" | grep $LOGNAME | kill -9 `awk '{print $2}'` 2> /dev/null
ps -ef | grep "glsnr" | grep $LOGNAME | kill -9 `awk '{print $2}'` 2> /dev/null
ipcs -m | grep $LOGNAME | awk '{print "ipcrm -m " $2}' | sh -v 2> /dev/null

rm ${SUNDB_DATA}/db/*.dbf ${SUNDB_DATA}/wal/*.ctl ${SUNDB_DATA}/wal/*.log ${SUNDB_DATA}/archive_log/*.log ${SUNDB_DATA}/backup/*.inc ${SUNDB_DATA}/trc/opt_* 2> /dev/null

rm ${SUNDB_DATA}/conf/sundb.properties.binary 2> /dev/null
gcreatedb --db_name="TEST_DB"

GSQL="gsql --as sysdba --no-prompt"
${GSQL} << EOF
\startup

--# for regression test
GRANT ALL PRIVILEGES ON DATABASE TO TEST WITH GRANT OPTION;
COMMIT;
EOF
gsql --as sysdba --silent --import $SUNDB_HOME/admin/DictionarySchema.sql
gsql --as sysdba --silent --import $SUNDB_HOME/admin/InformationSchema.sql
gsql --as sysdba --silent --import $SUNDB_HOME/admin/PerformanceViewSchema.sql



CREATE TABLESPACE META_DATA DATAFILE '/home/sundb/sundb_data/db/META_DATA.DBF' SIZE 5978M;

CREATE TEMPORARY TABLESPACE META_IDX MEMORY 'META_IDX' SIZE 5978M;

ALTER TABLESPACE MEM_TEMP_TBS ADD MEMORY 'META_TEMP.DBF' SIZE 2G;

ALTER TABLESPACE MEM_UNDO_TBS ADD DATAFILE 'META_UNDO.DBF' SIZE 2G;

CREATE USER meta3 IDENTIFIED BY meta3 DEFAULT TABLESPACE META_DATA TEMPORARY TABLESPACE MEM_TEMP_TBS;

GRANT CREATE SESSION ON DATABASE TO META3;
GRANT CREATE TABLE, CREATE VIEW, CREATE INDEX, CREATE SEQUENCE, ADD CONSTRAINT ON SCHEMA META3 TO META3;
GRANT SELECT TABLE ON SCHEMA META3 TO META3;
GRANT INSERT TABLE ON SCHEMA META3 TO META3;
GRANT UPDATE TABLE ON SCHEMA META3 TO META3;
GRANT DELETE TABLE ON SCHEMA META3 TO META3;

GRANT CREATE OBJECT ON TABLESPACE mem_data_tbs TO META3;
GRANT CREATE OBJECT ON TABLESPACE mem_data_tbs TO META3;
GRANT CREATE OBJECT ON TABLESPACE meta_idx TO META3;
GRANT CREATE OBJECT ON TABLESPACE mem_temp_tbs TO META3;