sql> set lines 300 sql> col pdb_name format a30 sql> select pdb_id,pdb_name,dbid,con_uid,guid,status,logging,force_logging,con_id from dba_pdbs; PDB_ID PDB_NAME DBID CON_UID GUID STATUS LOGGING FOR CON_ID ---------- ------------------------------ ---------- ---------- -------------------------------- ---------- --------- --- ---------- 3 HIGHGO1 160143870 160143870 49504EFFCB3FBEECE0530C50A8C043CE NORMAL LOGGING NO 3 2 PDB$SEED 3190971365 3190971365 495000375B91A977E0530C50A8C0EB56 NORMAL LOGGING NO 2 4 HIGHGO2 2222399776 2222399776 4950599A41E6C0B8E0530C50A8C09F64 NORMAL LOGGING NO 4 5 HIGHGO3 3441782034 3441782034 4950663E26DEC28CE0530C50A8C05578 NORMAL LOGGING NO 5 sql> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@db12cr2 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-MAR-2017 01:50:46 Copyright (c) 1991,2016,Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db12cr2)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 15-MAR-2017 01:48:53 Uptime 0 days 0 hr. 1 min. 55 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/db12cr2/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db12cr2)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "49504effcb3fbeece0530c50a8c043ce" has 1 instance(s). Instance "orcl",status READY,has 1 handler(s) for this service... Service "4950599a41e6c0b8e0530c50a8c09f64" has 1 instance(s). Instance "orcl",has 1 handler(s) for this service... Service "4950663e26dec28ce0530c50a8c05578" has 1 instance(s). Instance "orcl",has 1 handler(s) for this service... Service "highgo1" has 1 instance(s). Instance "orcl",has 1 handler(s) for this service... Service "highgo2" has 1 instance(s). Instance "orcl",has 1 handler(s) for this service... Service "highgo3" has 1 instance(s). Instance "orcl",has 1 handler(s) for this service... Service "orcl" has 1 instance(s). Instance "orcl",has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl",has 1 handler(s) for this service... The command completed successfully [oracle@db12cr2 ~]$
