Oracle-12c

無法創建數據庫:處理文件 dmanage.bsq 時出錯

  • May 29, 2017

我想在我最近安裝的 Oracle 12c 上創建一個數據庫,所以在為我的實例創建 spfile 和 listener/tnsnames/sqlnet.ora 之後,我呼叫我的 CREATE DATABASE 請求:

CREATE DATABASE DBNAME
  USER SYS    identified by password
  USER SYSTEM identified by password
    MAXINSTANCES  1
    MAXLOGHISTORY 1
    MAXLOGFILES   20
    MAXLOGMEMBERS 4
    MAXDATAFILES  200
  CONTROLFILE REUSE
  DATAFILE
          '/[...]/system_01.dbf' SIZE 1000M REUSE
  EXTENT MANAGEMENT LOCAL
  SYSAUX DATAFILE
          '/[...]/sysaux_01.dbf' SIZE 2000M REUSE
  UNDO TABLESPACE "UNDO" DATAFILE
          '/[...]/undo_01.dbf'     SIZE 2000M REUSE
  DEFAULT TEMPORARY TABLESPACE "TMP" TEMPFILE
          '/[...]/tmp_01.dbf'       SIZE 2000M REUSE
           EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 1M
  LOGFILE
      GROUP 1 ('/[...]/redo_1a.dbf',
               '/[...]/redo_1b.dbf') SIZE 100M REUSE,
      GROUP 2 ('/[...]/redo_2a.dbf',
               '/[...]/redo_2b.dbf') SIZE 100M REUSE,
  CHARACTER SET WE8ISO8859P15
  NATIONAL CHARACTER SET AL16UTF16 ;

我得到這個錯誤:

CREATE DATABASE DBNAME
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dmanage.bsq' near line 22
ORA-00604: error occurred at recursive SQL level 1
ORA-19502: write error on file "/[...]/sysaux_01.dbf", block
number 640 (block size=8192)
ORA-27085: Message 27085 not found;  product=RDBMS; facility=ORA
Additional information: 1044480
Additional information: 1048576
Process ID: 23040
Session ID: 244 Serial number: 9021

dmanage.bsq 文件第 22 行的請求是:

CREATE TABLESPACE sysaux DATAFILE "D_SXFN"
 "D_SDSG" ONLINE FORCE LOGGING
/

我的請求有什麼問題?

根據這個執行緒,這個錯誤意味著我的磁碟空間不足。我為我的數據文件嘗試了相同的請求,但它的大小更小,它可以工作。

所以,我有兩個解決方案:根據我的要求調整我的數據文件的大小或擴展我的邏輯卷

引用自:https://dba.stackexchange.com/questions/174806