7.24 Changes for Oracle Database Server 18c and 19C

The following changes are required for Oracle Database Server version 18c and 19c:

  1. Shutdown OFSAA services.
  2. Update the sqlnet.ora file with the following parameters and verify the update to ensure no garbage characters and no spaces are there in the beginning or at the end. This is important to check.

    SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

    SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

  3. Restart the listener and database service.
  4. Reset atomic user password on the database.

    The command should be run on the database Server as the sysdba account using the following command:

    alter user SCHEMA_USERNAME identified by SCHEMA_PASSWORD;

    The same password used initially can be used during the reset.

  5. Restart OFSAA services and login as sysadmn user and navigate to the Database Details.
  6. Update the password via the Database Details User Interface and save it.
  7. Start OFSAA services.