REDO_TRANSPORT_USER


Property Description

Parameter type

String

Syntax

REDO_TRANSPORT_USER = user_name

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 SYSDBA or SYSOPER privilege

Modifiable

ALTER SYSTEM

Basic

No

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 SYSDBA or 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 SYSDBA or 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