Oracle-12c
無法創建數據庫:處理文件 dmanage.bsq 時出錯
我想在我最近安裝的 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 /
我的請求有什麼問題?
根據這個執行緒,這個錯誤意味著我的磁碟空間不足。我為我的數據文件嘗試了相同的請求,但它的大小更小,它可以工作。
所以,我有兩個解決方案:根據我的要求調整我的數據文件的大小或擴展我的邏輯卷。