oracle12 监听器,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;