远程连接到 oracle 所在机器
sqlplus /nolog
conn / as sysdba
参考:http://blog.csdn.net/wangl2014/article/details/51757068
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.
select f.* from dba_data_files f where f.tablespace_name=‘SYSTEM’;
alter tablespace SYSTEM
add datafile ‘刚才查询的文件路径及文件名改为03’
size 4096M autoextend on next 100M maxsize 10240M;
例如:
alter tablespace SYSTEM
add datafile ‘/home/oracle/app/oracle/oradata/zldb1/system03.dbf’
size 4096M autoextend on next 100M maxsize 10240M;