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", 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 ~]$
关于Oracle Database 12.2 lsnrctl status中的几个servicename --是db的guid
原创wx5bcd90b347f01 ©著作权
©著作权归作者所有:来自51CTO博客作者wx5bcd90b347f01的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Oracle database 12.2的dbca选项
Oracle database 12.2的dbca选项
oracle db 12.2 dbca option -
Oracle Database 12.2 trace文件中的新变化
Oracle Database 12.2 trace文件中的新变化
oracle 12.2 trace oracle linux unix -
关于Oracle Database 12.2的新参数ALLOW_GROUP_ACCESS_TO_SGA
关于Oracle Database 12.2的新参数ALLOW_GROUP_ACCESS_TO_SGA
ALLOW_GROUP_ACCESS_T sga read write oracle -
关于Oracle 12.2 中system密码过期(expire)问题的研究
关于Oracle 12.2 中system密码过期(expire)问题的研究
Oracle 12.2 sys system password expire -
在Windows 10上卸载Oracle Database 12.2
Windows10 下卸载Oracle 12.2
windows 卸载 oracle 12.2 deinstall oracle -
clob字段升级到Oracle DB 12.2的问题
clob字段升级到Oracle DB 12.2的问题
clob oracle 12.2 WE8ISO8859P15 -
Oracle Database 12.2 单机 for rhel6.x的安装要求
Oracle Database 12.2 单机 for rhel6.x的安装要求
Oracle 12cR2 Linux 安装 需求 -
oracle database 启动时的几个错误
oracle database startup error
oracle database startup error -
oracle database的几个小知识点
几个小知识点
5e 十进制 IT