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

[oracle@db12cr2 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 08-MAR-2017 01:50:44 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 08-MAR-2017 01:49:43 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/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 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 8 01:56:25 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show parameter inst NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ active_instance_count integer cluster_database_instances integer 1 instance_abort_delay_time integer 0 instance_groups string instance_mode string READ-WRITE instance_name string orcl instance_number integer 0 instance_type string RDBMS instant_restore boolean FALSE open_links_per_instance integer 4 parallel_instance_group string SQL> 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 0 SQL> exit Disconnected 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 300 SQL> column NAME format a30 SQL> col pdb format a30 SQL> 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 MOUNTED SQL>