Tuesday, February 23, 2010

ORA-01078 Failure in processing system parameters

ORA-01078 Failure in processing system parameters

Possible Causes and Solutions

Several possible causes (generally followed by another error message):

• The parameter file could not be opened (followed by an LRM-00109 error message). Check that the parameter file exists, and that it can be opened and read by the database executable. By default, the database expects the parameter file to be in ORACLE_HOME/dbs (this is port-specific, however; for example, Windows expects it to be in $ORACLE_HOME/database by default).

• An unknown parameter may be included in the parameter file (error LRM-00101 also appears). Correct the unknown parameter and restart the database.

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...