Reconnect to Oracle fails: "Status 4036".


 Product:MicroStation
 Version:08.11.07.443
 Environment:N\A
 Area:Database
 Subarea:Oracle

Problem

Reconnect to Oracle fails: "Status 4036"

When starting MicroStation, there is no problem connecting to an Oracle database.
However when the database is disconnected and the user tries to reconnect in the same session, the following error message is shown:

"Status 4036"

Upon restarting MicroStation, connecting to the database works without problems again.

Solution

Check SQLNET.AUTHENTICATION_SERVICES parameter setting.

The parameter SQLNET.AUTHENTICATION_SERVICES in the file: sqlnet.ora (locationTNS_ADMIN environment variable first, then ORACLE_HOME/network/admin) specifies the Oracle Advanced Security Authentication method.
To allow reconnection during the session, correct that parameter to reflect the authentication method used.
By setting that parameter to NONE, Oracle Advanced Security Authentication is disabled, allowing access to the database.
Further details on the authentication can be found in the Oracle Database Advanced Security Administrator's Guide.

See Also

Other language sources

 Original Author:Bentley Technical Support Group