CON_ID NAME OPEN_MODE
—— ——— ———-
2 PDB$SEED READ ONLY
3 SALESPDB READ WRITE
4 HRPDB READ WRITE
5 APP_ROOT READ WRITE
6 APP_PDB1 READ WRITE

# 切换到CDB
SQL> ALTER SESSION SET CONTAINER = cdb$root;

Session altered.

# 查看PDB服务
SQL> SELECT service_id, name, network_name, pdb, con_id, creation_date
FROM dba_services
ORDER BY con_id, name;

SERVICE_ID NAME NETWORK_NAME PDB CON_ID CREATION_DATE
———- —————– —————– ———— —— —————–
1 SYS$USERS sys$users CDB$ROOT 1 31-MAR-26
2 orclcdb orclcdb CDB$ROOT 1 31-MAR-26
3 orclcdbXDB orclcdbXDB CDB$ROOT 1 31-MAR-26
4 fgfgfgsalespdb fgfgfgsalespdb SALESPDB 3 31-MAR-26
5 fgfgfgsalespdb_ro fgfgfgsalespdb_ro SALESPDB 3 31-MAR-26
6 hrpdb hrpdb HRPDB 4 31-MAR-26
7 hrpdb_ro hrpdb_ro HRPDB 4 31-MAR-26

# 验证PDB服务查看成功

Session altered.

# 创建PDB服务
SQL> BEGIN
DBMS_SERVICE.CREATE_SERVICE(
service_name => ‘SALES_APP’,
network_name => ‘SALES_APP’
);
END;
/

PL/SQL procedure successfully completed.

# 启动PDB服务
SQL> BEGIN
DBMS_SERVICE.START_SERVICE(
service_name => ‘SALES_APP’
);
END;
/

PL/SQL procedure successfully completed.

# 验证PDB服务创建成功

Session altered.

# 配置服务属性
SQL> BEGIN
DBMS_SERVICE.MODIFY_SERVICE(
service_name => ‘SALES_APP’,
goal => DBMS_SERVICE.GOAL_SERVICE_TIME,
clb_goal => DBMS_SERVICE.CLB_GOAL_SERVICE_TIME,
taf_policy => DBMS_SERVICE.TAF_POLICY_BASIC
);
END;
/

PL/SQL procedure successfully completed.

# 查看服务属性
SQL> SELECT name, goal, clb_goal, taf_policy
FROM dba_services
WHERE name = ‘SALES_APP’
AND con_id = 3;

NAME GOAL CLB_GOAL TAF_POLICY
————- ————– ————– —————-
SALES_APP SERVICE_TIME SERVICE_TIME BASIC

# 验证服务属性配置成功

Session altered.

# 查看服务状态
SQL> SELECT name, status, failover_method, failover_type, failover_retries, failover_delay
FROM dba_services
WHERE name = ‘SALES_APP’
AND con_id = 3;

NAME STATUS FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY
————- ——– ————— ————- —————– ————–
SALES_APP ACTIVE NONE NONE 0 0

# 查看服务连接
SQL> SELECT service_name, count(*) connection_count
FROM v$session
WHERE service_name = ‘SALES_APP’
AND con_id = 3
GROUP BY service_name;

SERVICE_NAME CONNECTION_COUNT
————- —————-
SALES_APP 5

# 验证服务监控配置成功

Session altered.

# 查看PDB服务
SQL> SELECT service_id, name, network_name, pdb, con_id, creation_date
FROM dba_services
WHERE name = ‘SALES_APP’
ORDER BY con_id, name;

SERVICE_ID NAME NETWORK_NAME PDB CON_ID CREATION_DATE
———- ———— ———— ———— —— —————-
8 SALES_APP SALES_APP SALESPDB 3 31-MAR-26

# 测试服务连接
SQL> CONNECT sys/oracle@SALES_APP AS SYSDBA;

Connected.

SQL> SHOW CON_NAME

CON_NAME
——————————
SALESPDB

# 验证服务创建成功

Session altered.

# 查看服务状态
SQL> SELECT name, status, failover_method, failover_type, failover_retries, failover_delay
FROM dba_services
WHERE name = ‘SALES_APP’
AND con_id = 3;

NAME STATUS FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY
————- ——– ————— ————- —————– ————–
SALES_APP ACTIVE NONE NONE 0 0

# 查看服务性能
SQL> SELECT service_name, count(*) session_count,
SUM(physical_reads) physical_reads,
SUM(logical_reads) logical_reads
FROM v$sessstat s, v$session se, v$statname n
WHERE s.statistic# = n.statistic#
AND s.sid = se.sid
AND n.name IN (‘physical reads’, ‘logical reads’)
AND se.service_name = ‘SALES_APP’
AND se.con_id = 3
GROUP BY service_name;

SERVICE_NAME SESSION_COUNT PHYSICAL_READS LOGICAL_READS
————- ————- ————– ————-
SALES_APP 5 500 5000

# 验证服务监控成功