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 ~]$
原文链接:https://www.f2er.com/oracle/210107.html