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

最新推荐文章于 2024-02-23 16:14:39 发布

msdnchina

最新推荐文章于 2024-02-23 16:14:39 发布

阅读量1k

点赞数

分类专栏： PostgreSQL Oracle DB 12c新特性文章标签： pdb automatic startup cdb

本文链接：https://blog.csdn.net/msdnchina/article/details/60958309

版权

PostgreSQL 同时被 2 个专栏收录

214 篇文章 1 订阅

订阅专栏

Oracle DB 12c新特性

39 篇文章 8 订阅

订阅专栏

[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>