SMON: enabling cache recovery
Sun Feb 15 00:28:33 2015
create tablespace SYSTEM datafile '$ORACLE_BASE/oradata/prod/system01.dbf' size 400m
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Sun Feb 15 00:28:41 2015
Completed: create tablespace SYSTEM datafile '$ORACLE_BASE/oradata/prod/system01.dbf' size 400m
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Sun Feb 15 00:28:41 2015
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Sun Feb 15 00:28:50 2015
CREATE UNDO TABLESPACE RTBS DATAFILE '$ORACLE_BASE/oradata/prod/undo01.dbf' size 100m
Sun Feb 15 00:28:52 2015
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE RTBS DATAFILE '$ORACLE_BASE/oradata/prod/undo01.dbf' size 100m
Sun Feb 15 00:28:52 2015
create tablespace SYSAUX datafile '$ORACLE_BASE/oradata/prod/sysaux01.dbf' size 100m
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Completed: create tablespace SYSAUX datafile '$ORACLE_BASE/oradata/prod/sysaux01.dbf' size 100m
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Sun Feb 15 00:28:55 2015
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '$ORACLE_BASE/oradata/prod/temp01.dbf' size 100m
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '$ORACLE_BASE/oradata/prod/temp01.dbf' size 100m
Sun Feb 15 00:28:56 2015
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Sun Feb 15 00:28:56 2015
ALTER DATABASE DEFAULT TABLESPACE SYSTEM
Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM
Sun Feb 15 00:29:01 2015
SMON: enabling tx recovery
Sun Feb 15 00:29:03 2015
Threshold validation cannot be done before catproc is loaded.
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=13, OS id=18386
Sun Feb 15 00:29:04 2015
Completed: create database prod
user sys identified by ****user system identified by *datafile '$ORACLE_BASE/oradata/prod/system01.dbf' size 400m
sysaux datafile '$ORACLE_BASE/oradata/prod/sysaux01.dbf' size 100m
default temporary tablespace temp tempfile '$ORACLE_BASE/oradata/prod/temp01.dbf' size 100m
undo tablespace rtbs datafile '$ORACLE_BASE/oradata/prod/undo01.dbf' size 100m
logfile
group 1 '$ORACLE_BASE/oradata/prod/redo01.log' size 50m,
group 2 '$ORACLE_BASE/oradata/prod/redo02.log' size 50m
character set zhs16gbk
3、建立数据字典
[oracle@sigleNode dbs]$ vi cr_dict.sql
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
conn system/prod
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
直接执行脚本
SQL>@ORACLE_HOME/dbs/cr_dict.sql;
即可
4、创建用户表空间
SQL> create tablespace users datafile '$ORACLE_BASE/oradata/prod/user01.dbf' size 500m;
Tablespace created.
SQL> alter database default tablespace users;
Database altered.
创建数据库prod完成