Task 5: Installing the database schema (Linux)
System: Database Server
This section covers the creation of the IT Analytics database. Follow these steps on the same server you installed the Oracle application binaries.
Note:
This step is required only if you have not opted to run as a part of the Itanalyticsinstaller.sh script.
Log in as to your IT Analytics Database server.
You must be logged in as a database user. If you already are logged in as root:
su - aptare
source <INSTALL_PATH>/aptare/bin/aptare_env.sh
Run the database installation script to install the IT Analytics database objects and schema:
mnt/portal/create_itanalytics_database.sh
Note:
The following dialog will only appear if you are re-installing the IT Analytics database (e.g., after a failed attempt)
The installer launches and prompts you to enter the domain name:
Enter your IT Analytics Portal Domain Name: yourcompany.com You entered the following of your IT analytics domain name: yourcompany.com Your IT Analytics Super User Login Account will be admin@yourdomain Is this the correct domain name (y/n)? y
Database files will be extracted and the database schema will be created. This step will take between 5 - 10 minutes to complete.
Next, the installer will load the database with Oracle packages. This step will take between 30 - 60 minutes to complete, depending on your system performance.
The Portal user and the database schema are now created. During this step Oracle may produce messages similar to the following:
mv: cannot stat `/opt/aptare/oracle/lib/EVENT_PACKAGE__PORTAL__2.so': No such file or directory
Note:
These messages can be ignored. Any other exceptions or errors however indicate a potential issue with the installation.
Creating IT Analytics Portal user ... Completed creation of the IT Analytics Portal database user Creating IT Analytics database schema tables ... ... ... (EACH STEP LOGS TO THE CONSOLE...) ... Completed creation of the IT Analytics base schema tables Creating IT Analytics <backup product> schema tables ...
The Packages are now validated:
If you do not see the message "Successfully validated ALL Packages" at the end of this step, there is a possible problem with the install and you should save a copy of the installer log and contact the Cohesity Support.
Validating IT Analytics Packages... Validating PACKAGE ADAPTOR_PACKAGE Validating PACKAGE ADMINREP_PACKAGE Validating PACKAGE ALL_ERROR_PKG ... ... (EACH PACKAGE IS LOGGED TO THE CONSOLE...) ... Validating PACKAGE XML_REPORT_PKG Package specifications have successfully been validated ... Successfully validated ALL Packages.
The database creation is now complete.
Creation of IT Analytics Database completed at Nov 11 18:31:46 PDT 2021 A complete log of this session can be found in the file: /opt/aptare/logs/install/create_itanalytics_database_xxxxx.log
Note:
If the installer reports errors during the install and you are unable to resolve the problem, you should save a copy of the installer log and contact the Cohesity Support.
If you do not have a IT Analytics license, you can install a trial license which is valid for 60 days with the this command as a root user:
/opt/aptare/utils/installlicenseUI.sh /mnt/portal/license.slf
/opt/aptare/utils/installlicenseUI.sh /mnt/portal/foundation_license.slf
Installation of the Database components is now complete.
The IT Analytics database is a container database with the pluggable database SCDB attached to it. The data files for the tablespaces are stored in the /data01-06/oradata/scdbpdb directory.
Continue to the next section for the final step--License Key file installation.
If you have configured a custom OS user or a group for Oracle or portal, instead of the default users or groups:
Update the OS user and group details in the environment file
/opt/aptare/bin/aptare_env.sh.Ensure environment variables for Oracle, such as ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH are set appropriately in
/opt/aptare/bin/aptare_env.shand are exported correctly.