My Oracle Support Banner

System, Sysaux, Undo, Temp tablespaces have different mkeyid (Doc ID 2797278.1)

Last updated on AUGUST 17, 2021

Applies to:

Advanced Networking Option - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

In production Database, the root container (con_id=1) has different mkeyid
for SYSAUX, UNDO tablespaces ( which is missing from the wallet file) and a
different mkeyid for SYSTEM, TEMP tablespaces ( which is found in wallet
file).

Customer mentioned that they faced some OS permission issues in their
production DB while they implemented TDE ( while executing 'set key' command)
and they re-executed 'set key' command few times on production DB root
container and this caused the mismatch mkeyids of SYSTEM, SYSAUX, UNDO, TEMP
tablespaces.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.