本文档风哥主要介绍Oracle数据库PDB网络配置相关知识，包括PDB网络配置的概念、方法、要求、规划、配置、验证等内容，由风哥教程参考Oracle官方文档Multitenant内容编写，适合DBA人员在学习和测试中使用，如果要应用于生产环境则需要自行确认。
Part01-基础概念与理论知识
1.1 PDB网络配置的概念
Oracle数据库PDB网络配置是指在多租户容器数据库（CDB）中对PDB级别的网络进行配置和管理，包括监听器配置、服务配置、网络连接配置等。PDB网络配置可以实现PDB级别的网络管理，提高系统可用性。PDB网络配置包括监听器配置、服务配置、网络连接配置、网络监控、网络调优等组件。更多视频教程www.fgedu.net.cn
- 支持PDB级别的网络配置
- 支持监听器配置
- 支持服务配置
- 支持网络连接配置
- 提高系统可用性
1.2 PDB网络配置的方法
Oracle数据库PDB网络配置的方法：
- 监听器配置：配置PDB监听器
- 服务配置：配置PDB服务
- 网络连接配置：配置PDB网络连接
- 网络监控：监控PDB网络
- 网络调优：调优PDB网络
1.3 PDB网络配置的要求
Oracle数据库PDB网络配置的要求：
- PDB架构：必须在PDB架构中配置网络
- 系统资源：足够的CPU、内存和磁盘空间
- 权限：需要PDB的SYSDBA权限
- 兼容性：Oracle数据库版本必须支持PDB网络配置
- 配置：需要配置适当的参数和选项
Part02-生产环境规划与建议
2.1 PDB网络配置规划
Oracle数据库PDB网络配置规划要点：
1. 分析业务需求
2. 评估系统资源
3. 设计PDB网络配置方案
4. 规划PDB网络配置架构
5. 规划监听器配置策略
6. 规划服务配置策略
7. 测试和验证
# 适用场景
– 多租户数据库
– 需要PDB级别网络配置的系统
– 需要监听器配置的系统
– 需要服务配置的系统
– 需要提高可用性的系统
# 不适用场景
– 单租户数据库
– PDB网络配置需求简单的系统
– 低管理需求系统
2.2 PDB网络配置设计
Oracle数据库PDB网络配置设计建议：
– 基于业务需求设计
– 基于资源需求设计
– 最小化网络开销
– 最大化系统可用性
– 合理配置参数
# PDB网络配置设计策略
– 合理规划PDB网络配置架构
– 配置适当的监听器配置
– 配置适当的服务配置
– 配置适当的网络连接配置
– 配置适当的网络监控
# 设计步骤
1. 分析业务需求
2. 评估系统资源
3. 设计PDB网络配置方案
4. 规划PDB网络配置架构
5. 测试PDB网络配置效果
6. 调整配置
2.3 PDB网络配置最佳实践
Oracle数据库PDB网络配置最佳实践：
- 规划PDB网络配置架构：根据业务需求规划PDB网络配置架构，最小化网络开销
- 配置监听器配置：为PDB配置合理的监听器配置
- 监控网络运行：监控PDB网络运行，及时发现和处理问题
- 定期调优：定期调优PDB网络，确保系统性能
- 设置网络告警：设置网络告警，及时发现网络问题
- 定期review：定期review网络配置，优化管理策略
Part03-生产环境项目实施方案
3.1 PDB网络配置实施
3.1.1 查看PDB网络配置
SQL> SELECT con_id, name, open_mode FROM v$pdbs ORDER BY con_id;
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.
# 查看监听器状态
$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl-scan)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 31-MAR-2026 09:00:00
Uptime 1 days 1 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/19c/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/orcl-scan/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl-scan)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “orclcdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “orclcdbXDB” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “fgfgfgsalespdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “hrpdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
The command completed successfully
# 验证PDB网络配置查看成功
3.1.2 配置PDB监听器
$ cat /oracle/app/oracle/product/19c/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orclcdb)
(ORACLE_HOME = /oracle/app/oracle/product/19c)
(SID_NAME = orclcdb)
)
)
# 修改监听器配置
$ vi /oracle/app/oracle/product/19c/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orclcdb)
(ORACLE_HOME = /oracle/app/oracle/product/19c)
(SID_NAME = orclcdb)
)
(SID_DESC =
(GLOBAL_DBNAME = fgfgfgsalespdb)
(ORACLE_HOME = /oracle/app/oracle/product/19c)
(SID_NAME = fgfgfgsalespdb)
)
)
# 重启监听器
$ lsnrctl stop
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl-scan)(PORT=1521)))
The command completed successfully
$ lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Starting /oracle/app/oracle/product/19c/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 19.0.0.0.0 – Production
System parameter file is /oracle/app/oracle/product/19c/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/orcl-scan/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl-scan)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl-scan)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 31-MAR-2026 10:00:00
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/19c/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/orcl-scan/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl-scan)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “orclcdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “orclcdbXDB” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “fgfgfgsalespdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “hrpdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
The command completed successfully
# 验证PDB监听器配置成功
3.2 PDB网络配置配置
3.2.1 配置PDB服务
SQL> ALTER SESSION SET CONTAINER = fgfgfgsalespdb;
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服务
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
# 验证PDB服务配置成功
3.2.2 配置网络连接
$ cat /oracle/app/oracle/product/19c/network/admin/tnsnames.ora
SALES_APP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SALES_APP)
)
)
SALESPDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = fgfgfgsalespdb)
)
)
# 测试网络连接
$ tnsping SALES_APP
TNS Ping Utility for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1997, 2024, Oracle. All rights reserved.
Used parameter files:
/oracle/app/oracle/product/19c/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SALES_APP)))
OK (10 msec)
$ tnsping SALESPDB
TNS Ping Utility for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1997, 2024, Oracle. All rights reserved.
Used parameter files:
/oracle/app/oracle/product/19c/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = fgfgfgsalespdb)))
OK (10 msec)
# 验证网络连接配置成功
3.3 PDB网络配置验证
3.3.1 验证监听器配置
$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl-scan)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 31-MAR-2026 10:00:00
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/19c/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/orcl-scan/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl-scan)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “orclcdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “orclcdbXDB” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “fgfgfgsalespdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “hrpdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “SALES_APP” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
The command completed successfully
# 验证监听器配置成功
3.3.2 验证网络连接
$ sqlplus sys/oracle@SALES_APP AS SYSDBA
SQL*Plus: Release 19.0.0.0.0 – Production on Mon Mar 31 10:00:00 2026
Version 19.24.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.24.0.0.0
SQL> SHOW CON_NAME
CON_NAME
——————————
SALESPDB
SQL> SELECT name, status
FROM dba_services
WHERE name = ‘SALES_APP’
AND con_id = 3;
NAME STATUS
————- ——–
SALES_APP ACTIVE
SQL> EXIT
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.24.0.0.0
# 验证网络连接成功
Part04-生产案例与实战讲解
4.1 PDB网络配置案例
在某企业的生产环境中，需要配置PDB网络配置。
– 数据库版本：Oracle 19c
– 系统规模：中等规模，日交易量100万
– 需求：配置PDB网络配置
# 实施方案
1. 查看PDB
SQL> SELECT con_id, name, open_mode FROM v$pdbs ORDER BY con_id;
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
2. 切换到PDB
SQL> ALTER SESSION SET CONTAINER = fgfgfgsalespdb;
Session altered.
3. 创建PDB服务
SQL> BEGIN
DBMS_SERVICE.CREATE_SERVICE(
service_name => ‘SALES_APP’,
network_name => ‘SALES_APP’
);
END;
/
PL/SQL procedure successfully completed.
4. 启动PDB服务
SQL> BEGIN
DBMS_SERVICE.START_SERVICE(
service_name => ‘SALES_APP’
);
END;
/
PL/SQL procedure successfully completed.
5. 配置TNS连接
$ vi /oracle/app/oracle/product/19c/network/admin/tnsnames.ora
SALES_APP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SALES_APP)
)
)
6. 测试网络连接
$ tnsping SALES_APP
TNS Ping Utility for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1997, 2024, Oracle. All rights reserved.
Used parameter files:
/oracle/app/oracle/product/19c/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SALES_APP)))
OK (10 msec)
# 实施效果
– 成功配置PDB网络配置
– 监听器配置正常
– 服务配置正常
– 网络连接正常
– 系统可用性提高
4.2 PDB网络配置优化案例
在某金融机构的生产环境中，需要优化PDB网络配置，提高网络性能。
– 数据库版本：Oracle 19c
– 系统规模：大规模，日交易量1000万
– 问题：PDB网络配置需要优化
# 优化方案
1. 查看网络配置
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
2. 优化服务配置
SQL> BEGIN
DBMS_SERVICE.MODIFY_SERVICE(
service_name => ‘SALES_APP’,
goal => DBMS_SERVICE.GOAL_THROUGHPUT,
clb_goal => DBMS_SERVICE.CLB_GOAL_LONG,
taf_policy => DBMS_SERVICE.TAF_POLICY_NONE
);
END;
/
PL/SQL procedure successfully completed.
3. 配置网络参数
$ vi /oracle/app/oracle/product/19c/network/admin/sqlnet.ora
SQLNET.EXPIRE_TIME = 10
SQLNET.INBOUND_CONNECT_TIMEOUT = 120
SQLNET.SEND_TIMEOUT = 120
SQLNET.RECV_TIMEOUT = 120
4. 验证优化效果
SQL> SELECT name, status, goal, clb_goal, taf_policy
FROM dba_services
WHERE name = ‘SALES_APP’
AND con_id = 3;
NAME STATUS GOAL CLB_GOAL TAF_POLICY
————- ——– ————– ————– —————-
SALES_APP ACTIVE THROUGHPUT LONG NONE
# 优化效果
– 网络配置优化
– 服务配置优化
– 网络参数优化
– 网络性能提高
4.3 PDB网络配置问题处理
在某电商网站的生产环境中，PDB网络配置出现问题，需要处理。
– PDB网络连接失败
– 监听器启动失败
– 服务连接失败
# 分析步骤
1. 查看监听器状态
$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl-scan)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
2. 查看监听器日志
$ tail -50 /oracle/app/oracle/diag/tnslsnr/orcl-scan/listener/alert/log.xml
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
3. 查看监听器配置
$ cat /oracle/app/oracle/product/19c/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
# 问题原因
– 监听器未启动
– 监听器配置错误
– 端口被占用
# 解决方案
1. 检查端口占用
$ netstat -tuln | grep 1521
tcp 0 0 192.168.1.100:1521 0.0.0.0:* LISTEN
2. 停止占用端口的进程
$ ps -ef | grep tns
oracle 12345 1 0 10:00 ? 00:00:00 tnslsnr LISTENER -inherit
$ kill -9 12345
3. 启动监听器
$ lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Starting /oracle/app/oracle/product/19c/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 19.0.0.0.0 – Production
System parameter file is /oracle/app/oracle/product/19c/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/orcl-scan/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl-scan)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl-scan)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 31-MAR-2026 10:00:00
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/19c/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/orcl-scan/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl-scan)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “orclcdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
Service “fgfgfgsalespdb” has 1 instance(s).
Instance “orclcdb”, status READY, has 1 handler(s) for this service…
The command completed successfully
4. 验证解决效果
$ tnsping SALES_APP
TNS Ping Utility for Linux: Version 19.0.0.0.0 – Production on 31-MAR-2026 10:00:00
Copyright (c) 1997, 2024, Oracle. All rights reserved.
Used parameter files:
/oracle/app/oracle/product/19c/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SALES_APP)))
OK (10 msec)
# 解决效果
– 监听器启动成功
– 网络连接正常
– 服务连接正常
– 系统性能恢复
Part05-风哥经验总结与分享
5.1 PDB网络配置经验
Oracle数据库PDB网络配置经验：
- 规划PDB网络配置架构：根据业务需求规划PDB网络配置架构，最小化网络开销
- 配置监听器配置：为PDB配置合理的监听器配置
- 监控网络运行：监控PDB网络运行，及时发现和处理问题
- 定期调优：定期调优PDB网络，确保系统性能
- 设置网络告警：设置网络告警，及时发现网络问题
- 定期review：定期review网络配置，优化管理策略
5.2 PDB网络配置检查清单
– [ ] 检查系统资源
– [ ] 检查PDB架构
– [ ] 检查网络需求
– [ ] 检查网络配置
– [ ] 检查监听器配置
– [ ] 检查服务配置
– [ ] 规划PDB网络配置架构
– [ ] 配置监听器配置
– [ ] 配置服务配置
– [ ] 验证网络功能
# PDB网络配置问题处理流程
1. 检查系统资源
2. 检查PDB架构
3. 检查网络需求
4. 规划PDB网络配置架构
5. 配置监听器配置
6. 配置服务配置
7. 验证网络功能
8. 处理网络问题
9. 优化配置
10. 监控网络使用情况
5.3 PDB网络配置工具
Oracle数据库PDB网络配置常用工具：
- SQL*Plus：SQL命令行工具，用于执行SQL命令
- Oracle Enterprise Manager：图形化管理工具，用于监控和管理数据库
- SQL Developer：SQL开发工具，用于开发和调试SQL
- LSNRCTL：监听器控制工具，用于管理监听器
- TNSPING：TNS测试工具，用于测试网络连接
- DBMS_SERVICE：PL/SQL包，用于管理服务
本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html
联系我们
在线咨询：
微信号：itpux-com
工作日：9:30-18:30，节假日休息
