:

LRM-00109: could not open parameter file

The Problem

You are trying to create an SPFILE from a PFILE and you get the following error:

create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
‘D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\INITTEST.ORA’

The Cause

The SPFILE needs to be in the default location, which on Windows is $ORACLE_HOME\database. On Unix I believe it is $ORACLE_HOME\dbs.

The Solution

Firstly, check where your SPFILE is located as it doesn’t appear to be in the default location on the server. You can check the registry in Windows to see if it has been declared in there.

You can specify both the path to the PFILE and the SPFILE file within the above command so you can be sure to use the correct paths and files. Here is an example:

CREATE SPFILE=’D:\temp\SPFILETEST.ora’ FROM PFILE=’D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\INITTEST.ora’;

Like it, share it...

Category: Database Config


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *