Thought of penning this post as I thought this issue was quite challenging. We were in the process of upgrading from 11.2.0.1 to 11.2.0.3 PSU 1. However, when we started the db with 11.2.0.3 code tree for upgrade we observed the following error:
startup upgrade;
In the alert log:
Errors in file /oracle/admin/TSECX/diag/rdbms/tsecx/TSECX1/trace/TSECX1_dbw0_9942.trc:
ORA-01157: cannot identify/lock data file 380 - see DBWR trace file
ORA-01110: data file 380: '/oracle/oradata/TSECX/fs01/apps_undots4_16.dbf'
ORA-27048: skgfifi: file header information is invalid
Fix:
I want to cut short the troubleshooting steps. We did too much of troubleshooting. During the troubleshooting we observed that db would come up cleanly with 11.2.0.1 code tree but with 11.2.0.3 it will throw the aforesaid error and about 7 files would show up in v$recover_File view.
We opened the db with 11.2.0.1 code tree and then resized the 7 data files to add about 250MB space to each of the 7 files. Shutdown immediate. Then started the db upgrade with 11.2.0.3 code tree and it worked!
- Aravind Kamath Posral
startup upgrade;
In the alert log:
Errors in file /oracle/admin/TSECX/diag/rdbms/tsecx/TSECX1/trace/TSECX1_dbw0_9942.trc:
ORA-01157: cannot identify/lock data file 380 - see DBWR trace file
ORA-01110: data file 380: '/oracle/oradata/TSECX/fs01/apps_undots4_16.dbf'
ORA-27048: skgfifi: file header information is invalid
Fix:
I want to cut short the troubleshooting steps. We did too much of troubleshooting. During the troubleshooting we observed that db would come up cleanly with 11.2.0.1 code tree but with 11.2.0.3 it will throw the aforesaid error and about 7 files would show up in v$recover_File view.
We opened the db with 11.2.0.1 code tree and then resized the 7 data files to add about 250MB space to each of the 7 files. Shutdown immediate. Then started the db upgrade with 11.2.0.3 code tree and it worked!
- Aravind Kamath Posral
Posts
1 comment:
This just saved me. My upgrade was erroring out just like yours when I tried opening the 11.2.0.3 database on the aux data file. I opened in my 11.2.0.1 ORACLE_HOME, resized the datafile with alter database to a smaller size, went back to my 11.2.0.3 ORACLE_HOME, ran start upgrade; and it opened without error. Has to be a bug but thanks for your post.
Post a Comment