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!

ORA-28304: Oracle encrypted block is corrupt

AndyPolJun 5 2019 — edited Jun 12 2019

Hi

I use Oracle Cloud (OCI instance) 18c Enterprise Edition.

What I did:
create pluggable database NEW_PDB from DEMO keystore identified by XXXXXXXXXX;
alter pluggable database NEW_PDB open read write;


Pluggable database LIFT created.

Pluggable database LIFT altered.

Next I tried connect to Oracle APEX and result was:

ORA-28304: Oracle encrypted block is corrupt (file # 114, block # 34362)

or

When I try run this query (run from NEW_PDB context): select * from user_extents;

ORA-28304: Oracle encrypted block is corrupt (file # 114, block # 57866)

ORA-01110: plik danych 114: '+DATA/ORCL_IAD17H/8A8F01FE272F5F3BE0530300000A825A/DATAFILE/erp_data01.301.1010128283'

28304. 00000 -  "Oracle encrypted block is corrupt (file # %s, block # %s)"

*Cause:    The indicated encrypted block was corrupt. This was an in-memory

           corruption. The exact cause is unknown. Possible causes could be:

           - the encryption wallet is incorrect or corrupted

           - the tablespace encryption key is incorrect or corrupted

           - decryption engine failure

           - actual logical error exists in decrypted block

*Action:   Review the encryption wallet and the keys stored in it to ensure

           they are valid and correct.

Also I checked:
select * from v$database_block_corruption
no rows

Any idea whats wrong ?

BTW.
It worked without any problem 1 month ago : (

This post has been answered by Mark D Powell on Jun 7 2019
Jump to Answer
Comments
Post Details
Added on Jun 5 2019
7 comments
2,852 views