Connecting to the SQL Database
Upon startup, the SQL authentication module connects to the database, using settings specified by a connect string specified in the configuration file. The connect string contains information such as the name and location of the database, and the password required to connect. The connect string is passed to the database client to establish the connection.
While a sample connect string is provided in the original configuration file, you must configure the Connect entry of the configuration file with a connect string appropriate to your database.
The password for database access must be provided as part of the connect string. If it is not, the connection fails.
If the initial attempt to connect to the database fails, or if a processing error occurs that the SQL authentication module interprets as a database connection failure, the SQL authentication module drops the connection and attempts to establish a new connection after a period of time. In the interim, all authentication requests are ignored.
The SQL authentication module uses an exponential back-off strategy in determining how long to wait before attempting a new connection, as well as how frequently this attempt is made. After the first dropped connection, it waits a certain amount of time before attempting to reconnect. If this attempt to reconnect also fails, it waits for twice the amount of time before trying again; and so on, up to some maximum wait time. The initial and maximum wait times are configurable.
Detailed error information may not be available if there is an error processing the database logon at connect time. A numeric result code is displayed in the log. You may need to refer to product-specific documentation to decode this result code. With Oracle on Solaris, you can use the oerr facility-code error-number command with a facility code of oerr from the command shell.