1.首先要有一个参数文件
$ sqlplus “/ as sysdba”
SQL> startup nomount;
2.创建脚本，参考其他数据库
SQL> create database dbstat
2 logfile group 1 (‘/data1/dbstat/redo1.log’) size 50M,
3 group 2 (‘/data1/dbstat/redo2.log’) size 50M,
4 group 3 (‘/data1/dbstat/redo3.log’) size 50M
5 character set ZHS16GBK
6 national character set utf8
7 datafile ‘/data1/dbstat/system.dbf’
8 size 500M autoextend on next 10M maxsize unlimited extent management local
12 sysaux datafile ‘/data1/dbstat/sysaux.dbf’
13 size 500M autoextend on next 10M maxsize unlimited
17 undo tablespace undotbs1
18 datafile ‘/data1/dbstat/undo.dbf’ size 100M
20 default temporary tablespace temp
21 tempfile ‘/data1/dbstat/temp.dbf’ size 100M;
Database created.
3.在后台跑其他脚本
$ nohup sqlplus “/ as sysdba” @?/rdbms/admin/catalog.sql &
nohup sqlplus “/ as sysdba” @?/rdbms/admin/catproc.sql &
4.还有一个脚本要运行
这是数据库用普通用户登录会出现一个错误，提示以SYSTEM运行PUPBLD.SQL脚本
SQL> @?/sqlplus/admin/pupbld.sql
http://www.eygle.com/archives/2009/09/createoracle_10.html
