Express Setup for the Database Server (for non-DBAs)

Use the express setup of the Aternity database if you are not a licensed Oracle DBA, or if you have a modest deployment (up to 3000 monitored devices), to quickly and easily install the Aternity Database Server.

Express setup creates the Aternity database automatically

The Aternity Database Server is an Oracle database which houses the Aternity system settings and the performance data.

Tip:

To deploy Aternity for more than 3000 devices, you need a licensed Oracle DBA to use the advanced custom installation to properly integrate the Aternity database into your existing database architecture.

The express database setup requires two zipped archives: the setup files for Oracle 11.2.0.4 gR2, and the setting files of the express database setup.

The express database setup creates an Aternity database in Oracle 11.2.0.4 gR2 only for up to 3000 monitored devices. This version of Oracle is the most widely deployed version today. There is no express database setup which uses Oracle 12.

Before you begin

The Aternity Database Server must be the first server you install when setting up Aternity on-premise, before you install the Aternity Dashboard Server or the Aternity Management Server.

The express database setup only supports deployments up to 3000 monitored devices, and requires the following PC specifications:

Attribute Requirement

Hard disk

System disk (C drive), and an additional logical or physical drive labeled D, with at least 20GB of free storage space.

Operating system for Aternity Database Server

The express database setup requires Windows Server 64 bit 2012 R2.

Set the date and time formats to Control Panel > Regions > Formats > English (United States).

RAM

The express database setup automatically detects the RAM and configures the database:

Network

This server must always use the same static IP address.

Permissions

Ensure you have local administrator privileges on this computer.

Procedure

  1. Step 1 You must download two zipped archives to run the express database setup:

    • The zipped setup files for Oracle 11.2.0.4.

    • The zipped express database setup files, containing:

      • install.bat is the only file you launch to create a new Aternity database. It silently runs the Oracle software setup, and then creates and configures the database.

      • db_install.rsp runs the Oracle setup silently by entering the user inputs automatically (response file).

      • aternity.dbt contains the settings to create the Aternity database (database template file).

      • custom.sql defines some automatic Oracle tasks on the Aternity database.

  2. Step 2 Unzip each setup archive in its own directory on the Database Server, where the pathname does not contain any spaces or special characters.

    Make a note of the pathname to the Oracle file setup.exe.

  3. Step 3 Edit install.bat to point to the pathname of Oracle's setup.exe.

    Near the top of install.bat, look for set inst_location=. Set it to the pathname containing Oracle's setup.exe.

    Set the location of the Oracle setup file
  4. Step 4 Log in to the computer as a local administrator.

    To verify you are a local administrator on this computer, not a domain administrator, open the System control panel, select Advanced system settings > Computer Name, and confirm the Change button is active.

  5. Step 5 Open a command prompt as an administrator.

    Search for cmd on your computer, and on the result, right-click and select Open as Administrator.

    Open the computer's command prompt as an administrator
  6. Step 6 Run the express database setup by launching install.bat.

    The express database setup automatically detects the RAM and configures the database:

    Start the installation
  7. Step 7 Enter y to start installing Oracle with this database configuration.

    The express database setup installs Oracle to D:\oracle\product\11.2.0.4

  8. Step 8 Press any key to close the Oracle installation window and continue creating the Aternity database.

    You can check the log of the Oracle software installation in D:\oracle\product\11.2.0.4\cfgtoollogs\oui.

  9. Step 9 Define passwords for the two mandatory Oracle database users.

    Every Oracle database must have the following two users defined:

    Enter passwords for the Oracle default users
    Field Description
    SYS

    Enter the password for the mandatory internal user called SYS, which owns the core base data in the database. It has SYSDBA privileges.
    SYSTEM

    Enter the password for the SYSTEM user which you can use as a proxy user to access the database as SYSDBA.
    Verify it completes successfully with the message 100% complete.
    View the progress of creating the Aternity database
  10. Step 10 Check the status of the installation in the installation log.

    Open D:\oracle\cfgtoollogs\dbca\aternity\aternity.log and search for Database creation complete, to confirm it was successful. If required, the log for installing the underlying Oracle software is located in D:\Oracle_install.log.

  11. Step 11 Check the status of the Oracle services.

    Open the Windows Task Manager or the Windows Services to check the status of the Oracle services. Verify it displays seven Oracle services, five Running and two Stopped.

    Check the status of the Oracle services in the Windows Task Manager
  12. Step 12 Check the compatibility of the internal structure of the database by verifying the database.