Spfile is in old pre-11 format and compatible >= 11.0.0

环境：SuSE Linux + Oracle Database 11gR2 (11.2.0.2)

因为需要在测试机器上多开一个实例，需要减少第一个实例的内存耗用，通过create spfile from pfile生成参数文件，修改了sga_target和sga_max_size参数，然后create spfile from pfile，使用新创建的spfile启动成功。

观察alert日志，发现下面的内容：

ORACLE_BASE from environment = /u/ora11g

Spfile /u/ora11g/product/11.2.0/db_1/dbs/spfileCFDB01.ora is in old pre-11 format and compatible >= 11.0.0; converting to new H.A.R.D. compliant format.

从MOS  1352070.1上获知：

When the spfile is created without an instance, the spfile is always created with the lowest compatibility. Only upon complete startup will the parameter layer know which compatibility to use and it will update the disk structures as appropriate.

要解决这个问题，也简单，就是在实例启动的时候进行spfile的创建。

大概步骤如下：

startup

create pfile=" " from spfile;

shutdown immediate

startup pfile = ""

create spfile from pfile;

shutdown immediate

startup

具体见文档：Spfile Is In Old Pre-11 Format; Converting To New H.A.R.D. Compliant Format (文档 ID 1352070.1)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29154652/viewspace-773560/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29154652/viewspace-773560/