UJP - 技術情報

Life is fun and easy!
不正IP報告数

Okan Sensor
Home Information Service Tech(Free) Tech(Member) Blog FAQ
 
メイン
ログイン

ユーザー名:


パスワード:





パスワード再発行手続き  |無料会員入会手続へ...
ブログ　カテゴリ一覧
     

Database Configuration Assistantを使ってDBを作る on RedHat

Database Configuration Assistantを使ってDBを作る

０．改訂履歴

  • 2002.09.20　新規作成

１．はじめに

　このドキュメントでは，Oracle8i 8.1.7に付属するDatabase Configuration Assistantを使って，データベースを作成する手順を説明する．

２．環境を確認する

  • Oracleのプロセスが存在するか確認する． 
[oracle@testsvr oracle]$ ps -ef | grep ora_
[oracle@testsvr oracle]$
  • リスナーが起動しているか確認する． 
[oracle@testsvr oracle]$ ps -ef | grep tns 
oracle   29877     1  0 19:48 ?        00:00:00 /opt/oracle/OraHome1/bin/tnslsnr
[oracle@testsvr oracle]$
  • ORACLE_HOMEを設定し，データベースアシスタントを確認する． 
[oracle@testsvr oracle]$ export ORACLE_HOME=/opt/oracle/OraHome1
[oracle@testsvr oracle]$ cd $ORACLE_HOME/bin
[oracle@testsvr bin]$ ls -la dbas*
-rwxr-xr-x    1 oracle   oinstall     3001 Sep 17 19:44 dbassist
[oracle@testsvr bin]$

３．Database Configuration Assistantの実行

  • Database Configuration Assistantを実行する． 
[oracle@testsvr bin]$ ./dbassist &
[1] 29910
[oracle@testsvr bin]$
  • 次のような画面が表示される．

  • 今回はカスタムで作成する．

  • 汎用利用向け（Multipurpose）を選択する．

  • 専用サーバ(Dedicated Server Mode)を選択する．

  • オプションを選択する．

  • 使わない物を削除する

  • インスタンス名を入力する．
  • また，データベースのキャラクタセットを選択する．

  • 今回はSJISを選択した．

  • maximum Log Membersを３にする．

  • デフォルトのまま．

  • テンポラリ領域の容量を増やす．

  • REDOログ領域のサイズを増やす．

  • アーカイブログモードとする．

  • ブロックサイズは変更できないので気にしておく．

  • スクリプトを保存しておく．

  • 保存する場所を指定する．

  • 保存する場所を覚えておく．

  • 終了．

４．手動でスクリプトを実行する

  • dbcaで作成したスクリプトが保存されている場所を参照し，ファイルを確認する． 
[oracle@testsvr bin]$ cd $ORACLE_HOME/assistants/dbca
[oracle@testsvr dbca]$ ls -la
total 56
drwxr-xr-x    6 oracle   oinstall     4096 Sep 18 21:17 .
drwxr-xr-x    5 oracle   oinstall     4096 Sep 17 17:34 ..
drwxr-xr-x    3 oracle   oinstall     4096 Sep 17 17:33 doc
drwxr-xr-x    3 oracle   oinstall     4096 Sep 17 17:33 images
drwxr-xr-x    2 oracle   oinstall     4096 Sep 17 19:44 install
drwxr-xr-x    2 oracle   oinstall     4096 Sep 17 17:33 jlib
-rw-r--r--    1 oracle   oinstall      458 Sep 18 21:17 test
-rwxr-xr-x    1 oracle   oinstall      203 Sep 18 21:17 testalterTablespace.sh
-rwxr-xr-x    1 oracle   oinstall      286 Sep 18 21:17 testarchive.sh
-rwxr-xr-x    1 oracle   oinstall     1623 Sep 18 21:17 testjava.sh
-rwxr-xr-x    1 oracle   oinstall     2824 Sep 18 21:17 testrun1.sh
-rwxr-xr-x    1 oracle   oinstall      396 Sep 18 21:17 testrun2.sh
-rwxr-xr-x    1 oracle   oinstall      698 Sep 18 21:17 testrun.sh
-rwxr-xr-x    1 oracle   oinstall      165 Sep 18 21:17 testsqlplus.sh
[oracle@testsvr dbca]$
  • testの内容を確認してみる． 
