Table of contents 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: For 4-10GB RAM, the database supports up to 100 monitored devices. For more than 10GB RAM, the database supports up to 3000 monitored devices. Network This server must always use the same static IP address. Permissions Ensure you have local administrator privileges on this computer. ProcedureStep 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. 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. 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 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. 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 Step 6 Run the express database setup by launching install.bat. The express database setup automatically detects the RAM and configures the database: For 4-10GB RAM, the database supports up to 100 monitored devices. For more than 10GB RAM, the database supports up to 3000 monitored devices. Start the installation 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 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. 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 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. 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 Step 12 Check the compatibility of the internal structure of the database by verifying the database. Set Up a New Aternity Database Server (for DBAs only)Validate your New Aternity DatabaseParent topic: Install Aternity on-premise 9.0.2 / 9.0.3Related tasksSet Up a New Aternity Dashboard ServerSet Up a New Aternity Dashboard Gateway ServerSet Up a New Aternity Management ServerAdd Aternity's Dashboard LayoutsSet Up a New Aternity Data Warehouse Server on a Dedicated PCSet Up a New Aternity Aggregation Server on a Dedicated PC SavePDF Selected topic Selected topic and subtopics All content Related Links
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: For 4-10GB RAM, the database supports up to 100 monitored devices. For more than 10GB RAM, the database supports up to 3000 monitored devices. Network This server must always use the same static IP address. Permissions Ensure you have local administrator privileges on this computer. ProcedureStep 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. 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. 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 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. 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 Step 6 Run the express database setup by launching install.bat. The express database setup automatically detects the RAM and configures the database: For 4-10GB RAM, the database supports up to 100 monitored devices. For more than 10GB RAM, the database supports up to 3000 monitored devices. Start the installation 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 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. 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 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. 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 Step 12 Check the compatibility of the internal structure of the database by verifying the database. Set Up a New Aternity Database Server (for DBAs only)Validate your New Aternity DatabaseParent topic: Install Aternity on-premise 9.0.2 / 9.0.3Related tasksSet Up a New Aternity Dashboard ServerSet Up a New Aternity Dashboard Gateway ServerSet Up a New Aternity Management ServerAdd Aternity's Dashboard LayoutsSet Up a New Aternity Data Warehouse Server on a Dedicated PCSet Up a New Aternity Aggregation Server on a Dedicated PC
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: For 4-10GB RAM, the database supports up to 100 monitored devices. For more than 10GB RAM, the database supports up to 3000 monitored devices. Network This server must always use the same static IP address. Permissions Ensure you have local administrator privileges on this computer. ProcedureStep 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. 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. 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 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. 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 Step 6 Run the express database setup by launching install.bat. The express database setup automatically detects the RAM and configures the database: For 4-10GB RAM, the database supports up to 100 monitored devices. For more than 10GB RAM, the database supports up to 3000 monitored devices. Start the installation 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 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. 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 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. 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 Step 12 Check the compatibility of the internal structure of the database by verifying the database. Set Up a New Aternity Database Server (for DBAs only)Validate your New Aternity DatabaseParent topic: Install Aternity on-premise 9.0.2 / 9.0.3Related tasksSet Up a New Aternity Dashboard ServerSet Up a New Aternity Dashboard Gateway ServerSet Up a New Aternity Management ServerAdd Aternity's Dashboard LayoutsSet Up a New Aternity Data Warehouse Server on a Dedicated PCSet Up a New Aternity Aggregation Server on a Dedicated PC