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",has 1 handler(s) for this service...
Service "4950663e26dec28ce0530c50a8c05578" has 1 instance(s).
  Instance "orcl",has 1 handler(s) for this service...
Service "highgo1" has 1 instance(s).---------->>>注意此处的
  Instance "orcl",has 1 handler(s) for this service...
Service "highgo2" has 1 instance(s).---------->>>注意此处的
  Instance "orcl",has 1 handler(s) for this service...
Service "highgo3" has 1 instance(s).---------->>>注意此处的
  Instance "orcl",has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl",has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl",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,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;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!