$ : cd $ORACLE_HOME/dbs
$: export ORACLE_SID=omfdb
$：vi initomfdb.ora
[oracle@linux dbs]$ cat initomfdb.ora
DB_NAME='omfdb'
MEMORY_TARGET=900M
db_create_file_dest = '/u01/app/oracle/oradata/omfdb'
$:mkdir -p /u01/app/oracle/oradata/omfdb
登入数据库
> create spfile from pfile;
> startup nomount;
> create database;
> @?/rdbms/admin/catalog.sql ；
> @?/rdbms/admin/catproc.sql ；
> @?/rdbms/admin/utlrp.sql
切换为system用户 ，运行最后一个脚本
[oracle@linux02 ~]$ sqlplus system/oracle ；
> @?/sqlplus/admin/pupbld.sql ；
查看自动创建的文件大小、命名
select file_name,tablespace_name,bytes/1024/1024||'M' M from dba_data_files;
以下为文档：
[oracle@linux02 ~]$ vi .bash_profile
export ORACLE_SID=hldb
export ORACLE_UNQNAME=hldb
[oracle@linux02 ~]$ source .bash_profile
[oracle@linux02 oradata]$ cd /u01/app/oracle/oradata
[oracle@linux02 oradata]$ pwd
/u01/app/oracle/oradata
[oracle@linux02 oradata]$ mkdir hldb
[oracle@linux02 ~]$ cd $ORACLE_HOME/dbs
[oracle@linux02 dbs]$ orapwd file=orapwhldb password=oracle
[oracle@linux02 dbs]$ vi inithldb.ora
DB_NAME='hldb'
CONTROL_FILES='/u01/app/oracle/oradata/hldb/control01.ctl'
MEMORY_TARGET=900M
[oracle@linux02 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 23 10:03:27 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 939495424 bytes
Fixed Size 2233960 bytes
Variable Size 545261976 bytes
Database Buffers 385875968 bytes
Redo Buffers 6123520 bytes
CREATE DATABASE hldb
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/hldb/redo01.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/hldb/redo02.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/hldb/redo03.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/hldb/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/hldb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/hldb/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/hldb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/hldb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
-------------------------------------------------------------------------------------------------
SQL> CREATE DATABASE hldb
2 USER SYS IDENTIFIED BY oracle
3 USER SYSTEM IDENTIFIED BY oracle
4 LOGFILE GROUP 1 ('/u01/app/oracle/oradata/hldb/redo01.log') SIZE 100M BLOCKSIZE 512,
5 GROUP 2 ('/u01/app/oracle/oradata/hldb/redo02.log') SIZE 100M BLOCKSIZE 512,
6 GROUP 3 ('/u01/app/oracle/oradata/hldb/redo03.log') SIZE 100M BLOCKSIZE 512
7 MAXLOGFILES 5
8 MAXLOGMEMBERS 5
9 MAXLOGHISTORY 1
10 MAXDATAFILES 100
11 CHARACTER SET AL32UTF8
12 NATIONAL CHARACTER SET AL16UTF16
13 EXTENT MANAGEMENT LOCAL
14 DATAFILE '/u01/app/oracle/oradata/hldb/system01.dbf' SIZE 325M REUSE
15 SYSAUX DATAFILE '/u01/app/oracle/oradata/hldb/sysaux01.dbf' SIZE 325M REUSE
16 DEFAULT TABLESPACE users
17 DATAFILE '/u01/app/oracle/oradata/hldb/users01.dbf'
18 SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
19 DEFAULT TEMPORARY TABLESPACE tempts1
20 TEMPFILE '/u01/app/oracle/oradata/hldb/temp01.dbf'
21 SIZE 20M REUSE
22 UNDO TABLESPACE undotbs
23 DATAFILE '/u01/app/oracle/oradata/hldb/undotbs01.dbf'
24 SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
Database created.
-------------------------------------------------------------------------------------------------
In SQL*Plus, connect to your Oracle Database instance with the SYSDBA administrative privilege:
[oracle@linux02 ~]$ sqlplus / as sysdba
> @?/rdbms/admin/catalog.sql
> @?/rdbms/admin/catproc.sql
> @?/rdbms/admin/utlrp.sql
In SQL*Plus, connect to your Oracle Database instance as SYSTEM user:
[oracle@linux02 ~]$ sqlplus system/oracle
> @?/sqlplus/admin/pupbld.sql
-------------------------------------------------------------------------------------------------