NORMS

System Profile

System Full Name	Operator List Search
Business Administrator	Dean Ciaschini
Business Owner	Joel Morley
Director	Patrick Juneau
Subject Matter Expert
Division	Aviation Safety Policy and Intelligence
NTARS Code
Source Location
Source Code Location

Technology Assessment

Platform Type
Database Platform and Version
Development Language and Framework
Operating System and Version	Windows Server 2016
Additional Dependencies
Authentication

Environment Access Information

ENV	WWWFILES	URL
TruePass DEV	\\tcwebscripts\tpwwwroot\securedev\NORMS	https://etpdev.tc.gc.ca/NORMS/
TruePass PREACC	\\tcwebscripts\tpwwwroot\securedev\NORMS-PreAcc	https://etpdev.tc.gc.ca/NORMS-PreAcc/
TruePass ACC	\\tcwebscripts\tpwwwroot\secureacc	https://etpacc.tc.gc.ca/norms
PROD		https://etp.tc.gc.ca/norms
TRAINING
EIG DEV	\\tcwebscripts\tpwwwroot\eigdev\norms	https://eigdev.tc.gc.ca/norms

System Overview

Developer installation

Step 1) Completely uninstall and reinstall oracle 12c. The installer can be found in \\TC4S0A\GROUPS\AARA\AARAD\Software Library\Developer Tools\Oracle. Regular installation, except there is no need for any VS dev tools and can be installed system-wide. (Note: Not having Visual Studio 2015 installed might prompt the following error. Downloading Visual Studio 2015 should fix that issue.)

Step 2) Unconfigure Oracle’s GAC with the attached bat file from \\Tc4s0a\groups\AARA\AARAD\NORMS.

Step 3) Install the latest ODT from Oracle’s website.

Note: Although installing Visual Studio 2015 is needed for step 1, the application is run on Visual Studio 2019.

Good To Know

How-To and Fixes

Production Error Log - Tracking all the production issues to notice trends as they can't be replicated in ACC