About Oracle SPFile configuration file issues

$ORACLE _sid decided to spfile DBS

Default

At the start of the Oracle database times the error is as follows:

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.1.0 Production on Sat 16 19:43:43 2013

Copyright (c) 1982, Oracle. All rights reserved.

Connected to an idle instance.

Sql> Startup
Ora-01078:failure in processing system parameters
Lrm-00109:could not open parameter file '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora '

Principle: In oracle9i and oracle10g , the database will start the database by default using SPFile , and if spfile does not exist, the above error will occur.

First step: Verify that the boot instance is correct

When we start the data is launched icpdb instance, found that the file is Initorcl.ora (this should be Initicpdb.ora file) Description instance is not imported, you can enter: Echo $ORACLE _sid really is ORCL is not test;

You can find the crux of the problem. So you can export oracle_sid=test again, note that not "export $ORACLE _sid=test" many times will be careless to make such a low-level error. The last database started successfully.

If the above problem is not open the file Inittest.ora, it means that the file does not exist, you can use the second step to solve the problem:

The second step:$ORACLE _base/admin/$ORACLE _sid/pfileinit.ora.0312013174228 copy to /home/oracle/app/oracle/product/11.2.0/dbhome_1/ Dbs/ inittest.ora icpdboracle_sidsid test

[Email protected] pfile]$ cp/home/oracle/app/admin/test/pfile/init.ora.0312013174228/home/oracle/app/oracle/ Product/11.2.0/dbhome_1/dbs/inittest.ora

Then again sqlplus/as SYSDBA Enter, start database startup, and finally succeed

About Oracle SPFile configuration file issues