Oracle 参数 FORWARD_LISTENER 官方解释，作用，如何配置最优化建议
本站中文解释
FORWARD_LISTENER参数是用来定义RAC的failsafe的角色的，是用来控制有问题的节点被转发到正常节点。它能解决RAC中一些系统问题，帮助控制Oracle故障的节点重定向到工作的不影响的节点。如果有一个节点出现了问题，或者是重新启动数据库时，将把连接传输到另一个节点。
正确设置FORWARD_LISTENER参数非常重要。它必须设置为“ON”，默认值是“OFF”。为了设置FORWARD_LISTENER参数，你必须登录到Oracle服务器，然后以sadia用户身份登录，此时会出现一个脚本窗口。 在此窗口输入：
alter system set forward_listener=ON scope=both;
保存后，必须执行命令：
shutdown immediate;
然后重新启动Oracle服务：
startup;
完成设置。
官方英文解释
FORWARD_LISTENER specifies the name of a listener to which a connection must be forwarded by an existing set of remote listeners.
Examples
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
NULL |
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Basic |
No |
|
Oracle RAC |
A different value can be set on different instances. |
The parameter is useful when it is difficult to change an existing client connect string, for example, after an offsite database has been moved into the Oracle Cloud. With the FORWARD_LISTENER parameter, clients can continue to connect to their offsite listener, and the offsite listener forwards the connection to the Oracle Cloud listener.
Once a forward listener has been configured through the FORWARD_LISTENER parameter, the LOCAL_LISTENER parameter can be cleared by setting its value to -oracle-none- so that all the connections coming to an existing set of remote listeners configured through the REMOTE_LISTENER parameter are forwarded only to listeners configured through FORWARD_LISTENER.
The FORWARD_LISTENER parameter can also be specified in the LISTENER_NETWORKS parameter.
The following setup can be used to forward all the database connections coming to an existing customer SCAN listener to the Oracle Cloud SCAN listener.
REMOTE_LISTENER=customer-scan FORWARD_LISTENER=oracle-cloud-scan LOCAL_LISTENER=oracle-none-
See Also:
-
“LOCAL_LISTENER”
-
“REMOTE_LISTENER”
-
“LISTENER_NETWORKS”
-
Oracle Clusterware
Administration and Deployment Guide for information about SCAN listeners
