环境:
OS:Oracle Linux Server release 5.6
DB:oracle11.2.0.1
1.删除spfile及pfile;
[oracle@itkaifang trace]$ cd [oracle@itkaifang ~]$ cd $ORACLE_HOME/dbs [oracle@itkaifang dbs]$ ls hc_DBUA0.dat lkITKAIFAN orapwitkaifang hc_itkaifang.dat init.ora lkITKAIFANG spfileitkaifang.ora [oracle@itkaifang dbs]$ rm spfileitkaifang.ora [oracle@itkaifang dbs]$ ls hc_DBUA0.dat lkITKAIFAN orapwitkaifang hc_itkaifang.dat init.ora lkITKAIFANG
2. 重启报错;
itkaifang@SYS> 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/inititkaifang.ora'
3. vi创建pfile文件,通过查看alert跟踪日志找到数据库正常启动的参数信息;
3.1 alert跟踪日志找到的内容:
processes = 150
memory_target = 796M
control_files = "/u01/app/oracle/oradata/itkaifang/control01.ctl"
control_files = "/u01/app/oracle/oradata/itkaifang/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=itkaifangXDB)"
local_listener = ""
job_queue_processes = 1000
audit_file_dest = "/u01/app/oracle/admin/itkaifang/adump"
audit_trail = "DB"
db_name = "itkaifan"
db_unique_name = "itkaifang"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
3.2 在原参数文件路径:$ORACLE_HOME/dbs下创建init(SID).ora的pfile文件内容为以上找到的内容;
[oracle@itkaifang trace]$ cd $ORACLE_HOME/dbs [oracle@itkaifang dbs]$ ls hc_DBUA0.dat hc_itkaifang.dat init.ora lkITKAIFAN lkITKAIFANG orapwitkaifang [oracle@itkaifang dbs]$ vi inititkaifang.ora
4.以新建的pfile文件打开数据库并open;
itkaifang@SYS> startup nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/inititkaifang.ora' ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2217912 bytes Variable Size 490735688 bytes Database Buffers 335544320 bytes Redo Buffers 2433024 bytes itkaifang@SYS> alter database mount; Database altered. itkaifang@SYS> alter database open; Database altered.