Ocm Determine And Set Sizing Parameters For Database Structures Jp

初期化パラメータファイルの作成

# テンプレートinit.oraを処理し、#と空白行を削除する方法ならかなり楽
[oracle@fy ~]$ cd $ORACLE_BASE/admin/$ORACLE_SID/pfile
[oracle@fy pfile]$ vi init.ora
db_block_size = 4096
db_name = prod
sga_target = 300M
log_buffer = 2048000
control_files = (/u01/oracle/app/oradata/prod/control01.ctl, /u01/oracle/app/oradata/prod/oradata/control02.ctl)
 
# デフォルト場所で作成
[oracle@fy pfile]$ pwd
/u01/oracle/oracle/admin/pfile
[oracle@fy dbs]$ vi init$ORACLE_SID.ora
ifile=/u01/oracle/oracle/admin/pfile/init.ora

See Also:
OFA

インスタンス起動して、初期化パラメータを確認しサーバ初期化パラメータファイルを作成する

[oracle@fy fy]$ sqlplus / as sysdba
 
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 1 11:57:20 2009
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup nomount;
ORACLE instance started.
 
Total System Global Area  314572800 bytes
Fixed Size                  2020448 bytes
Variable Size             134220704 bytes
Database Buffers          176160768 bytes
Redo Buffers                2170880 bytes
 
SQL> create spfile from pfile;
 
File created.
 
SQL> alter system set undo_management=auto scope=spfile;
 
System altered.
 
SQL> alter system set undo_tablespace=undotbs scope=spfile;
 
System altered.
 
SQL> create pfile from spfile;
 
File created.
 
SQL> shutdown immediate;
 
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@fy fy]$ cd $ORACLE_HOME/dbs
 
[oracle@fy dbs]$ cat initprod.ora
*.control_files='/u01/oracle/oracle/oradata/prod/control01.ora','/u01/oracle/oracle/oradata/prod/control02.ora'
*.db_block_size=4096
*.db_name='prod'
*.log_buffer=2048000
*.sga_target=300m