LRM-109: Could Not Open Parameter File [ID 734930.1]

LRM-109: Could Not Open Parameter File [ID 734930.1]

---

 修改时间 19-DEC-2011     类型 PROBLEM     状态 PUBLISHED 

In this Document
  Symptoms
  Cause
  Solution

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.3 - Release: 10.1 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 19-Dec-2011***

Symptoms

You are trying to startup the database and you are receiving errors as follows:

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/init+fdrp1.ora' 
SQL>

The key to identifying this problem is init+fdrp1.ora. 

NOTE:
The + sign included in the name would indicate an ASM file.

Cause

The problem was actually the result of an incorrect entry in the .profile file for the user and system as follows: SID=+fdrp1

The issue can be easily reproduced with the following

Test Case

$ . oraenv
ORACLE_SID = [v1120] ?
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle

--  Change $ORACLE_SID to an invalid value:

$ export ORACLE_SID=+v1120

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 19 08:23:14 2011

Copyright (c) 1982, 2009, 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 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/init+v1120.ora'
SQL>


NOTE:
On Windows, an invalid %ORACLE_SID% will normally result in the next error

ERROR:
ORA-12560: TNS:protocol adapter error

Solution

Edit the .profile to change the SID to the correct value excluding the + sign.

After changing the SID value in the profile file, log out and log back in for settings to take effect. To be sure the new value is loaded, type echo $ORACLE_SID from the prompt on Linux-based systems.

At the command prompt on Windows systems type in the word set and verify that the correct value is present for ORACLE_SID.