[oracle@testsvr dbca]$ cat test
#!/bin/sh
ORACLE_SID=test
export ORACLE_SID


ORACLE_HOME=/opt/oracle/OraHome1
export ORACLE_HOME

/opt/oracle/OraHome1/assistants/dbca/testrun.sh
/opt/oracle/OraHome1/assistants/dbca/testrun1.sh
/opt/oracle/OraHome1/assistants/dbca/testrun2.sh
/opt/oracle/OraHome1/assistants/dbca/testjava.sh
/opt/oracle/OraHome1/assistants/dbca/testsqlplus.sh
/opt/oracle/OraHome1/assistants/dbca/testarchive.sh
/opt/oracle/OraHome1/assistants/dbca/testalterTablespace.sh
[oracle@testsvr dbca]$
  • testを実行する． 
[oracle@testsvr dbca]$ . ./test

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SVRMGR> SVRMGR> Connected.
SVRMGR> ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR>      2>      3>      4>      5>      6>      7>      8>      9>     10> CREATE DATABASE "test"
*
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/opt/oracle/OraHome1/oradata/test/control01.ctl'
ORA-27038: skgfrcre: file exists
SVRMGR> Disconnected.
  • いっぱいエラーがでた．
  • already-runningなので，シャットダウンする． 
[oracle@testsvr dbca]$ $ORACLE_HOME/bin/svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> shutdown
ORA-01507: database not mounted
ORACLE instance shut down.
SVRMGR>
  • 正しくシャットダウンされた．
  • 次に，空のインスタンスを起動し，シャットダウンを試す． 
SVRMGR> startup nomount pfile="/opt/oracle/OraHome1/admin/test/pfile/inittest.ora"
ORACLE instance started.
Total System Global Area                         94085280 bytes
Fixed Size                                          73888 bytes
Variable Size                                    77062144 bytes
Database Buffers                                 16777216 bytes
Redo Buffers                                       172032 bytes
SVRMGR> shutdown;
ORA-01507: database not mounted
ORACLE instance shut down.
SVRMGR> quit
Server Manager complete.
[oracle@testsvr dbca]$
  • 正しく動作した．
  • testの内容を確認してみる． 
[oracle@testsvr dbca]$ cat test
#!/bin/sh
ORACLE_SID=test
export ORACLE_SID


ORACLE_HOME=/opt/oracle/OraHome1
export ORACLE_HOME

/opt/oracle/OraHome1/assistants/dbca/testrun.sh
/opt/oracle/OraHome1/assistants/dbca/testrun1.sh
/opt/oracle/OraHome1/assistants/dbca/testrun2.sh
/opt/oracle/OraHome1/assistants/dbca/testjava.sh
/opt/oracle/OraHome1/assistants/dbca/testsqlplus.sh
/opt/oracle/OraHome1/assistants/dbca/testarchive.sh
/opt/oracle/OraHome1/assistants/dbca/testalterTablespace.sh
[oracle@testsvr dbca]$
  • 最初に実行されるtestrun.shのの中身を見てみる． 
[oracle@testsvr dbca]$ cat testrun.sh
#!/bin/sh
ORACLE_SID=test
export ORACLE_SID

/opt/oracle/OraHome1/bin/svrmgrl << EOF
spool /opt/oracle/OraHome1/admin/test/create/crdb1.log
connect internal
startup nomount pfile = "/opt/oracle/OraHome1/admin/test/pfile/inittest.ora"
CREATE DATABASE "test"
   maxdatafiles 254
   maxinstances 8
   maxlogfiles 32
   character set JA16SJIS
   national character set JA16SJIS
DATAFILE '/opt/oracle/OraHome1/oradata/test/system01.dbf' SIZE 260M AUTOEXTEND ON NEXT 10240K
logfile '/opt/oracle/OraHome1/oradata/test/redo01.log' SIZE 50000K, 
    '/opt/oracle/OraHome1/oradata/test/redo02.log' SIZE 50000K, 
    '/opt/oracle/OraHome1/oradata/test/redo03.log' SIZE 50000K;
disconnect
spool off
exit


EOF
[oracle@testsvr dbca]$
  • create databaseを実行している．
  • これを手動で実行してみる．
  • まず，インスタンスを起動する． 
