Oracle 12.2多租户架构中监听器监听到的数据库服务

[oracle@db12cr2 ~]$ lsnrctl statusLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 08-MAR-2017 01:50:44Copyright (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                08-MAR-2017 01:49:43Uptime                    0 days 0 hr. 1 min. 1 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 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 8 01:56:25 2017Copyright (c) 1982, 2016, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL> show parameter instNAME     TYPE VALUE------------------------------------ ----------- ------------------------------active_instance_count     integercluster_database_instances     integer 1instance_abort_delay_time     integer 0instance_groups      stringinstance_mode     string READ-WRITEinstance_name     string orclinstance_number      integer 0instance_type     string RDBMSinstant_restore      boolean FALSEopen_links_per_instance      integer 4parallel_instance_group      stringSQL> select NAME, DECODE(CDB, 'YES', 'Multitenant Option enabled', 'Regular 12c Database: ') "Multitenant Option ?" , OPEN_MODE, CON_ID from V$DATABASE;NAME  Multitenant Option ?     OPEN_MODE      CON_ID--------- -------------------------- -------------------- ----------ORCL  Multitenant Option enabled READ WRITE    0SQL> exitDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production[oracle@db12cr2 ~]$

值得注意的是:如上的lsnrctl status结果中,可以看到highgo1服务已经被监听到了,但是不代表highgo1这个pdb已经被open.

pdb open还是没open,请使用如下命令查询:

SQL> set lines 300SQL> column NAME format a30SQL> col pdb format a30SQL> select CON_ID, NAME, OPEN_MODE from V$PDBS;

或者:

SQL> show pdbs    CON_ID CON_NAME  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED  READ ONLY  NO 3 HIGHGO1  READ WRITE NO 4 HIGHGO2  MOUNTED 5 HIGHGO3  MOUNTEDSQL>