[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;原文链接：https://www.f2er.com/oracle/210230.html
