12cr2 监听问题

wangjianhero · 发表于 2018-3-22 09:03

今天看到监听状态里面出现 Service "664055a8222c9b5de053550a1e0a8168" 等三条信息，不知道这是啥，曾经删除创建过pdb但是没有用这个名称，有大佬解释下吗
[oracle@12c ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-MAR-2018 08:46:30

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=12c)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date             22-MAR-2018 08:45:29
Uptime                   0 days 0 hr. 1 min. 1 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Listener Log File       /u01/app/oracle/diag/tnslsnr/12c/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12c)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=12c)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/cdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12c)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "664055a8222c9b5de053550a1e0a8168" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "6640565697b69bc1e053550a1e0a6a2d" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "66683c33d8761a15e053550a1e0a2618" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "66683c33d8771a15e053550a1e0a2618" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "cdb" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "cdbXDB" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb1" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb2" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb3" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb4" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
The command completed successfully

[oracle@12c ~]$ cat /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 12c)(PORT = 1521))
)
  )

lfree · 发表于 2018-3-22 09:32

每个pdb会有1个uuid之类的标识,是否跟这个有关.

wangjianhero · 发表于 2018-3-22 16:32

本帖最后由 wangjianhero 于 2018-3-22 16:46 编辑

lfree 发表于 2018-3-22 09:32
每个pdb会有1个uuid之类的标识,是否跟这个有关.

大佬您的意思是每个pdb都会有类似的显示信息吗查了一下果然如您所说  dba_pdbs中 pdb的GUID 对应监听文件中service信息
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 PDB1    1606915542 1606915542 664055A8222C9B5DE053550A1E0A8168 NORMAL    LOGGING NO    3
   2 PDB$SEED    801994243  801994243 66404687D89D95BEE053550A1E0A7D51 NORMAL    LOGGING NO    2
   4 PDB2    1383869534 1383869534 6640565697B69BC1E053550A1E0A6A2D NORMAL    LOGGING NO    4
   8 PDB4    1685121265 1685121265 66683C33D8761A15E053550A1E0A2618 NORMAL    LOGGING NO    8
   5 PDB3    2814272539 2814272539 66683C33D8771A15E053550A1E0A2618 NORMAL    LOGGING NO    5

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@12c ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-MAR-2018 16:26:31

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=12c)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date             22-MAR-2018 08:45:29
Uptime                   0 days 7 hr. 41 min. 2 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Listener Log File       /u01/app/oracle/diag/tnslsnr/12c/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12c)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=12c)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/cdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12c)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "664055a8222c9b5de053550a1e0a8168" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "6640565697b69bc1e053550a1e0a6a2d" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "66683c33d8761a15e053550a1e0a2618" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "66683c33d8771a15e053550a1e0a2618" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "cdb" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "cdbXDB" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb1" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb2" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb3" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
Service "pdb4" has 1 instance(s).
  Instance "cdb", status READY, has 1 handler(s) for this service...
The command completed successfully

zergduan · 发表于 2018-3-22 17:12

这个service你不要用，这是cdb和pdb之间用的，你不需要管理，也不要使用~
另外如果你用ASM OFM，就会发现pdb的文件目录也是GUID

wangjianhero · 发表于 2018-3-22 17:19

zergduan 发表于 2018-3-22 17:12
这个service你不要用，这是cdb和pdb之间用的，你不需要管理，也不要使用~
另外如果你用ASM OFM，就会发现p ...

刚才尝试使用这个service 可以连接到pdb。斑竹可以解释一下不能使用的原因吗

		自动登录
密码			注册

[体系架构] 12cr2 监听问题