Oracle 12cR1 RAC Creating Services with PDBs(五)
ONLINE zhongwc2 STABLE
ora.ons
ONLINE ONLINE zhongwc1 STABLE
ONLINE ONLINE zhongwc2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE zhongwc1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE zhongwc1 169.254.198.87 172.1
68.1.31,STABLE
ora.cvu
1 ONLINE ONLINE zhongwc1 STABLE
ora.mgmtdb
1 ONLINE ONLINE zhongwc1 Open,STABLE
ora.oc4j
1 ONLINE ONLINE zhongwc1 STABLE
ora.scan1.vip
1 ONLINE ONLINE zhongwc1 STABLE
ora.zhongwc1.vip
1 ONLINE ONLINE zhongwc1 STABLE
ora.zhongwc2.vip
1 ONLINE ONLINE zhongwc2 STABLE
ora.zwc.crm.svc
1 ONLINE ONLINE zhongwc1 STABLE
ora.zwc.db
1 ONLINE ONLINE zhongwc1 Open,STABLE
2 ONLINE ONLINE zhongwc2 Open,STABLE
ora.zwc.erp.svc
1 ONLINE ONLINE zhongwc2 STABLE
--------------------------------------------------------------------------------
Creating Net Service Names for PDBs
[oracle@zhongwc1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ZWC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zhongwc-cluster-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zwc)
)
)
crm_zhongwc1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zhongwc-cluster-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = crm)
)
)
erp_zhongwc1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zhongwc-cluster-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = erp)
)
)
[oracle@zhongwc1 ~]$ sqlplus sys@crm_zhongwc1 as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Mon Oct 14 20:39:29 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL>
show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 ZHONGWC1 READ WRITE NO
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
[oracle@zhongwc1 ~]$ sqlplus sys@erp_zhongwc1 as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Mon Oct 14 20:39:49 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 ZHONGWC1 READ WRITE NO
SQL> conn sys@erp_zhongwc1 as sysdba
Enter password:
Connected.
SQL> select name,pdb from dba_services;
NAME PDB
----------