ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dbca静默silent创建数据库_空间不足出错

dbca静默silent创建数据库_空间不足出错

原创 Linux操作系统 作者:wisdomone1 时间:2010-08-03 10:06:02 0 删除 编辑

-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博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-670053/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb 工作经历: 中国普天 北京科蓝 北京云和恩墨 北京神州新桥

注册时间:2008-04-04

  • 博文量
    2189
  • 访问量
    12689910