Oracle:ORA-27040: file create error, unable to create file
Oracle的“create database”命令不会自动的创建不存在的路径,因此,在执行“create database”之前,你没有创建需要的路径的话,你就会遇到如题所示的错误。
具体如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
[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)的呈现如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 |
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/。
如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
[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”命令,即可。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
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> |
如上,数据库创建完成。
这段过程中的后台日志如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 |
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. |
看看文件系统中的变化:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
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> |
最后,还要执行必要的脚本:
1 2 3 4 5 6 7 |
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。
说点什么