This parameter is ignored by the new diagnosability infrastructure introduced in Oracle Database 11g Release 1, which places trace and core files in a location controlled by the DIAGNOSTIC_DEST initialization parameter.
第八步:调整pfile参数文件,并创建spfile文件后启动
打开pfile文件,可以看到两个弃用的参数后面都有注释“#Deprecate parameter”
将两个废弃的参数注释,然后生成spfile文件后启动
SYS@cams>create spfile from pfile;
File created.
SYS@cams>startup;
ORACLE instance started.
Total System Global Area 776646656 bytes
Fixed Size 2257272 bytes
Variable Size 482348680 bytes
Database Buffers 285212672 bytes
Redo Buffers 6828032 bytes
Database mounted.
Database opened.
第九步:模拟在第六步的时候未能及时发现参数文件被误删除,然后数据库关闭了,启动的时候报错。
[oracle@ora11g dbs]$ ls
backup hc_cams.dat initcams.ora lkCAMS orapwcams spfilecams.ora
[oracle@ora11g dbs]$ mkdir backup1
[oracle@ora11g dbs]$ mv initcams.ora spfilecams.ora backup1/
[oracle@ora11g dbs]$ ls backup1/
initcams.ora spfilecams.ora
[oracle@ora11g dbs]$ ls
backup backup1 hc_cams.dat lkCAMS orapwcams
SYS@cams>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@cams>startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initcams.ora'