Open all PDBs for a CDB in Oracle - 7.1

Talend Real-time Big Data Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Studio

During XStream configuration, if the Oracle database is a container database (CDB), you need to ensure that all pluggable databases (PDBs) in the CDB are in open read/write mode.

To view the open mode of PDBs, connect to the Oracle database as an administrative user and run the following statement.

select con_id, dbid, guid, name, open_mode from v$pdbs;

To open PDBs, connect to the Oracle database as an administrative user and run the following statement.

alter pluggable database all open;