ORA-01078 And LRM-00109 Starting Database (On 12c)

When starting a database, which is in version 12c, aperece the following error;

SQL> startup
ORA-01078: failure in processing system parameters 
LRM-00109: could not open parameter file ‘C:\ORACLE\DB_1\DATABASE\INITSITO.ORA’

It seems that missed init.ora. Fortunately or rather a rule I usually have contfolfile autobackup, so this case is simple bastantante solve the problem. We must connect to RMAN and execute the following commands.

 rman> STARTUP NOMOUNT
 rman> RESTORE SPFILE FROM AUTOBACKUP

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s