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

前端之家收集整理的这篇文章主要介绍了关于Oracle Database 12.2 lsnrctl status中的几个servicename --是db的guid前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
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

猜你在找的Oracle相关文章