Oracle 参数 REDO_TRANSPORT_USER 官方解释，作用，如何配置最优化建议
本站中文解释
REDO_TRANSPORT_USER 是控制 Redo Transport Service 发送 redo 日志的一个特殊用户（sysaux表空间上的系统用户），这个用户将会以服务名称的方式连接发出 redo 日志，主要用于 DataGuard 和 Oracle Streams。
正确设置REDO_TRANSPORT_USER参数需要以下几步：
1.确保帐号是已激活的，使用alter user语句：
alter user redo_transport_user account unlock;
2.给予 CREATE SESSION 权限，使用 grant 语句：
grant create session to redo_transport_user;
3.用于把可选的一些参数设置到 Redo Transport
将设置ALTH_SESSION_CACH_SIZE 并设到适当的值
Alter system set ALTH_SESSION_CACH_SIZE = 4194304 scope=memory;
4.预计将 REDO_TRANSPORT_USER 做为 Data Transport Layer（DTL）的发件人
Alter system set dg_broker_start=true;
官方英文解释
REDO_TRANSPORT_USER specifies the name of the user whose password verifier is used when a remote login password file is used for redo transport authentication. This user must have the SYSOPER privilege and must have the same password in the database that initiates the redo transport session and in the database that is the target of the redo transport session.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
There is no default value. |
|
Range of values |
Any character string that matches the name of a user who has been granted the |
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Basic |
No |
|
Oracle RAC |
Every instance should use the same value |
The value of this parameter is case sensitive and must exactly match the value of the USERNAME column of a row in the V$PWFILE_USERS view. The value of the SYSOPER column of the row must also be TRUE.
If this parameter is not specified, then the password verifier of the SYS user will be used when a remote login password file is used for redo transport authentication.
See Also:
Oracle Data Guard Concepts
and Administration for more information about this parameter
