My Oracle Support Banner

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 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

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
Changes
Cause
Solution


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