Oracle Linux# sqlplus sys as sysdba

 

 

SELECT STATUS FROM V$INSTANCE;

SQL> startup;

ORACLE instance started.

 

Total System Global Area 2.0133E+10 bytes

Fixed Size                  9145824 bytes

Variable Size            7784628224 bytes

Database Buffers         1.2281E+10 bytes

Redo Buffers               57962496 bytes

Database mounted.

Database opened.

SQL> SELECT STATUS FROM V$INSTANCE;

 

STATUS

------------

OPEN

 

 

SQL> ALTER PLUGGABLE DATABASE <<SEU BANCO>> OPEN;

 

Pluggable database altered.

 

 

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

 

Oracle Linux#  lsnrctl start

 

==> ATUALIZANDO :

PARA LISTAR OS  pluggabledatabases

SQL> select PDB_NAME from DBA_PDBS order by pdb_id

 

UMA DICA APÓS TER LEVANTANDO O BANCO TUDO RODANDO SALVE O ESTADO DO PLUBBABLEDATABASES

(ISSO VAI PERMITIR QUE AO SER REINICIADO O BANCO VOLTE SEM INTERVENÇÃO)

alter pluggable database ALL save state;

 

-- Verificando o estado salvo dos pluggabledatabases

SQL> select con_name, instance_name, state, restricted from dba_pdb_saved_states;

-- Verificando o estado corrente dos pluggabledatabases

SQL> show pdbs

 

https://www.oracle.com/br/technical-resources/articles/database-performance/dos-pluggabled-databases.html