关于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
- 关于Oracle Database 12.2 lsnrctl status中的几个servicename --是db的guid
- 理解 oracle 的 "lsnrctl status"
- 理解 oracle 的 “lsnrctl status”
- lsnrctl 中 关于status 状态的说明
- oracle监听器启动lsnrctl status例程的状态为unknown
- Oracle Lsnrctl - 关于oracle监听器的命令和解释
- Oracle Lsnrctl - 关于oracle监听器的命令和解释
- Oracle Lsnrctl - 关于oracle监听器的命令和解释
- lsnrctl status看不到监听注册的实例
- 关于myeclipse中的DB Browser连接Oracle数据库的问题
- 关于ORACLE的GUID主键生成
- tnsping orcl;lsnrctl status
- oracle database的几个小知识点
- 几个关于database mail的表
- Oracle LSNRCTL------监听器的启动和关闭
- LSNRCTL-命令行控制oracle的监听器
- Oracle lsnrctl--监听器的启动和关闭
- 关于lsnrctl 的简写字母组合
- 菜鸟学习Python+Selenium遇到的第一个要崩溃的问题
- android IntentService详解
- 221. Maximal Square
- c语言顺序结构设计课堂笔记
- 体系图
- 关于Oracle Database 12.2 lsnrctl status中的几个servicename --是db的guid
- Android---stateLayout在不同的界面间切换
- vertical-align垂直居中
- Windows下python获取剪切板的内容
- Spring Boot application.properties或application.yml相关配置
- Pdf File Writer 中文应用(PDF文件编写器C#类库)
- 自定义控件(二)--广告轮播
- emgucv 求n个点两两之间的距离
- oracle中调用存储过程