SYS@orcl1> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB01 READ WRITE NO
SYS@orcl1> alter session set container=pdb01;
Session altered.
SYS@orcl1> show con_name
CON_NAME
------------------------------
PDB01
SYS@orcl1> show user
USER is "SYS"
二、TNS本地监听连接（TNS配置单节点IP）
代码语言：javascript复制
[oracle@p19c01 ~]$ cd $ORACLE_HOME/network/admin
[oracle@p19c01 admin]$ ls
samples shrept.lst tnsnames.ora
[oracle@p19c01 admin]$ vim tnsnames.ora
[oracle@p19c01 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.3.0/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = p19c-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
PDB01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = p19c01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb01)
)
)
[oracle@p19c01 admin]$ sqlplus admin/oracle@pdb01
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Mar 20 06:06:05 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
ADMIN@pdb01> show user
USER is "ADMIN"
ADMIN@pdb01> show con_name
CON_NAME
------------------------------
PDB01
三、RAC添加SERVICE通过SCAN访问PDB
代码语言：javascript复制
Usage: srvctl add service -db -service "" -update {-preferred "" | -available ""} [-force] [-verbose]
-db Unique name for the database
-service "" Comma separated service names
-update Add a new instance to service configuration
-preferred Name of new preferred instance
-available Name of new available instance
-force Force the add operation even though a listener is not configured for a network
-verbose Verbose output
-help Print usage
--集群添加service
[oracle@p19c01 ~]$ srvctl add service -d orcl -s spdb01 -pdb pdb01 -preferred orcl1 -available orcl2
[oracle@p19c01 ~]$ srvctl config service -d orcl -s spdb01
Service name: spdb01
Server pool:
Cardinality: 1
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type:
Failover method:
Failover retries:
Failover delay:
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name: pdb01
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: orcl1
Available instances: orcl2
CSS critical: no
--TNS添加SPDB01
[oracle@p19c01 ~]$ cd $ORACLE_HOME/network/admin
[oracle@p19c01 admin]$ cat tnsnames.ora
SPDB01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = p19c-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = spdb01)
)
)
--启动service
[oracle@p19c01 admin]$ srvctl start service -d orcl -s spdb01
[oracle@p19c01 admin]$ lsnrctl stat
Service "spdb01" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
--连接pdb01
[oracle@p19c01 admin]$ tnsping spdb01
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 20-MAR-2021 06:41:43
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = p19c-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = spdb01)))
OK (0 msec)
[oracle@p19c01 admin]$ sqlplus admin/oracle@spdb01
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Mar 20 06:41:53 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Sat Mar 20 2021 06:06:05 08:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
ADMIN@spdb01> show user
USER is "ADMIN"
ADMIN@spdb01> show con_name
CON_NAME
------------------------------
PDB01
