NetBackup IT Analytics Installation and Upgrade Guide for Windows
- Installation overview
- Install NetBackup IT Analytics on a Windows server
- Step-4: Installing Oracle application binaries
- Verify the current license configuration
- Next steps
- Upgrade NetBackup IT Analytics Portal on Windows
- Upgrade NetBackup IT Analytics Portal
- Oracle patches for the database server
- Upgrade and migrate to a new server
Attribute management during the Portal upgrade
Because you may already have attributes in your database that have names that duplicate the system names introduced in Version 10, the upgrade process must apply logic to prevent duplicate attribute names. During the Portal upgrade, the following logic is used:
In the top-level domain, if the upgrader finds an existing attribute that has a name that is the same as a new system attribute (for example, Location) it creates the system attribute and populates it with the list of values from the existing attribute.
For multi-tenancy environments where there are multiple domains, if an attribute is found in both a parent and child domain, the child domain will not inherit the values but instead, the values of the attribute in the child domain will remain intact. See also, Attribute Inheritance Overrides.
If multiple attributes with the same name are encountered in the same domain (for example, a host Location attribute and an array Location attribute), the values from all the attributes with the same name (for all objects) are merged into the system attribute.
The upgrader will list the attributes with the list of values that will be merged into the new System Attributes. You can choose to let the upgrader merge the attributes or you can stop the upgrade and use the steps provided to rename existing attributes.
Merging of values ensures that all objects that have been assigned the attribute will retain this attribute with its values and therefore, reports that use the attributes will continue to work as expected.
Before the upgrade:
Location attribute exists for Hosts, with a list of values: San Diego, New York, Seattle.
Location attribute exists for Arrays, with a list of values: Paris, London, Singapore.
After the upgrade:
Location system attribute has been created to replace the object-specific attributes. This system attribute will contain a merged list of values (LOV): San Diego, New York, Seattle, Paris, London, Singapore.
This list of values applies to all objects.
Once the upgrade is successful, you may want to modify the merged list of values via the Portal: Select
.
Log in to the Portal server
At the command line:
su - aptare
At the command line, launch sqlplus:
sqlplus <username>/<pwd>@//localhost:1521/scdb
Example: sqlplus portal/portal@//localhost:1521/scdb
To rename an attribute, execute the following SQL statements, substituting <variables> with values listed in the upgrade messages:
UPDATE apt_attribute SET attribute_name = <attributeName> WHERE attribute_id = <AttributeID>; Commit;
Example: This example renames the Location attribute so that it is not merged with the system attribute named Location.
UPDATE apt_attribute SET attribute_name = 'Location1' WHERE attribute_id = 100001; Commit;
Maintain attributes at the top-level domain so that the attributes are available to all client/child domains.
During the Portal upgrade to Version 10.x.xx, newly introduced System Attributes will be added to the top-level domain.