First, the use of the environment
Operating system: CentOS Release 6.2 (Final)
Database: Oracle 12g
Database home directory:/ora12/product/product/12.1.0/db_1
Ii. Description of the problem
After logging in to sqlplus with the SYS user, prompt when starting Oracle with the startup command:
Ora-01078:failure in processing system parameters
Lrm-00109:could not open parameter file '/ora12/product/product/12.1.0/db_1/dbs/initora12.ora '
Iii. Causes of Errors
In the last few versions of Oracle9i, 10g, 11g, the database uses SPFile to start the database by default, and if SPFile does not exist, the above error occurs.
Iv. Methods of Solution
Method One:
1. Use the Find/ora12-name pfile command to find the location of the Pfile file,/ora12/product/admin/cvte63/pfile into the folder, view the file
2. Copy the init.ora.6420171848 form of the file in the $oracle_base/admin/cvte63/pfile directory to the $oracle_home/dbs directory under the name Initora12.ora.
(Note: orcl12 in Initora12.ora is your instance name Oracle_sid, here my SID is: ora12)
Method Two:
Rename the $oracle_home/dbs directory Spflieorcl.ora to Spfilecenter.ora. (Note: Ora12 in Spfilecenter.ora is the SID set in the environment variable, mine is Ora12)
Oracle User Login Sqlplus "/as sysdba"
Sql> Startup
Prompt when starting Oracle: Ora-01078:failure in processing system parameters