Prompt when starting Oracle: Ora-01078:failure in processing system parameters

Source: Internet
Author: User
Tags sqlplus

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.