Step 4. Upgrading the database - HxGN EAM - Version 11.7.1 - Installation & Upgrade - Hexagon

HxGN EAM Oracle Database Installation Guide

Language
English
Product
HxGN EAM
Search by Category
Installation & Upgrade
HxGN EAM Version
11.7.1

Before beginning the upgrade, ensure that all open invoices are approved or canceled and that all drivers on the Transaction driver control form (BXDCTL) have been stopped. Also disable Flex SQL and email triggers if present.

Before beginning the upgrade, back up the current database by exporting the existing HxGN EAM production schema.

The 7iset.sql script contains a setting to modify the number of rows processed at once by some of the large-scale updates; you may want to increase the number of rows when the rollback segments are sufficiently large enough to improve performance (the default setting of 5000 rows is a conservative estimate). The upgrade does not use the definition of the index tablespace that can be set here.

HxGN recommends performing a trial upgrade before upgrading a production database.

Execute the following scripts from the \ORACLE\<SCRIPTS>\ directory:

Script

Function

00ck116u.sql

Checks the version, the Oracle RDBMS version, any users still logged in, the available space, and the presence of auxiliary tables remaining from previous upgrades (these must be dropped or renamed before proceeding)

10tb116u.sql

Upgrades the table structure to HxGN EAM version 11.6 using the storage parameters defined in the 7iset.sql file

7icomp.sql

Run this script to recompile any invalid database objects; however, not all objects need to be valid at this point.

20ip116.dmp

Contains "seed" data for the application. Import this dump file with this command

imp user/password@alias full=y file=20ip116.dmp log=20ip116.log ignore=y

where <user> = the HxGN EAM Oracle schema, <alias> = the database alias for the Oracle instance to be used. Make sure that the log file shows a list of imported tables. Including ignore=y on the command line is necessary.

28lc116u.sql

Updates the basic HxGN EAM setup to version 11.6

30dt116u.sql

Data manipulation for version 11.6. Refreshes the electronic archiving mapping metadata, gives new columns to default values, and converts user data whenever necessary.

50cs116u.sql

New version 11.6 database constraints, indexes, and views. Indexes are created in the same tablespace as the primary key index on the R5EVENTS table (R5PRIK_EVT).

60prc116.sql

Replaces all database procedures, functions, packages, and views (in dependency order)

70trg116.sql

Replaces all database triggers

7icomp.sql

To be used to recompile any invalid database objects; however, these invalid database objects should not be present at the end of the version 11.6 database installation. Run the next scripts from this same SQLPlus session or from a new session.

80ed116u.sql

Updates some settings and metadata according to the edition of the product.

7icomp.sql

To be used to recompile any invalid database objects; however, these invalid database objects should not be present at the end of the version 11.6 database installation. Run the next scripts from this same SQLPlus session or from a new session.