APTARE IT Analytics Installation and Upgrade Guide for Windows
- Install APTARE IT Analytics Portal on a Windows server
- Introduction
- Portal installation memory requirements
- Multi-language support and locale considerations (Windows)
- Task 1: Portal and database deployment strategies (Windows)
- Task 2: Pre-installation configuration (Windows)
- Task 3: Installing Oracle application binaries (Windows)
- Task 4: Installing Portal application binaries (Windows)
- Task 5: Request the license key file (Windows)
- Task 6: Log into the Portal (Windows)
- Task 7: Install the license key file (Windows)
- Task 8: Performing a cold backup (Windows)
- Supported third-party and open source products
- Uninstall the APTARE IT Analytics Portal
- Upgrade APTARE IT Analytics Portal on Windows
- Overview
- Upgrade path
- Before upgrading
- Upgrade the Oracle database application binaries to19c (Windows)
- Upgrade APTARE IT Analytics Portal
- Data Collector upgrades
- Troubleshooting - manual Data Collector upgrades
- Collector updates from the APTARE IT Analytics Portal
- Clustered NetBackup upgrade procedure
- Upgrade methods to incorporate enterprise objects
- Oracle patches for the database server
- Upgrade and migrate to a new server
Upgrading a shared services environment
In a shared services environment, where the connect as sysdba privilege is not present, you must provide a CREATE SYNONYM privilege to the APTARE_RO user before upgrading. APTARE_RO is a read-only user for the Portal.
Note:
Unless this privilege has been deliberately revoked, this step is mandatory for an upgrade. If this privilege is not granted, errors in the upgrade script will occur and functionality within the SQL Template Designer will be impacted.
Log in with root access.
Stop the portal and data receiver Tomcat services.
At the command line, execute the following commands:
sqlplus / as sysdba
SQL >GRANT CREATE SYNONYM TO APTARE_RO;
In a shared services environment, where the connect as sysdba privilege is not present, you must provide a CREATE JOB and DBMS_SCHEDULER privilege to the PORTAL user before upgrading.
Note:
Unless this privilege has been deliberately revoked, this step is mandatory for an upgrade. If this privilege is not granted, errors in the upgrade script will occur and functionality for Oracle jobs will be impacted.
Log in with root access.
Stop the portal and data receiver Tomcat services.
At the command line, execute the following commands:
sqlplus / as sysdba
SQL > GRANT CREATE JOB TO PORTAL;
SQL > GRANT EXECUTE ON DBMS_SCHEDULER TO PORTAL;
As a standard practice, during an APTARE IT Analyticsupgrade, Oracle-related code is leveraged and system-level objects (dba_, V$, etc.) and users (sys, system) are accessed. This scenario is not optimal in a shared service environment where organizations prefer to maintain their own Oracle credentials. Starting with release 10.4, portal upgrades can be run with limited privileges for the PORTAL user. Specific SQL statements can be executed to revoke the additional privileges assigned prior to the 10.4 release.
Note:
When privileges are revoked, the APTARE IT Analytics upgrade process is prevented from calculating the space in the datafiles and canceling Oracle jobs which may interfere with upgrade. By revoking these privileges, the local administrator assumes this responsibility.
Complete these steps to revoke privileges from a PORTAL user.
Log in with admin access.
Stop the portal and data receiver Tomcat services.
At the command line, execute the following commands:
sqplplus / as sysdba SQL >REVOKE SELECT ANY DICTIONARY FROM PORTAL; SQL>REVOKE SELECT_CATALOG_ROLE FROM PORTAL; SQL>REVOKE SELECT ON dba_free_space FROM PORTAL; SQL>REVOKE SELECT ON dba_data_files FROM PORTAL; SQL>REVOKE SELECT ON dba_temp_files FROM PORTAL;