Sys Logon Settings

Sys Logon Settings

Variable Name

Meaning

Variable Name

Meaning

SYS_LOGON

Dbvisit Standby does not require an Oracle password as it uses OS authentication. 

These variables can be used to enable Dbvisit Standby to logon as sysdba WITH a username and password. This may be required when SQLNET.AUTHENTICATION_SERVICES = (NTS) cannot be set or a password file cannot be used.

SYS_LOGON turns this feature on and off.

Values are Yes or No

Default is No.

If you are not sure, set to No or leave blank.

Example: 

    SYS_LOGON = Yes

SYS_USER

Name of the user to logon to the database.

Is only affected if SYS_LOGON = Yes

If you are not sure leave blank.

Example:

    SYS_USER = sys

_SYS_PASSWD

Password of SYS_USER.

Is only affective if SYS_LOGON = Yes and SYS_USER is set.

Example:

    _SYS_PASSWD = not_tiger

Note: if ENCRYPT_PASSWDS = Yes, then the password will be encrypted in the DDC file as follows:

    _SYS_PASSWD = ENCRYPT8F87092545A76234

SYS_LOGON_STRING

The logon string to the database. 

Is only affective if SYS_LOGON = Yes and SYS_USER is set.

Default is as sysdba

Example:

    SYS_LOGON_STRING = as sysdba