...
| Panel |
|---|
[omegaman@rhel7-x64 ~]$ server stop
-----------------------------------------------------------------
Altibase Client Query utility.
Release Version 6.5.1.1.1
Copyright 2000, ALTIBASE Corporation or its subsidiaries.
All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost
Ok..Shutdown Proceeding.... |
(2) altibase.properties 의 DB Name 변경
...
| Panel |
|---|
/* $ALTIBASE_HOME/bin/server script */ ...................... 'create')
if [ $# = 3 ]; then
rm -f live-altibase.txt;
${ISQL} << EOF > /dev/null
spool live-altibase.txt;
EOF
if [ -f live-altibase.txt ]; then
echo " server is running !!!! \n "
echo " you must shutdown first before server create "
rm -f live-altibase.txt;
else
${ADMIN} << EOF
startup process;
create database sdb INITSIZE=10M noarchivelog character set $2 national character set $3; <---- 기본 DB명 mydb 를 변경하려는 DB명으로 수정합니다.
quit
EOF |
(4) 기존 데이타베이스 삭제
새로 Database를 생성하기 위해서는 기존 DB를 삭제해야 합니다. 기존 DB의 삭제는 $ALTIBASE_HOME/dbs/* 와 $ALTIBASE_HOME/logs/* 파일을 삭제하면 됩니다.
| Panel |
|---|
shell> cd $ALTIBASE_HOME shell> rm dbs/* shell> rm logs/* |
(5) 새로운 DB name으로 DB를 새로 생성
...
| Panel |
|---|
omegaman@rhel7-x64 altibase_home]$ server create MS949 UTF8
-----------------------------------------------------------------
Altibase Client Query utility.
Release Version 6.5.1.1.1
Copyright 2000, ALTIBASE Corporation or its subsidiaries.
All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost
[ERR-910FB : Connected to idle instance]
Connecting to the DB server.... Connected.
TRANSITION TO PHASE : PROCESS
Command executed successfully.
DB Info (Page Size = 32768)
(Page Count = 257)
(Total DB Size = 8421376)
(DB File Size = 1073741824) Creating MMDB FILES [SUCCESS] Creating Catalog Tables [SUCCESS] Creating DRDB FILES [SUCCESS] [SM] Rebuilding Indices [Total Count:0] [SUCCESS] DB Writing Completed. All Done. Create success. |
(6) DB 기동
server start 명령으로 DB를 start 합니다.
| Panel |
|---|
omegaman@rhel7-x64 altibase_home]$ server start
-----------------------------------------------------------------
Altibase Client Query utility.
Release Version 6.5.1.1.1
Copyright 2000, ALTIBASE Corporation or its subsidiaries.
All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost
[ERR-910FB : Connected to idle instance]
Connecting to the DB server.... Connected.
TRANSITION TO PHASE : PROCESS
TRANSITION TO PHASE : CONTROL
........ 중량 .....................................
[CM] Listener started : IPC
[RP] Initialization : [PASS] --- STARTUP Process SUCCESS --- |
(7) 변경된 Database명의 확인
DB 기동후에 다음의 쿼리로 변경된 DB명을 확인할 수 있습니다.
| Panel |
|---|
[omegaman@rhel7-x64 altibase_home]$ is
-----------------------------------------------------------------
Altibase Client Query utility.
Release Version 6.5.1.1.1
Copyright 2000, ALTIBASE Corporation or its subsidiaries.
All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = TCP, SERVER = localhost, PORT_NO = 20416 iSQL> select db_name from v$database;
DB_NAME
------------------------------------------------------------------------------------------------------------------------------------
sdb
1 row selected.
iSQL> |