原因是因为静态参数写错了,用的之前搭建的参数直接复制的,改漏了
改过来,重新生成动态参数就好了
SQL> startup pfile='/u01/app/oracle/product/11.2.0/db/dbs/initadg.ora' nomount;
ORACLE instance started.
Total System Global Area 3156725760 bytes
Fixed Size 2257392 bytes
Variable Size 1157631504 bytes
Database Buffers 1979711488 bytes
Redo Buffers 17125376 bytes
SQL> create spfile='/u01/app/oracle/product/11.2.0/db/dbs/spfileadg.ora' from pfile='/u01/app/oracle/product/11.2.0/db/dbs/initadg.ora';
File created.
SQL> show parameter control_files
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
control_files string
/u01/app/oracle/oradata/adg/co
ntrol01.ctl
发表评论