SPFILE 和 PFLIE互相创建
1. 创建SPFILE
以下两种方式创建SPFILE,数据库必须不是以SPFILE方式启动的。否则会报以下错误
SQL> create spfile from pfile='/u01/app/oracle/product/12.2.0/db_1/dbs/init.ora';
create spfile from pfile='/u01/app/oracle/product/12.2.0/db_1/dbs/init.ora'
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance
SQL>
SQL> create spfile from memory;
create spfile from memory
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance
SQL>
1.1. 使用PFILE创建
SQL> create spfile from pfile='/u01/app/oracle/product/12.2.0/db_1/dbs/init.ora';
File created.
SQL>
注 :如果当前实例正在使用spfile,会创建失败
1.2 使用Memory创建
SQL> create spfile from memory;
File created.
SQL>
2. 创建PFILE
2.1. 使用SPFILE创建
SQL> create pfile='/u01/app/oracle/product/12.2.0/db_1/dbs/initorcl.ora' from spfile;
File created.
SQL>
标签:SPFILE,spfile,创建,create,PFLIE,SQL,app
From: https://www.cnblogs.com/shiqiang-lee/p/16897214.html