Open all PDBs for a CDB in Oracle - Cloud

Talend Cloud Data Management Platform Studio User Guide

EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Management Console
Talend Studio
task
Design and Development

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;