My Oracle Support Banner

Data Dictionary views are not accessible on PDB database (Doc ID 2633111.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Oracle Multitenant fail to start PDB service as dba_ views are not accessible on PDB

From CDB

SQL> select count(*) from dba_services;

  COUNT(*)
----------
  5

SQL> ALTER SESSION SET CONTAINER = CQ_P1;

Session altered.

SQL> select count(*) from dba_services;
select count(*) from dba_services
  *
ERROR at line 1:
ORA-00942: table or view does not exist


Changes

CDB database was created manually and then PDB was created from the PDB$SEED database.

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
References


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