Create a database (oracle 10G)

1	运行dbca	cd /xxxx/   . ./dbca
2	界面1：welcome	点击“next”
3	界面2：operations	选择“create a database”,点击“next”
4	界面3：database template	选择“custom database”,点击“next”
5	界面4：database identication	global database name = mydemo.world sid = mydemo 点击“next”
6	界面5：management option	取消“configure the database with enterprise manager” 取消“use database control for database management”下的报警和备份选项 点击“next”
7	界面6：database credential	选择“use the same password for all account” password = passwd confirm password = passwd 点击“next”
8	界面7：storage option	选择“file system”，点击“next”
9	界面8：database file location	选择“use common location for all database files” database file location = /xxxxx/mydemo/data/oradata/mydemo 点击“next”
10	界面9：recovery configuration	选择“specify flash recovery area” flash recovery area = /xxxxx/backup/flash_recovery flash recovery area size = 2048 点击“next”
11	界面10：database content	点击“next”
12	界面11：initialization parameter	MEMORY： 选择“custom” shared memory management 选择“automatic” shared pool = 200 buffer cache = 24 java pool = 48 large pool = 50 SIZE: processes = 350 CHARACTER SETS: choose from the list of character sets 选择“ZHS16GBK” CONNECTION MODE: 选择“dedicated server mode”
13	界面12：database storage	修改controlfile、datafile、logfile的路径为 /xxxx/data/oradata/mydemo 注意：sysaux表空间需要调整到500M，否则在执行建库脚本的时候可能会报错。
14	界面13：create database	选择“save information to a shell script”，点击“finish”
15	执行创建数据库脚本	cd $HOME_BASE/admin/mydemo 执行下面脚本前，在init.ora文件里，添加如下文本，将sga大小设置为500M ########################################### # SGA Memory ########################################### sga_target=524288000 然后执行下面脚本 . ./mydemo.sh
16	检查创建数据库的log	cd $HOME_BASE/admin/mydemo grep ORA- *.log
17	关闭所有datafile的自动扩展	alter database datafile '/xxxx/mydemo/data/oradata/mydemo/tools01.dbf' autoextend off; alter database tempfile '/xxxx/mydemo/data/oradata/mydemo/temp01.dbf' autoextend off; 数据库中所有的表空间都需要执行alter autoextend off语句
18	实施oracle patch	cd 4883174 $ORACLE_HOME/OPatch/opatch apply