X$DIAG% Objects Missing After Database Migration from 32-bit Server to 64-bit Server
(Doc ID 2108285.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
After moving the database from Windows 2003 Server 32-bit to W2008R2 Server 64-bit and changing the word size of the database, tables x$diag% are missing.
Running catadrvw.sql to recreate the ADR views fails with:
ORA- 04063 : view ' sys.v_ $ DIAG_ADR_CONTROL " contains errors
Also issuing next before running the script does not solve the issue:
A 22.214.171.124 database was moved from Windows 2003 Server 32-bit to W2008R2 Server 64-bit and the word size of the database was changed accordingly.
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