ocm考试最精炼oracle10g手动建库脚本

1.创建目录

mkdir -p /u01/admin/orcl/{a,b,c,u}dump
mkdir -p /u01/oradata/orcl

2.环境变量、开机自启动、密码文件

export ORACLE_SID=orcl
echo orcl:/u01/oracle:Y >> /etc/oratab
orapwd file=/u01/oracle/dbs/orapworcl password=oracle

3.参数文件，用vi写入，各种dump默认值即在上面创建的目录中。

vi /u01/admin/orcl/init.ora
db_name=orcl
sga_target=256m
control_files='/u01/oradata/orcl/control01.ctl'
undo_management=auto

4.登入sqlplus，用pfile启动到noumount状态

sqlplus / as sysdba
startup nomount pfile=/u01/admin/orcl/init.ora

5.建库语句，没设扩展，不想让它们扩展。

CREATE DATABASE orcl
DATAFILE '/u01/oradata/orcl/system01.dbf' SIZE 300M 
	EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oradata/orcl/sysaux01.dbf' SIZE 120M 
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oradata/orcl/temp01.dbf' SIZE 20M
UNDO TABLESPACE undotbs1 DATAFILE '/u01/oradata/orcl/undotbs01.dbf' SIZE 200M
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE 
	GROUP 1 '/u01/oradata/orcl/redo01.log' SIZE 50m,
	GROUP 2 '/u01/oradata/orcl/redo02.log' SIZE 50m,
	GROUP 3 '/u01/oradata/orcl/redo03.log' SIZE 50m
user sys identified by oracle
user system identified by oracle;

6.创建数据字典和各种功能包

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

死记这三十几行代码。

最后，开始使用库前，别忘了spfile和users表空间，就不写代码举例了...