How to resolve ORA-01078 with LRM 00109 error?
Connect as sysdba in SQL*Plus and execute command “create spfile from pfile”. This command will generate again your server parameter file (spfile) in system which needs to be starting database. Means creating new spfile or pfile will solve error of LRM-00109 error with ORA-01078 error.
How to solve ORA-01078?
startup. Action: Further diagnostic information should be in the error stack. The ORA-01078 error is frequently thrown when you put comments on your initialization parameter file (pfile). Removing the comments (denoted with the # character) from your pfile will often fix the ORA-01078 error.
Why do we create pfile from Spfile?
A PFILE is a traditional text based init. ora parameter file. Typically this resides on the server in the $ORACLE_BASE/admin/SID/pfile directory, with a symbolic link pointing to it from the $ORACLE_HOME/dbs directory. A PFILE is necessary in order to create a SPFILE to enable persistent initialization parameters.
Where is the Pfile located in Oracle 12c?
$ORACLE_HOME/dbs
By default, PFILE is located in $ORACLE_HOME/dbs .
Is Oracle using Spfile?
Oracle provides two different types of parameter files that you can use, PFILE and SPFILE. Since SAP/Oracle recommends using SPFILE over PFILE, I will provide some details on SPFILE to answer your question in more detail. In Oracle9i, a new feature called SPFILE (server parameter file) was introduced.
Where is Pfile located?
By default, PFILE is located in $ORACLE_HOME/dbs .
What does it mean when you get ora-01078 error?
If you get only ORA-01078 then it is indication of wrong parameter configuration. But when you get both error simultaneously is indicating problem of parameter file/server parameter file existence. In this article we can see how error will be generating and how it gets resolved.
What should I do if I have an ora-01157?
ORA -01157:cannot identify/lock datafiles-see DBWR tracefile. can we recover the database it. your datafile was missed, If you have backup, you should restore the datafile at database mount stage and if you have archivelog file after created database , you can able to restore and recover tablespace.
Why is there no init.ora in Oracle DBA?
General reason behind this error is database is running with spfile and there is no init.ora available in system. If Oracle dba execute following command in SQL*Plus for creating spfile.ora (which already there in system but init.ora doesn’t in system).
Where to find startup nomount pfile in Ora?
Startup nomount pfile=c:\\oracle\\product\\10.1.0.3\\database\\initbooktst.ora Once the instance is started, you can start RMAN and restore the SPFILE as seen in this example: Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.