X$DIAG% Objects Missing After Database Migration from Windows 32-bit Server to 64-bit Server
(Doc ID 2108285.1)
Last updated on OCTOBER 03, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Microsoft Windows x64 (64-bit)
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
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 as select * from x$diag_ADR_CONTROL;
v_$diag_ADR_CONTROL as select * from x$diag_ADR_CONTROL
*
ERROR at line 2:
ORA-00942: table or view does not exist
SQL>create or replace public synonym
v$diag_ADR_CONTROL for v_$diag_ADR_CONTROL;
Synonym created.
SQL> grant select on v_$diag_ADR_CONTROL to dba;
grant select on v_$diag_ADR_CONTROL to dba
*
ERROR at line 1:
ORA-04063: view "SYS.V_$DIAG_ADR_CONTROL" has 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 |