services for pluggable database in 19c

 command for pluggable database services.

COLUMN NAME FORMAT A12;

SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;

show pdbs;

alter session set container=PDB01;

check the services for pluggable database:

COLUMN NAME FORMAT A15;

COLUMN NETWORK_NAME FORMAT A15;

SELECT NAME,NETWORK_NAME FROM DBA_SERVICES;

other network name

lsnrctl status|grep -i pdb01 -A 1

srvctl status service -d CDBAMN   //check the service for container database.

lsnrctl status|grep -i SOA -A 1   // soa is service name

crsctl stat res ora.cdbamn.soa.svc -t

crsctl stat res ora.cdbamn.db -t

FRa space:

column SPACE_LIMIT_Gb format 999;

column SPACE_USED_Gb format 999;

select name, SPACE_LIMIT/1024/1024/1024 SPACE_LIMIT_Gb, SPACE_USED/1024/1024/1024 SPACE_USED_Gb, SPACE_RECLAIMABLE from v$recovery_file_dest;