其實對 Oracle 並不是太熟,結果遇到這個錯誤,只好滿臉 黑人問號.jpg
 
UDE-00600: 作業產生的 ORACLE 錯誤 600
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
使用者名稱: UDE-00005: 讀取輸入時發生非預期的檔案結尾
拜 google 大神後,找了個解法,雖然看不懂,但是趕緊記錄起來才是正道啊!!!
 
1. 建立新的 undo 空間
SQL>  create undo tablespace undotbs2
  2   datafile '/oracle/undotbs2.dbf' size 100M;

Tablespace created.
 
2. 設置 undo 管理方式為 ’自動‘
SQL> alter system set undo_management=auto scope=spfile;

System altered.
 
3. 設置 undotbs 為新建的undotbs2
SQL>  alter system set undo_tablespace=undotbs2 scope=spfile;

System altered.
 
4. 刪除原來損壞的undo表空間 
SQL> drop tablespace undotbs02 including contents and datafiles;

Tablespace dropped.
5. 重啟 oracle
SQL>  startup force;
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2213776 bytes
Variable Size            1241516144 bytes
Database Buffers          352321536 bytes
Redo Buffers                7360512 bytes
Database mounted.
Database opened.
Facebook 討論區載入中...