|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
|Oracle RAC||Every instance should use the same value|
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.
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
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.