dbca靜默silent建立資料庫_空間不足出錯

wisdomone1發表於2010-08-03

-bash-3.1$ dbca -silent -createDatabase -templateName /oracle/product/10.2.0/db_1/assistants/dbca/templates/General_Purpose.dbc -gdbName sex -sid sex -sysPassword system -systempassword system -datafileDestination /oracle/oradata -storageType FS -characterSet zhs16gbk -memoryPercentage 30 -databaseType MULTIPURPOSE
Copying database files
1% complete
3% complete
11% complete
18% complete
19% complete
37% complete
Creating and starting Oracle instance ##進度直到從37跳以100,不正常吧
100% complete
Look at the log file "/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/sex/sex.log" for further details.  ##要分析出錯原因,檢視此日誌

 


##看到沒,日誌中明顯提示空間不足
-bash-3.1$ more /oracle/product/10.2.0/db_1/cfgtoollogs/dbca/sex/sex.log
You do not have enough free disk space to create the database.
You need at least 949248 KB on /, You have only 585728 KB available.
 
Please allocate more free disk space.
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 11%
DBCA_PROGRESS : 18%
DBCA_PROGRESS : 19%
ORA-19624: operation failed, retry possible ##空間不足,報了一堆ora錯誤
ORA-19870: error reading backup piece /oracle/product/10.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb
ORA-19502: write error on file "/oracle/oradata/sex/system01.dbf", blockno 39025 (blocksize=8192)
ORA-27072: File I/O error

ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5170
ORA-06512: at line 16

DBCA_PROGRESS : 37%
Creating and starting Oracle instance
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/oracle/oradata/sex/system01.dbf'
ORA-27037: unable to obtain file status

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/oracle/oradata/sex/system01.dbf'
ORA-27037: unable to obtain file status

DBCA_PROGRESS : 100%

 

 

處理方法:我加大了磁碟空間,再次執行dbca就ok了

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-670053/,如需轉載,請註明出處,否則將追究法律責任。

相關文章