[HAController]
|
Description
|
Mandatory
|
Factory value
|
---|---|---|---|
ApplicationConnTestPassword
|
Password for the user that is identified by the ApplicationConnTestUsername parameter.
If EnableApplicationConnCheck is set to yes and the value for this parameter is not set, the value of DBPassword is used.
|
No
|
|
ApplicationConnTestUsername
|
User name for the connections that are used in application connection tests (when EnableApplicationConnCheck is set to yes).
If EnableApplicationConnCheck is set to yes and the value for this parameter is not set, the value of DBUsername is used.
|
No
|
|
HAController.AutoEncryptPasswords
|
By default the password parameters in solidhac.ini, Password, DBPassword, and ApplicationConnTestPassword, will be encrypted when HAC starts, replacing the plain text information in solidhac.ini.
|
Yes
|
No
|
CheckInterval
|
Interval (in milliseconds) between consecutive non-blocking SQLConnect commands.
The value does not affect the failover time. Checking (polling) takes place typically after failure or during system startup.
Value must be a positive integer.
|
No
|
1000
|
CheckTimeout
|
Timeout (in milliseconds) between consecutive non-blocking SQLConnect commands in CHECK mode.
Very small values tend to cause "false positives". That is, a server seems to be failed, although it is running, but was not able to respond within the timeout period.
Value must be a positive integer.
|
No
|
150
|
DBPassword
|
Password for user that is identified by the DBUsername parameter.
|
Yes
|
|
DBUsername
|
User name for the local HotStandby server to which the HAC connects.
The database user should have either SYS_ADMIN_ROLE, or SYS_CONSOLE_ROLE.
|
Yes
|
|
EnableAutoNetcopy
|
If set to yes, the HAC can initiate a netcopy when a HSB link cannot be established with the ADMIN COMMAND 'hsb connect' command.
|
No
|
yes
|
EnableDBProcessControl
|
If set to yes, the HAC can manage the local server process by automatically starting the server, and by providing the user with commands to shutdown and restart the database process.
The parameter is only effective if the HAC is in the AUTOMATIC mode.
Note Setting EnableDBProcessControl to yes makes the StartScript parameter in the [LocalDB] section mandatory.
|
No
|
no
|
Listen
|
Protocol and the port that the High Availability Controller (HAC) uses for communication with the High Availability Manager (HAM) or the solidDB utilities such as solsql and solcon.
For example, Listen=tcp 3135.
▪ The only supported protocol is TCP/IP ('tcp').
▪ If listening cannot be started, for example, because the port is used by another process, the information is written to the log file (hacmsg.out), followed by the termination of HAC.
|
Yes
|
|
NetcopyErrorLevel
|
Number of times an 'hsb netcopy' operation followed by an 'hsb connect' operation can fail before an error message is printed to the hacmsg.out file and HAC is switched to ADMINISTRATIVE mode.
After you have fixed the problem, switch HAC back to the AUTOMATIC mode by issuing the following command:
ADMIN COMMAND 'hacontroller setautomatic'.
The value of the parameter must be a positive 64-bit integer.
|
No
|
10
|
NetcopyWarningLevel
|
Number of times an 'hsb netcopy' operation followed by an 'hsb connect' operation can fail before a warning message is printed to the hacmsg.out file.
The value of the parameter must be a positive 64-bit integer.
|
No
|
3
|
Password
|
Password for the user that is identified by the Username parameter.
The password can begin with any letter, underscore, or number. Use lowercase letters from a to z, uppercase letters from A to Z, the underscore character "_", and numbers from 0 to 9.
|
Yes
|
|
RequiredConnectFailures
|
Number of consecutive failed connect attempts that are required before the server is considered to have failed.
When a server state is unknown, or the HAC needs to ensure the state of the server, the non-blocking SQLConnect (check) command is used. If the execution of non-blocking SQLConnects fails, the command is repeated this number of times before the server in question is considered non-responsive.
Value must be a positive integer.
|
No
|
1
|
StartInAutomaticMode
|
Whether the HAC starts execution in automatic mode.
▪ If set to yes (AUTOMATIC mode), HAC automatically tries to maximize the availability by changing the HSB states of the server, and restarting the server processes when necessary.
▪ If set to no (ADMINISTRATIVE mode), HAC only monitors the health of the servers.
The parameter can be changed dynamically.
Note See also, the PreferredPrimary parameter in the [LocalDB] section; the PreferredPrimary parameter is effective only if the StartInAutomaticMode parameter is set to yes.
|
No
|
yes
|
Username
|
User name for HAC.
The user name must begin with a letter or an underscore. Use lowercase letters from a to z, uppercase letters from A to Z, the underscore character "_", and numbers from 0 to 9.
See also Password.
|
Yes
|
|