X$DIAG% Objects Missing After Database Migration from 32-bit Server to 64-bit Server (Doc ID 2108285.1)

Last updated on MARCH 07, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

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:

v_$diag_ADR_CONTROL - ORA- 00942 : table or view does not exist
ORA- 04063 : view ' sys.v_ $ DIAG_ADR_CONTROL " contains errors


Also issuing next before running the script does not solve the issue:

 

Changes

A 11.2.0.3 database was moved from Windows 2003 Server 32-bit to W2008R2 Server 64-bit and the word size of the database was changed accordingly.

Cause

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