ORA-01220: file based sort illegal before database is open
------------
select * from v$archive_gap
*
ERROR at line 1:
ORA-01220: file based sort illegal before database is open
The issue you have is the one from the note Bug 18411339 - Low performance or ORA-1220 for query on V$ARCHIVE_GAP on 11.2.0.4 or later release ( Doc ID 18411339.8 )
Please check if a patch is available for your version.
If not you can upload the opatch lsinventory -details
Please check if a patch is available for your version.
If not you can upload the opatch lsinventory -details
The Single Patch is now available for Download in 'My Oracle Support'.
So please download and apply Patch No. 18411339 for Linux x86-64 on Top of Oracle 11.2.0.4.0
Just see included README for installation Instructions.
Just let us know if you could install the Patch successfully and if it solved your Problem.
Note that there are no Regression Tests performed against Single Patches, so we strongly recommend to apply and Test this Patch on a Test-Environment before installing in a Production Environment.
So please download and apply Patch No. 18411339 for Linux x86-64 on Top of Oracle 11.2.0.4.0
Just see included README for installation Instructions.
Just let us know if you could install the Patch successfully and if it solved your Problem.
Note that there are no Regression Tests performed against Single Patches, so we strongly recommend to apply and Test this Patch on a Test-Environment before installing in a Production Environment.
No comments:
Post a Comment