X$DIAG% Objects Missing After Database Migration from 32-bit Server to 64-bit Server
Last updated on MARCH 07, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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 126.96.36.199 database was moved from Windows 2003 Server 32-bit to W2008R2 Server 64-bit and the word size of the database was changed accordingly.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms