ORA-55321: network already exists ORACLE 报错 故障修复 远程处理
文档解释
ORA-55321: network already exists
Cause: Attempt to create the network failed because the network already existed.
Action: If necessary, drop the network before trying to recreate the network.
ORA-55321是由于请求的网络已经存在造成的。这是由于该网络或子网已经通过DBMS_NETWORK_ACL_ADMIN.CREATE_NETWORK_ACL被创建。
官方解释
ORA-55321: 请求的网络已经存在
常见案例
当使用 DBMS_NETWORK_ACL_ADMIN.CREATE_NETWORK_ACL 尝试创建已经存在的网络时，会发生此错误。
一般处理方法及步骤
1.尝试查找网络是否存在：
SELECT * FROM DBA_NETWORK_ACLS
WHERE HOST = :host_name
AND LOWER_PORT
AND UPPER_PORT >= :port_num
2.若已存在，可删除此网络：
BEGIN
DBMS_NETWORK_ACL_ADMIN.DELETE_NETWORK_ACL (
acl => :acl_name,
host => :host_name,
low_port => :port_num,
high_port => :port_num);
END;
3.然后重新创建网络：
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_NETWORK_ACL (
acl => :acl_name,
description => :description,
host => :host_name,
lower_port => :port_num,
upper_port => :port_num);
END;