[oracle@testsvr dbca]$ $ORACLE_HOME/bin/svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> shutdown
ORA-01507: database not mounted
ORACLE instance shut down.
SVRMGR> startup nomount pfile = "/opt/oracle/OraHome1/admin/test/pfile/inittest.ora"
ORACLE instance started.
Total System Global Area                         94085280 bytes
Fixed Size                                          73888 bytes
Variable Size                                    77062144 bytes
Database Buffers                                 16777216 bytes
Redo Buffers                                       172032 bytes
SVRMGR>
  • データベースを作成する． 
SVRMGR> CREATE DATABASE "test"
     2> maxdatafiles 254
     3> maxinstances 8
     4> maxlogfiles 32
     5> character set JA16SJIS
     6> national character set JA16SJIS
     7> DATAFILE
     8> '/opt/oracle/OraHome1/oradata/test/system01.dbf' SIZE 260M AUTOEXTEND ON NEXT 10240K
     9> logfile
    10> '/opt/oracle/OraHome1/oradata/test/redo01.log' SIZE 50000K,
    11> '/opt/oracle/OraHome1/oradata/test/redo02.log' SIZE 50000K,
    12> '/opt/oracle/OraHome1/oradata/test/redo03.log' SIZE 50000K
    13> ;
CREATE DATABASE "test"
*
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/opt/oracle/OraHome1/oradata/test/control01.ctl'
ORA-27038: skgfrcre: file exists
SVRMGR>
  • 既にコントロールファイルがあるので新規作成できないといわれた．
  • ファイルリストを確認する． 
SVRMGR> !ls -la /opt/oracle/OraHome1/oradata/test/

total 429720
drwxr-xr-x    2 oracle   oinstall     4096 Sep 19 11:34 .
drwxr-xr-x    3 oracle   oinstall     4096 Sep 18 21:17 ..
-rw-r-----    1 oracle   oinstall  4431872 Sep 19 11:42 control01.ctl
-rw-r-----    1 oracle   oinstall  4431872 Sep 19 11:42 control02.ctl
-rw-r-----    1 oracle   oinstall  4431872 Sep 19 11:42 control03.ctl
-rw-r-----    1 oracle   oinstall 51200512 Sep 19 11:34 redo01.log
-rw-r-----    1 oracle   oinstall 51200512 Sep 19 11:34 redo02.log
-rw-r-----    1 oracle   oinstall 51200512 Sep 19 11:34 redo03.log
-rw-r-----    1 oracle   oinstall 272637952 Sep 19 11:34 system01.dbf
SVRMGR> SVRMGR>
  • 前回失敗した時のファイルが残っている模様．
  • 消す． 
