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