关于Oracle Database 12.2 lsnrctl status中的几个servicename --是db的guid

来源:互联网 发布:ubuntu 16.04 wine qq 编辑:程序博客网 时间:2024/06/11 06:42
SQL>  set lines 300SQL>  col pdb_name format a30SQL>  select pdb_id,pdb_name,dbid,con_uid,guid,status,logging,force_logging,con_id from dba_pdbs;    PDB_ID PDB_NAMEDBIDCON_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   5SQL> exitDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production[oracle@db12cr2 ~]$ lsnrctl statusLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-MAR-2017 01:50:46Copyright (c) 1991, 2016, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db12cr2)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 12.2.0.1.0 - ProductionStart Date                15-MAR-2017 01:48:53Uptime                    0 days 0 hr. 1 min. 55 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/db12cr2/listener/alert/log.xmlListening 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", status READY, has 1 handler(s) for this service...Service "4950663e26dec28ce0530c50a8c05578" has 1 instance(s).  Instance "orcl", status READY, has 1 handler(s) for this service...Service "highgo1" has 1 instance(s).  Instance "orcl", status READY, has 1 handler(s) for this service...Service "highgo2" has 1 instance(s).  Instance "orcl", status READY, has 1 handler(s) for this service...Service "highgo3" has 1 instance(s).  Instance "orcl", status READY, has 1 handler(s) for this service...Service "orcl" has 1 instance(s).  Instance "orcl", status READY, has 1 handler(s) for this service...Service "orclXDB" has 1 instance(s).  Instance "orcl", status READY, has 1 handler(s) for this service...The command completed successfully[oracle@db12cr2 ~]$ 

0 0
原创粉丝点击