遠端連接配接到 oracle 所在機器
sqlplus /nolog
conn / as sysdba
alter tablespace system add datafile ‘/home/oracle/systemother/system_01.dbf’ size 2048M
alter database datafile ‘/home/oracle/systemother/system_01.dbf’ autoextend on;
alter system set audit_trail=none scope=spfile;//關閉審計功能,正式環境不要執行
shutdown immediate;
startup
如果shutdown immediate 一直卡住。(幾分鐘了還沒反應)
調用
shutdown abort
startup
當看到 Database opened 表示啟動成功了。 Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size 104859892 bytes Database Buffers 58720256 bytes Redo Buffers 2973696 bytes Database mounted. Database opened.