SVRMGR> SVRMGR> !rm -f /opt/oracle/OraHome1/oradata/test/*
SVRMGR> !ls -la /opt/oracle/OraHome1/oradata/test/
total 8
drwxr-xr-x    2 oracle   oinstall     4096 Sep 19 11:48 .
drwxr-xr-x    3 oracle   oinstall     4096 Sep 18 21:17 ..
SVRMGR>
  • 再度create databaseを実行する． 
SVRMGR> CREATE DATABASE "test"
     2> maxdatafiles 254
     3> maxinstances 8
     4> maxlogfiles 32
     5> character set JA16SJIS
     6> national character set JA16SJIS
     7> DATAFILE
     8> '/opt/oracle/OraHome1/oradata/test/system01.dbf' SIZE 260M AUTOEXTEND ON NEXT 10240K
     9> logfile
    10> '/opt/oracle/OraHome1/oradata/test/redo01.log' SIZE 50000K,
    11> '/opt/oracle/OraHome1/oradata/test/redo02.log' SIZE 50000K,
    12> '/opt/oracle/OraHome1/oradata/test/redo03.log' SIZE 50000K
    13> ;
Statement processed.
SVRMGR>
  • 作られたみたい．
  • プロセスをみてみる． 
SVRMGR> select spid,name from v$process,v$bgprocess where paddr = addr;
SPID      NAME 
--------- -----
7022      PMON 
7024      DBW0 
7026      LGWR 
7028      CKPT 
7030      SMON 
7032      RECO 
7038      ARC0 
7 rows selected.
SVRMGR>
  • 動いてます． 
SVRMGR> quit
Server Manager complete.
[oracle@testsvr dbca]$
  • ファイルを確認する．
  • testの中身を見てみる． 
[oracle@testsvr dbca]$ cat test
#!/bin/sh
ORACLE_SID=test
export ORACLE_SID


ORACLE_HOME=/opt/oracle/OraHome1
export ORACLE_HOME

/opt/oracle/OraHome1/assistants/dbca/testrun.sh
/opt/oracle/OraHome1/assistants/dbca/testrun1.sh
/opt/oracle/OraHome1/assistants/dbca/testrun2.sh
/opt/oracle/OraHome1/assistants/dbca/testjava.sh
/opt/oracle/OraHome1/assistants/dbca/testsqlplus.sh
/opt/oracle/OraHome1/assistants/dbca/testarchive.sh
/opt/oracle/OraHome1/assistants/dbca/testalterTablespace.sh
[oracle@testsvr dbca]$
  • 手動で，testrun.shを実行した状態と同じなので，次にtesturun1.shを実行する． 
[oracle@testsvr dbca]$ /opt/oracle/OraHome1/assistants/dbca/testrun1.sh

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SVRMGR> SVRMGR> Connected.
SVRMGR> Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.

〜略〜

SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> SVRMGR> SVRMGR> SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> Disconnected.
SVRMGR> SVRMGR> Server Manager complete.
[oracle@testsvr dbca]$
  • testrun2.shを実行する． 
[oracle@testsvr dbca]$ /opt/oracle/OraHome1/assistants/dbca/testrun2.sh

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SVRMGR> SVRMGR> Connected.
SVRMGR> Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.

〜略〜

ORA-01432: public synonym to be dropped does not exist
Statement processed.
drop synonym product_user_profile
             *
ORA-01434: private synonym to be dropped does not exist
Statement processed.
drop public synonym product_user_profile
                    *
ORA-01432: public synonym to be dropped does not exist
Statement processed.
SVRMGR> SVRMGR> Disconnected.
SVRMGR> SVRMGR> Server Manager complete.
[oracle@testsvr dbca]$
  • testjava.shを実行する． 
[oracle@testsvr dbca]$ /opt/oracle/OraHome1/assistants/dbca/testjava.sh

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SVRMGR> SVRMGR> Connected.
SVRMGR> Statement processed.
Statement processed.
Statement processed.
Statement processed.
Statement processed.

〜略〜

synonym  : oracle/ODCI/ODCIPredInfo
synonym  : oracle/ODCI/ODCIPredInfoRef
synonym  : oracle/ODCI/ODCIQueryInfo$_Ctx
synonym  : oracle/ODCI/ODCIQueryInfo
synonym  : oracle/ODCI/ODCIQueryInfoRef
synonym  : oracle/ODCI/ODCIRidList
synonym  : oracle/ODCI/ODCIStatsOptions$_Ctx
synonym  : oracle/ODCI/ODCIStatsOptions
synonym  : oracle/ODCI/ODCIStatsOptionsRef
SVRMGR> SVRMGR> Server Manager complete.
[oracle@testsvr dbca]$
  • testsqlplus.shを実行する． 
[oracle@testsvr dbca]$ /opt/oracle/OraHome1/assistants/dbca/testsqlplus.sh

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 20 11:35:46 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Enter user-name: 
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SQL> DROP TABLE HELP
           *
ERROR at line 1:
ORA-00942: table or view does not exist



Table created.


〜略〜
57 rows created.


Commit complete.


View dropped.

Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production
[oracle@testsvr dbca]$
  • testarchive.shを実行する． 
[oracle@testsvr dbca]$ /opt/oracle/OraHome1/assistants/dbca/testarchive.sh

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SVRMGR> Connected.
SVRMGR> Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> ORACLE instance started.
Total System Global Area                         94085280 bytes
Fixed Size                                          73888 bytes
Variable Size                                    77062144 bytes
Database Buffers                                 16777216 bytes
Redo Buffers                                       172032 bytes
Database mounted.
SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> SVRMGR> 
Server Manager complete.
[oracle@testsvr dbca]$
  • testalterTablespace.shを実行する． 
[oracle@testsvr dbca]$ /opt/oracle/OraHome1/assistants/dbca/testalterTablespace.sh

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SVRMGR> Connected.
SVRMGR> Statement processed.
SVRMGR> Statement processed.
SVRMGR> SVRMGR> 
Server Manager complete.
[oracle@testsvr dbca]$
  • ここまでで一通りデータベースが作成された．
  • あとは，データ領域の拡張や，ユーザアカウントを作成する．

サイトからのおしらせ

広告スペース
Google