Validate your New Aternity Database

Use the Aternity Database Verification Utility after you installed the Aternity database, to check that its structure is compatible with Aternity on-premise 9.x.

Use the Aternity Database Verification Utility to ensure the database is ready for Aternity 9.x

This tool requires that you enter the database's username and password with SYSTEM privileges.

Important

When you upgrade Aternity (not clean install), the way you use this tool is different (learn more).

Before you begin

  • Complete deployment of the Aternity Database Server.

    • (Non-DBAs) Use the express database setup for small deployments up to 3000 devices.

    • (DBAs only) Use the custom database setup for larger deployments or to integrate any sized database properly into your enterprise.

  • Ensure you have local administrator privileges on this computer.

  • Ensure you have a username and password to the Oracle database which has SYSTEM privileges. If you cannot obtain SYSTEM credentials, contact Customer Support for a script which your DBA can run separately.

Procedure

  1. Step 1 Download the Aternity Database Verification Utility as part of the package of all Aternity server setup programs.

    Download the latest version of Aternity on-premise from our website. For a fresh installation (only), you can run this utility from any computer which has access to the Database Server.

  2. Step 2 Launch the Aternity Database Verification Utility.

    Right-click and select Run as administrator.

  3. Step 3 Choose a destination directory to install, then proceed.
  4. Step 4 For a fresh install only, you only have one choice to select Verify database settings and privileges.
    For a fresh installation, you can only run one script
  5. Step 5 Enter the details required to connect to the Aternity database to verify its compatibility.

    If your database already has the ATERNITY schema, you can optionally check its validity here. If you do not yet have the schemas, wait until you install the Aternity Management Server, where the setup offers you to automatically create the schemas in the database.

    Enter connection details to the Aternity database
    Field Description
    Username / Password

    Enter the username of the database which has SYSTEM privileges, and its password.

    Database Host

    Enter the hostname, IP address, or DNS name of the Database Server.

    Port

    Enter the port required to access the Database Server (default is 1521).

    Service

    Enter the database service name (usually Aternity). This is the alias to the instance of the Aternity database.

    Verify Platform Database Credentials

    If your database already has the ATERNITY schema, you can optionally check its validity here. If you do not yet have the schemas, wait until you install the Aternity Management Server, where the setup offers you to automatically create the schemas in the database.

    For example, do NOT select this if you had set up the database with the express setup of the Aternity database, or if you have not yet installed the schemas in the database.

    Platform Database Username

    If your database already has the schema set up, it would automatically detect and display ATERNITY as the schema name which you are checking.

  6. Step 6 Select the size of your deployment.

    The parameters of the database are different depending on the size of your deployment, measured as the number of monitored devices. Choose the same size for this screen and the setup of the Management Server.

    The database parameters depend on the intended size of the deployment
  7. Step 7 View the compatibility report.

    You can copy to the clipboard, or view the location to find the report as a plain text file.

    View the report of database compatibility
  8. Step 8 Check the report for errors and fix before continuing with your Aternity on-premise deployment.