Oracle的“create database”命令不会自动的创建不存在的路径,因此,在执行“create database”之前,你没有创建需要的路径的话,你就会遇到如题所示的错误。
具体如下:

[oracle@rhel7 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 23 09:36:22 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  251658240 bytes
Fixed Size                  2923096 bytes
Variable Size             192939432 bytes
Database Buffers           50331648 bytes
Redo Buffers                5464064 bytes
SQL> 
SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
callah           STARTED

SQL> 
SQL> create database callah
  2  user sys identified by oracle
  3  user system identified by oracle
  4  logfile
  5  group 1 ('/u01/app/oracle/oradata/CALLAH/datafile/redo01a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo01b.log') size 100m,
  6  group 2 ('/u01/app/oracle/oradata/CALLAH/datafile/redo02a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo02b.log') size 100m,
  7  group 3 ('/u01/app/oracle/oradata/CALLAH/datafile/redo03a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo03b.log') size 100m
  8  maxloghistory 1
  9  maxlogfiles 16
 10  maxlogmembers 3
 11  maxdatafiles 1024
 12  character set AL32UTF8
 13  national character set AL16UTF16
 14  extent management local
 15  datafile '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited
 16  sysaux datafile '/u01/app/oracle/oradata/CALLAH/datafile/sysaux01.dbf' size 550m reuse autoextend on next 20m maxsize unlimited
 17  default tablespace users datafile '/u01/app/oracle/oradata/CALLAH/datafile/users01.dbf' size 500m reuse autoextend on maxsize unlimited
 18  default temporary tablespace temptbs01 tempfile '/u01/app/oracle/oradata/CALLAH/datafile/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
 19  undo tablespace undotbs01 datafile '/u01/app/oracle/oradata/CALLAH/datafile/undotbs01a.dbf' size 300m reuse autoextend on next 50m maxsize unlimited
 20  enable pluggable database
 21  seed file_name_convert=('/u01/app/oracle/oradata/CALLAH/datafile/','/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/')
 22  ;
create database callah
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dcore.bsq' near line 1079
ORA-01519: error while processing file '?/rdbms/admin/dcore.bsq' near line 88
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file
'/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/system01.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Process ID: 13059
Session ID: 1 Serial number: 10888


SQL> !ls -ltr /u01/app/oracle/oradata/CALLAH/datafile/
total 1331232
-rw-r----- 1 oracle oinstall 104858112 Apr 23 09:43 redo02a.log
-rw-r----- 1 oracle oinstall 104858112 Apr 23 09:43 redo03a.log
-rw-r----- 1 oracle oinstall 104858112 Apr 23 09:43 redo02b.log
-rw-r----- 1 oracle oinstall 104858112 Apr 23 09:43 redo03b.log
-rw-r----- 1 oracle oinstall 734011392 Apr 23 09:43 system01.dbf
-rw-r----- 1 oracle oinstall 104858112 Apr 23 09:43 redo01a.log
-rw-r----- 1 oracle oinstall 104858112 Apr 23 09:43 redo01b.log

SQL> 

这个过程中的后台日志(alert)的呈现如下:

Sat Apr 23 09:43:11 2016
create database callah
user sys identified by *user system identified by *logfile
group 1 ('/u01/app/oracle/oradata/CALLAH/datafile/redo01a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo01b.log') size 100m,
group 2 ('/u01/app/oracle/oradata/CALLAH/datafile/redo02a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo02b.log') size 100m,
group 3 ('/u01/app/oracle/oradata/CALLAH/datafile/redo03a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo03b.log') size 100m
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 1024
character set AL32UTF8
national character set AL16UTF16
extent management local
datafile '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited
sysaux datafile '/u01/app/oracle/oradata/CALLAH/datafile/sysaux01.dbf' size 550m reuse autoextend on next 20m maxsize unlimited
default tablespace users datafile '/u01/app/oracle/oradata/CALLAH/datafile/users01.dbf' size 500m reuse autoextend on maxsize unlimited
default temporary tablespace temptbs01 tempfile '/u01/app/oracle/oradata/CALLAH/datafile/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
undo tablespace undotbs01 datafile '/u01/app/oracle/oradata/CALLAH/datafile/undotbs01a.dbf' size 300m reuse autoextend on next 50m maxsize unlimited
enable pluggable database
seed file_name_convert=('/u01/app/oracle/oradata/CALLAH/datafile/','/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/')
Sat Apr 23 09:43:12 2016
Database mounted in Exclusive Mode
Lost write protection disabled


Sat Apr 23 09:43:28 2016
Successful mount of redo thread 1, with mount id 653533871
Sat Apr 23 09:43:28 2016
Ping without log force is disabled
.
Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED 
Database SCN compatibility initialized to 1
Starting background process TMON
Sat Apr 23 09:43:28 2016
TMON started with pid=21, OS id=13061 
Sat Apr 23 09:43:28 2016
Assigning activation ID 653533871 (0x26f422af)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/CALLAH/datafile/redo01a.log
  Current log# 1 seq# 1 mem# 1: /u01/app/oracle/oradata/CALLAH/datafile/redo01b.log
Successful open of redo thread 1
Sat Apr 23 09:43:29 2016
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Database Characterset for PDB$SEED is AL32UTF8
Sat Apr 23 09:43:29 2016
SMON: enabling cache recovery
Sat Apr 23 09:43:29 2016
processing ?/rdbms/admin/dcore.bsq
create tablespace SYSTEM datafile  '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited

  EXTENT MANAGEMENT LOCAL online


Completed: create tablespace SYSTEM datafile  '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited

  EXTENT MANAGEMENT LOCAL online
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Sat Apr 23 09:43:53 2016
UNDO_SEG_CRT: Could not find usn tail
Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Caching undo dictionary info: used hint for object index=0 
Caching undo dictionary info: used hint for object index=1 
Caching undo dictionary info: used hint for object index=2 
Caching undo dictionary info: used hint for object index=3 
Caching undo dictionary info: used hint for object index=4 
Undo initialization finished serial:0 start:17623864 end:17623864 diff:0 ms (0.0 seconds)
processing ?/rdbms/admin/dcore.bsq
create tablespace SYSTEM datafile  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/system01.dbf' SIZE 220200960 REUSE AUTOEXTEND ON NEXT 20971520 MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL online
ORA-1119 signalled during: create tablespace SYSTEM datafile  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/system01.dbf' SIZE 220200960 REUSE AUTOEXTEND ON NEXT 20971520 MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL online
...
Sat Apr 23 09:43:54 2016
Errors in file /u01/app/oracle/diag/rdbms/callah/callah/trace/callah_ora_13059.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/system01.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Sat Apr 23 09:43:54 2016
Errors in file /u01/app/oracle/diag/rdbms/callah/callah/trace/callah_ora_13059.trc:
ORA-01519: error while processing file '?/rdbms/admin/dcore.bsq' near line 88
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/system01.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Sat Apr 23 09:43:54 2016
Errors in file /u01/app/oracle/diag/rdbms/callah/callah/trace/callah_ora_13059.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dcore.bsq' near line 1079
ORA-01519: error while processing file '?/rdbms/admin/dcore.bsq' near line 88
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/system01.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Error 1519 happened during database creation, shutting down database
USER (ospid: 13059): terminating the instance due to error 1519


Sat Apr 23 09:43:55 2016
Instance terminated by USER, pid = 13059
ORA-1092 signalled during: create database callah
user sys identified by *user system identified by *logfile
group 1 ('/u01/app/oracle/oradata/CALLAH/datafile/redo01a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo01b.log') size 100m,
group 2 ('/u01/app/oracle/oradata/CALLAH/datafile/redo02a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo02b.log') size 100m,
group 3 ('/u01/app/oracle/oradata/CALLAH/datafile/redo03a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo03b.log') size 100m
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 1024
character set AL32UTF8
national character set AL16UTF16
extent management local
datafile '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited
sysaux datafile '/u01/app/oracle/oradata/CALLAH/datafile/sysaux01.dbf' size 550m reuse autoextend on next 20m maxsize unlimited
default tablespace users datafile '/u01/app/oracle/oradata/CALLAH/datafile/users01.dbf' size 500m reuse autoextend on maxsize unlimited
default temporary tablespace temptbs01 tempfile '/u01/app/oracle/oradata/CALLAH/datafile/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
undo tablespace undotbs01 datafile '/u01/app/oracle/oradata/CALLAH/datafile/undotbs01a.dbf' size 300m reuse autoextend on next 50m maxsize unlimited
enable pluggable database
seed file_name_convert=('/u01/app/oracle/oradata/CALLAH/datafile/','/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/')
...
opiodr aborting process unknown ospid (13059) as a result of ORA-1092
Sat Apr 23 09:43:55 2016
ORA-1092 : opitsk aborting process

解决方法很简单,在执行“create database”前,把需要的路径提前创建好。
比如在本例中,你需要先创建好:/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/。

如下:

[oracle@rhel7 dbs]$ cd $ORACLE_BASE/oradata/CALLAH/datafile
[oracle@rhel7 datafile]$ ls
redo01a.log  redo01b.log  redo02a.log  redo02b.log  redo03a.log  redo03b.log  system01.dbf
[oracle@rhel7 datafile]$ 
[oracle@rhel7 datafile]$ rm -rf *
[oracle@rhel7 datafile]$ 
[oracle@rhel7 datafile]$ ls
[oracle@rhel7 datafile]$ 
[oracle@rhel7 datafile]$ mkdir /u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/
[oracle@rhel7 datafile]$ 
[oracle@rhel7 datafile]$ pwd
/u01/app/oracle/oradata/CALLAH/datafile
[oracle@rhel7 datafile]$ 
[oracle@rhel7 datafile]$ ls
pdb_seed_data
[oracle@rhel7 datafile]$ 
[oracle@rhel7 datafile]$ ls pdb_seed_data/
[oracle@rhel7 datafile]$ 
[oracle@rhel7 datafile]$ 

然后,重新启动数据库到NOMOUNT,然后,再执行一次刚刚的“create database”命令,即可。

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  251658240 bytes
Fixed Size                  2923096 bytes
Variable Size             192939432 bytes
Database Buffers           50331648 bytes
Redo Buffers                5464064 bytes
SQL> 
SQL> create database callah
  2  user sys identified by oracle
  3  user system identified by oracle
  4  logfile
  5  group 1 ('/u01/app/oracle/oradata/CALLAH/datafile/redo01a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo01b.log') size 100m,
  6  group 2 ('/u01/app/oracle/oradata/CALLAH/datafile/redo02a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo02b.log') size 100m,
  7  group 3 ('/u01/app/oracle/oradata/CALLAH/datafile/redo03a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo03b.log') size 100m
  8  maxloghistory 1
  9  maxlogfiles 16
 10  maxlogmembers 3
 11  maxdatafiles 1024
 12  character set AL32UTF8
 13  national character set AL16UTF16
 14  extent management local
 15  datafile '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited
 16  sysaux datafile '/u01/app/oracle/oradata/CALLAH/datafile/sysaux01.dbf' size 550m reuse autoextend on next 20m maxsize unlimited
 17  default tablespace users datafile '/u01/app/oracle/oradata/CALLAH/datafile/users01.dbf' size 500m reuse autoextend on maxsize unlimited
 18  default temporary tablespace temptbs01 tempfile '/u01/app/oracle/oradata/CALLAH/datafile/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
 19  undo tablespace undotbs01 datafile '/u01/app/oracle/oradata/CALLAH/datafile/undotbs01a.dbf' size 300m reuse autoextend on next 50m maxsize unlimited
 20  enable pluggable database
 21  seed file_name_convert=('/u01/app/oracle/oradata/CALLAH/datafile/','/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/')
 22  ;

Database created.

SQL> 

如上,数据库创建完成。

这段过程中的后台日志如下:

Sat Apr 23 09:51:52 2016
Using default pga_aggregate_limit of 6787 MB
Sat Apr 23 09:51:57 2016
create database callah
user sys identified by *user system identified by *logfile
group 1 ('/u01/app/oracle/oradata/CALLAH/datafile/redo01a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo01b.log') size 100m,
group 2 ('/u01/app/oracle/oradata/CALLAH/datafile/redo02a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo02b.log') size 100m,
group 3 ('/u01/app/oracle/oradata/CALLAH/datafile/redo03a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo03b.log') size 100m
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 1024
character set AL32UTF8
national character set AL16UTF16
extent management local
datafile '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited
sysaux datafile '/u01/app/oracle/oradata/CALLAH/datafile/sysaux01.dbf' size 550m reuse autoextend on next 20m maxsize unlimited
default tablespace users datafile '/u01/app/oracle/oradata/CALLAH/datafile/users01.dbf' size 500m reuse autoextend on maxsize unlimited
default temporary tablespace temptbs01 tempfile '/u01/app/oracle/oradata/CALLAH/datafile/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
undo tablespace undotbs01 datafile '/u01/app/oracle/oradata/CALLAH/datafile/undotbs01a.dbf' size 300m reuse autoextend on next 50m maxsize unlimited
enable pluggable database
seed file_name_convert=('/u01/app/oracle/oradata/CALLAH/datafile/','/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/')
Sat Apr 23 09:51:58 2016
Database mounted in Exclusive Mode
Lost write protection disabled
Sat Apr 23 09:52:05 2016
Successful mount of redo thread 1, with mount id 653562557
Sat Apr 23 09:52:05 2016
Ping without log force is disabled
.
Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED 
Database SCN compatibility initialized to 1
Starting background process TMON
Sat Apr 23 09:52:05 2016
TMON started with pid=21, OS id=13360 
Sat Apr 23 09:52:05 2016
Assigning activation ID 653562557 (0x26f492bd)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/CALLAH/datafile/redo01a.log
  Current log# 1 seq# 1 mem# 1: /u01/app/oracle/oradata/CALLAH/datafile/redo01b.log
Successful open of redo thread 1
Sat Apr 23 09:52:05 2016
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Database Characterset for PDB$SEED is AL32UTF8
Sat Apr 23 09:52:05 2016
SMON: enabling cache recovery
Sat Apr 23 09:52:05 2016
processing ?/rdbms/admin/dcore.bsq
create tablespace SYSTEM datafile  '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited
  EXTENT MANAGEMENT LOCAL online
Completed: create tablespace SYSTEM datafile  '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited
  EXTENT MANAGEMENT LOCAL online
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
UNDO_SEG_CRT: Could not find usn tail
Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Caching undo dictionary info: used hint for object index=0 
Caching undo dictionary info: used hint for object index=1 
Caching undo dictionary info: used hint for object index=2 
Caching undo dictionary info: used hint for object index=3 
Caching undo dictionary info: used hint for object index=4 
Undo initialization finished serial:0 start:18123194 end:18123194 diff:0 ms (0.0 seconds)
processing ?/rdbms/admin/dcore.bsq
create tablespace SYSTEM datafile  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/system01.dbf' SIZE 220200960 REUSE AUTOEXTEND ON NEXT 20971520 MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL online
Sat Apr 23 09:52:13 2016
Buffer Cache Full DB Caching mode changing from FULL CACHING ENABLED to FULL CACHING DISABLED 
Full DB Caching disabled: DEFAULT_CACHE_SIZE should be at least 652 MBs bigger than current size. 
Completed: create tablespace SYSTEM datafile  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/system01.dbf' SIZE 220200960 REUSE AUTOEXTEND ON NEXT 20971520 MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL online
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Sat Apr 23 09:52:20 2016
UNDO_SEG_CRT: Could not find usn tail
Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
alter tablespace system force logging
Completed: alter tablespace system force logging
alter tablespace system force logging
Completed: alter tablespace system force logging
processing ?/rdbms/admin/dsqlddl.bsq
processing ?/rdbms/admin/dmanage.bsq
CREATE TABLESPACE sysaux DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/sysaux01.dbf' size 550m reuse autoextend on next 20m maxsize unlimited
  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
Completed: CREATE TABLESPACE sysaux DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/sysaux01.dbf' size 550m reuse autoextend on next 20m maxsize unlimited
  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
CREATE TABLESPACE sysaux DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/sysaux01.dbf' SIZE 173015040 REUSE AUTOEXTEND ON NEXT 20971520 MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
Completed: CREATE TABLESPACE sysaux DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/sysaux01.dbf' SIZE 173015040 REUSE AUTOEXTEND ON NEXT 20971520 MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
alter tablespace system default compress for all operations
Completed: alter tablespace system default compress for all operations
alter tablespace system default compress for all operations
Completed: alter tablespace system default compress for all operations
alter tablespace sysaux default compress for all operations
Completed: alter tablespace sysaux default compress for all operations
alter tablespace sysaux default compress for all operations
Completed: alter tablespace sysaux default compress for all operations
Sat Apr 23 09:52:55 2016
processing ?/rdbms/admin/dplsql.bsq
processing ?/rdbms/admin/dtxnspc.bsq
CREATE UNDO TABLESPACE UNDOTBS01 DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/undotbs01a.dbf' size 300m reuse autoextend on next 50m maxsize unlimited
Sat Apr 23 09:53:08 2016
[13350] Successfully onlined Undo Tablespace 2.
Completed: CREATE UNDO TABLESPACE UNDOTBS01 DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/undotbs01a.dbf' size 300m reuse autoextend on next 50m maxsize unlimited
CREATE TEMPORARY TABLESPACE TEMPTBS01 TEMPFILE  '/u01/app/oracle/oradata/CALLAH/datafile/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
Completed: CREATE TEMPORARY TABLESPACE TEMPTBS01 TEMPFILE  '/u01/app/oracle/oradata/CALLAH/datafile/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
CREATE TEMPORARY TABLESPACE TEMPTBS01 TEMPFILE  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
Completed: CREATE TEMPORARY TABLESPACE TEMPTBS01 TEMPFILE  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTBS01
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTBS01
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTBS01
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTBS01
CREATE  TABLESPACE USERS DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/users01.dbf' size 500m reuse autoextend on maxsize unlimited
 SEGMENT SPACE MANAGEMENT AUTO
Completed: CREATE  TABLESPACE USERS DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/users01.dbf' size 500m reuse autoextend on maxsize unlimited
 SEGMENT SPACE MANAGEMENT AUTO
CREATE  TABLESPACE USERS DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/users01.dbf' size 500m reuse autoextend on maxsize unlimited
 SEGMENT SPACE MANAGEMENT AUTO
Completed: CREATE  TABLESPACE USERS DATAFILE  '/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/users01.dbf' size 500m reuse autoextend on maxsize unlimited
 SEGMENT SPACE MANAGEMENT AUTO
ALTER DATABASE DEFAULT TABLESPACE USERS
Completed: ALTER DATABASE DEFAULT TABLESPACE USERS
ALTER DATABASE DEFAULT TABLESPACE USERS
Completed: ALTER DATABASE DEFAULT TABLESPACE USERS
Sat Apr 23 09:53:40 2016
processing ?/rdbms/admin/dfmap.bsq
processing ?/rdbms/admin/denv.bsq
processing ?/rdbms/admin/drac.bsq
processing ?/rdbms/admin/dsec.bsq
processing ?/rdbms/admin/doptim.bsq
processing ?/rdbms/admin/dobj.bsq
processing ?/rdbms/admin/djava.bsq
processing ?/rdbms/admin/dpart.bsq
processing ?/rdbms/admin/drep.bsq
Sat Apr 23 09:53:52 2016
processing ?/rdbms/admin/daw.bsq
processing ?/rdbms/admin/dsummgt.bsq
processing ?/rdbms/admin/dtools.bsq
processing ?/rdbms/admin/dexttab.bsq
processing ?/rdbms/admin/ddm.bsq
processing ?/rdbms/admin/dlmnr.bsq
processing ?/rdbms/admin/ddst.bsq
processing ?/rdbms/admin/dfba.bsq
processing ?/rdbms/admin/dpstdy.bsq
processing ?/rdbms/admin/drupg.bsq
processing ?/rdbms/admin/dtlog.bsq
Sat Apr 23 09:54:00 2016
SMON: enabling tx recovery
Starting background process SMCO
Sat Apr 23 09:54:02 2016
SMCO started with pid=23, OS id=13385 
Sat Apr 23 09:54:03 2016
Successfully created internal service SYS$BACKGROUND at open
Successfully created internal service SYS$USERS at open
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process AQPC
Sat Apr 23 09:54:03 2016
AQPC started with pid=26, OS id=13395 
ALTER SYSTEM: Flushing buffer cache inst=0 container=2 local
Database Characterset for PDB$SEED is AL32UTF8
Accessing dba_registry_sqlpatch hit error: 942
Accessing dba_registry_sqlpatch hit error: 942
Due to limited space in shared pool (need 6094848 bytes, have 3981120 bytes), limiting Resource Manager entities from 2048 to 32
ALTER SYSTEM: Flushing buffer cache inst=0 container=2 local
Database Characterset for PDB$SEED is AL32UTF8
Due to limited space in shared pool (need 6094848 bytes, have 3981120 bytes), limiting Resource Manager entities from 2048 to 32
Completed: create database callah
user sys identified by *user system identified by *logfile
group 1 ('/u01/app/oracle/oradata/CALLAH/datafile/redo01a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo01b.log') size 100m,
group 2 ('/u01/app/oracle/oradata/CALLAH/datafile/redo02a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo02b.log') size 100m,
group 3 ('/u01/app/oracle/oradata/CALLAH/datafile/redo03a.log','/u01/app/oracle/oradata/CALLAH/datafile/redo03b.log') size 100m
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 1024
character set AL32UTF8
national character set AL16UTF16
extent management local
datafile '/u01/app/oracle/oradata/CALLAH/datafile/system01.dbf' size 700m reuse autoextend on next 20m maxsize unlimited
sysaux datafile '/u01/app/oracle/oradata/CALLAH/datafile/sysaux01.dbf' size 550m reuse autoextend on next 20m maxsize unlimited
default tablespace users datafile '/u01/app/oracle/oradata/CALLAH/datafile/users01.dbf' size 500m reuse autoextend on maxsize unlimited
default temporary tablespace temptbs01 tempfile '/u01/app/oracle/oradata/CALLAH/datafile/temptbs01a.dbf' size 200m reuse autoextend on next 20m maxsize unlimited
undo tablespace undotbs01 datafile '/u01/app/oracle/oradata/CALLAH/datafile/undotbs01a.dbf' size 300m reuse autoextend on next 50m maxsize unlimited
enable pluggable database
seed file_name_convert=('/u01/app/oracle/oradata/CALLAH/datafile/','/u01/app/oracle/oradata/CALLAH/datafile/pdb_seed_data/')
Sat Apr 23 09:54:04 2016
db_recovery_file_dest_size of 4827 MB is 0.39% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

看看文件系统中的变化:

SQL> !tree /u01/app/oracle/oradata/CALLAH/
/u01/app/oracle/oradata/CALLAH/
├── controlfile
│   ├── o1_mf_ckonsh94_.ctl
│   └── o1_mf_ckoo9xsz_.ctl
└── datafile
    ├── pdb_seed_data
    │   ├── sysaux01.dbf
    │   ├── system01.dbf
    │   ├── temptbs01a.dbf
    │   └── users01.dbf
    ├── redo01a.log
    ├── redo01b.log
    ├── redo02a.log
    ├── redo02b.log
    ├── redo03a.log
    ├── redo03b.log
    ├── sysaux01.dbf
    ├── system01.dbf
    ├── temptbs01a.dbf
    ├── undotbs01a.dbf
    └── users01.dbf

3 directories, 17 files

SQL> 

最后,还要执行必要的脚本:

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
callah           OPEN

SQL> 

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

SYSTEM:
@?/sqlplus/admin/pupbld.sql

SYS:
@?/rdbms/admin/catcdb.sql

————————————
Done。

说点什么

avatar

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据

  Subscribe  
提醒