允许使用传统的init.ora或SPFILE作为配置文件。但是建议所有数据库创建和使用一个SPFILE。可以从init.ora创建SPFILE
SQL> CREATE spfile FROM pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/inityoon.ora';
也可以给出明确的名字来创建SPFILE
SQL>CREATE spfile='/u01/app/oracle/product/11.2.0/db_1/dbs/nina_spfile.ora' FROM pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initnina.ora'
如果希望Oracle利用init.ora文件创建一个SPFILE
SQL>create spfile from pfile;
关闭数据库，实例将使用新的SPFILE启动，将在默认位置按照下面书序查找初始化参数文件，并且将使用找到的第一个初始化参数文件
1 默认位置查找spfile$ORACLE_SID.ora; 2 默认位置查找名为spfile.ora文件 3 默认为诶之查找传统的init.ora文件，起名字为init$ORACLE_SID.ora
如果需要使用init.ora来启动，则可以
SQL>STARTUP PFILE='/u01/app/oracle/product/11.2.0/db_1/dbs/initnina.ora'
观察SPFIL里的内容
yoon.__db_cache_size=503316480 yoon.__java_pool_size=16777216 yoon.__large_pool_size=16777216 yoon.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment yoon.__pga_aggregate_target=654311424 yoon.__sga_target=956301312 yoon.__shared_io_pool_size=0 yoon.__shared_pool_size=402653184 yoon.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/yoon/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/u01/app/oracle/oradata/yoon/control01.ctl','/u01/appCC"Jt/oracle/recovery_area/yoon/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='yoon' *.db_recovery_file_dest='/u01/app/oracle/recovery_area' *.db_recovery_file_dest_size=32212254720 *.db_unique_name='YOON' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=yoonXDB)' *.fal_server='yoondg' *.log_archive_config='dg_config=(yoon,yoondg)' *.log_archive_dest_1='location=/u01/oradata/archive_bak valid_for=(all_logfiles,primary_roles) db_unique_name=yoon' *.CC"/olog_archive_dest_2='service=yoondg lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=yoondg' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='ENABLE' *.memory_target=1606418432 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.star_transformation_enabled='TRUE' *.undo_tablespace='UNDOTBS1'
