Today, We came across the different issue while upgrade. Database was successfully opened in 11.2.0.1 but while " Startup Upgrade", it was throwing following errors-
ORA-01157: cannot identify/lock data file 359 - see DBWR trace file
ORA-01110: data file 359: 'apps_undots.dbf'
ORA-27048: skgfifi: file header information is invalid
In alert log we found:
ALTER DATABASE OPEN MIGRATE
Direct NFS: attempting to mount /vol/ORADATA_FS01 on filer defined in mtab
Direct NFS: channel config is:
channel id [0] local [] path ]
Direct NFS: mount complete dir /ORADATA_FS01 Errors in file /oracle/admin//diag/rdbms/ts2ecp/dbw0_20560.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/oracle/oradata/fs01/system_01.dbf'
ORA-17503: ksfdopn:7 Failed to open file /oracle/oradata/fs01/system_01.dbf
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 11174: Unknown system error
Additional information: 7
Additional information: 1795
Additional information: 0
Direct NFS: attempting to mount /vol/ORADATA_FS02 on filer DB-generic10-vfiler112 defined in mtab
Direct NFS: mount complete dir /vol/ORADATA_FS02 on --vfiler112 mntport 4046 nfsport 2049
To resolve this issue we generated STRACE :
strace -fo
ORA-01157: cannot identify/lock data file 359 - see DBWR trace file
ORA-01110: data file 359: 'apps_undots.dbf'
ORA-27048: skgfifi: file header information is invalid
In alert log we found:
ALTER DATABASE OPEN MIGRATE
Direct NFS: attempting to mount /vol/ORADATA_FS01 on filer defined in mtab
Direct NFS: channel config is:
channel id [0] local [] path ]
Direct NFS: mount complete dir /ORADATA_FS01 Errors in file /oracle/admin//diag/rdbms/ts2ecp/dbw0_20560.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/oracle/oradata/fs01/system_01.dbf'
ORA-17503: ksfdopn:7 Failed to open file /oracle/oradata/fs01/system_01.dbf
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 11174: Unknown system error
Additional information: 7
Additional information: 1795
Additional information: 0
Direct NFS: attempting to mount /vol/ORADATA_FS02 on filer DB-generic10-vfiler112 defined in mtab
Direct NFS: mount complete dir /vol/ORADATA_FS02 on --vfiler112 mntport 4046 nfsport 2049
To resolve this issue we generated STRACE :
strace -fo