The space requirements for the upgrade are determined by the upgrade script. This requirement is mostly for new objects created during the upgrade. It is a fair estimate of space requirements.
The Oracle Database Server version should be upgraded as per the technology stack (see Section 1.2.2, "Oracle Components").
Verify that JRE 1.8 or above is installed, and JCE policy is applied.
Verify that the Oracle TNSNAMES have been configured.
To avoid errors during upgrade, do either of the following:
Keep datafiles AUTOEXTEND ON, or
Monitor free space and add more space, if required
Make sure you have a sort area of approximately 100 MB to avoid disk sort
Create one large rollback segment or size 20 GB for LARGE size model.
Keep all other rollback segments, except SYSTEM, offline.
The source Argus Safety database must be AL32UTF8 character set.
The database semantics must be CHAR and not BYTE.
Note:
You will need to generate a key prior to the database upgrade or you can use ArgusSecureKey.ini from the existing setup.You must also make sure that the password information specified in the database is consistent with the information provided in the ArgusSecureKey.ini file.
Note:
To execute Schema Creation Tool from a Linux server, copy the DBInstaller.zip file from the installation CD on the server. Unzip the file for execution.You may be prompted to press Enter at screens that are not included in the procedure. This does not hinder the upgrade procedure. Where applicable, press Enter to continue with the upgrade process.
Make sure the dbinstaller.properties are set up correctly. (See Section 11.1.6, "Configure the Database Setup Properties File".)
Validate the existing Argus Safety using the Schema Creation Tool. Use the validation file of the existing installed version from the Schema Validation folder:
<Argus Install Path>\Argus Safety\DBInstaller\SchemaValidationVerify the validation log file.
View the Validation Log file to make sure that the existing database has no errors, missing and invalid objects.
Select Start > Programs > Oracle > Schema Creation Tool.
Click Create/Upgrade DB.
The Argus Safety - Database Setup screen appears.
You cannot modify any details on this screen. In case, any of the information is incorrect, then you must re-create the schema.
In case of upgrade, all the schema details will be auto-populated based on the schema selection logic. Before proceeding further, you must confirm that all the schema details are correctly populated.
Note:
You must not create any Argus Safety objects in custom schema.Click Next.
Enter the path for Tablespaces and click Next.
Verify the Setup Parameters and click Execute.
To ignore any error due to customization, check Ignore Error checkbox in the Schema Creation Tool, and analyze it later when the upgrade is done.
To validate the schema, run the Schema Validation tool.
Log in to ARGUS_APP schema.
Verify that the common profile switch DATABASE_TIMEZONE is not empty by executing the following script:
select key, value from cmn_profile where key = 'DATABASE_TIMEZONE';
Before enabling Local Locking in Argus Safety, you must make sure that you have upgraded your database to this release successfully.
Execute the batch file Enable_local_lock.bat from <Argus Install Path>\DBInstaller\utilities\Enable_local_lock directory.
Enter the response for Do you wish to turn on the Local Locking feature for one or more enterprises (Yes/No)?, enter Yes to continue.
Enter the log file name to record the results.
This is the execution log that is created on the client workstation under the Enable_local_lock directory mentioned above.
Enter TNSNAMES Entry to Connect to the source SAFETY Database.
Enter SAFETY schema owner name in source Database.
Enter the password for safety schema name in source Database.
Enter comma separated list of enterprises where local locking feature is to be enabled or enter ALL for all enterprises in Source safety Database.
If no value is entered script will run for enterprise 1 by default.
Enter the Agency name for PMDA reporting destination as configured in Reporting Destination codelist.
To enable local locking privileges for the Argus J users, enter Yes.
Follow the prompts for confirmation.
Note:
If the agency entered is invalid for any of the enterprises, the utility will abort and no changes will be committed.In case of a multi-tenant environment, if this utility is re-run for any of the enterprises, it will display a list of the enterprises for which it has already executed and will continue to process rest of the enterprises.
The end user should not use the Source database during export process.
Install Argus Safety 8.2 on a computer where Oracle 12c is installed.
The source databases should be schema validated at Argus Safety 8.2.
The source database should only be a single-tenant database.
The source database data must contain only one ENTERPRISE.
Navigate to the following Path from Start Menu:
All Programs > Oracle > Merge to Multi-tenant
Click Export and follow the instructions on the sqlplus screen.
Enter Log File Name to record results.
This is the execution log that is created on the client workstation:
Log file path: <Argus Install Path>\DBInstaller\Merge_to_Multitenant
Enter TNSNAMES Entry to Connect to the Source SAFETY Database.
Enter SYSTEM or DBA user name in source Database.
Enter password for SYSTEM or DBA user in source Database.
Enter SAFETY schema owner name in source Database.
Enter password for Safety schema owner in source Database
Enter Interchange schema owner name in Safety Database
Enter password for Interchange schema owner in source Database.
Enter the full directory Path to create the Source Safety database export dump file:
This is the Path on the Source Database Server where the Argus Safety Database resides. The Batch file will create an export dump file (SAFETY.DMP) and an export log file (SAFETY_EXPORT.LOG) in the Directory.
Make sure that SAFETY.DMP file does not exist prior to the export.
Make sure that no error has occurred during the database export, by checking the following log files:
Log file name entered as parameter 1 during export step execution.
Following Oracle Export log files are created on database server. The path is the value entered on ”Enter Directory including full Path to create Source safety database export dump file” during export step:
SAFETY_EXPORT.log
Move the export dmp file created in Merge Export from the source database server to the target database server.
Create a cold backup of the target database before starting the Merge Import step.
The end user should not use the target database during the import process.
Only one Merge Import process can run on the target database at a time.
Auto extend should be set on for all Database files in the target database.
Sufficient space should be available on the target database server to import the new Enterprise Data. The amount of space depends on the number of cases in source Safety database.
Install the Argus 8.2 application. Make sure that Oracle Client version is 12c.
The target databases should be Schema Validated at Argus 8.2.
The target database must be a multi-tenant database.
All source database dictionaries should be available in target database. If the dictionary does not exist then install missing dictionaries on the target database.
All existing AG service users on the source database must exist on the target database.
All source database LDAP configured server names should be available in target database.
From Start menu, navigate to the following path:
All Programs > Oracle > Merge to Multi-tenant
Click Import and enter the following parameters for the target database:
Log File Name to record results
This is the execution log that will be created on the client workstation.
Log file path: <Argus Install Path>\DBInstaller\Merge_to_Multitenant
TNSNAMES entry to connect to the target Safety database
SYSTEM or DBA user name
Password of the DBA user
VPD schema owner name
Password of the VPD schema owner
SAFETY schema owner name
Password of the Safety schema owner
Interchange schema owner name
Password of the Interchange schema owner
Directory location where the export dmp file is copied for the import process.
This is the path on the Target Database Server where the Argus Safety database is installed. The batch file creates an import log file in this directory.
Name of the new enterprise
Abbreviation of the new enterprise
SAFETY schema owner name in the source database
Interchange schema owner name in source database
This batch file imports the data from the dump file into the target database.
Make sure that no error has occurred during import by checking the following log files:
Log file name entered as parameter 1 during Import step execution.
The following Oracle Import log files are created on database server. The path is the value entered in ”Enter Directory including full Path on target database server where export dmp file copied for import process” during import step.
SAFETY_IMPORT_safety.log
SAFETY_IMPORT_interchange.log
SAFETY_IMPORT_SAFETY_DUP_SEARCH_DATA.log
SAFETY_IMPORT_SAFETY_DUP_LAM_SEARCH_DATA.log
Validate the schema of the database using Argus Safety Schema Validation tool.
The Merge process synchronizes the dictionary information based on the dictionary name in the source and target database. If the source Dictionary name is not available in Target Database, then manual synchronization is required.
To synchronize the dictionary data manually on the target database:
Log in as Safety schema owner using sqlplus on Target Safety Database.
Locate the new ENTERPRISE_ID value created from import process using the following sql:
SELECT VALUEFROM cmn_profile_globalWHERE section = 'DATABASE' AND KEY = 'MERGING_TO_MULTITENANT';
Set the context value to new Enterprise_id
Exec pkg_rls.set_context('admin',< Value of New Enterprise ID>,'ARGUS_SAFETY');
Locate the list of Dictionaries ID's where Dictionary synchronization pending due to missing Dictionaries on Target database. If the following sql results in NO ROWS, then no further action is required.
Select dict_idFrom cfg_dictionaries_enterpriseWhere enterprise_id = <Value of New Enterprise ID>And global_dict_id = -1;
Log in as the Safety schema owner using sqlplus on the source safety database.
Locate the dictionary name of each Dictionary ID where the Dictionary does not exist on the target database using the following sql:
Select name from cfg_dictionaries_global where dict_id in (<List of Dict ID values (comma separated) from Step 4);
Load the missing dictionaries on the target database.
Set the context to new enterprise_id using following sql on target database.
Exec pkg_rls.set_context('admin',<Value of new ENTERPRISE_ID> ,'ARGUS_SAFETY');
Update GLOBAL_DICT_ID data in the target database using the following SQL:
UPDATE CFG_DICTIONARIES_ENTERPRISE SET GLOBAL_DICT_ID = <Dictionary Global Dict ID value from target database> WHERE ENTERPRISE_ID = <New ENTERPRISE_ID created in Target Database> AND DICT_ID = <Value of Dict ID in New ENTERPRISE with Dictionary name> AND GLOBAL_DICT_ID =-1;