Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

startup upgrade ORA-01157: cannot identify/lock data file

Miller - BAEMay 31 2018 — edited Jun 5 2018

I am trying to apply the April 2018 OJVM patch on and Oracle 12.1.2 RAC environment.  The patch applies OK. but when I get to the  startup upgrade step to do the datapatch the startup fails with the following error: 

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '/shared_oradata/MAFPS/system01.dbf'

Post-install datapatch

srvctl stop database -d spfamdb

SQL> startup

SQL> alter system set cluster_database=false scope=spfile;

SQL> quit

srvctl stop database -d spfamdb

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 1.6106E+10 bytes

Fixed Size                  2943408 bytes

Variable Size            2785019472 bytes

Database Buffers         1.3288E+10 bytes

Redo Buffers               30609408 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '/shared_oradata/SPFAMDB/system01.dbf'

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2018
Added on May 31 2018
2 comments
495 views