Oracle：ORA-27040: file create error, unable to create file
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。
说点什么