Skip Headers
Oracle® Argus Insight Installation Guide
Release 7.0.3

E41483-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Creating the Argus Insight Data Mart Structure

The Argus Insight Schema Creation Tool lets you create the Argus Insight data mart structure. It creates a link between your source Argus database and your new Argus Insight data mart. The Extract Transform and Load (ETL) process uses this link to transfer data from your Argus database to the Argus Insight data mart for reporting purposes.

During the schema creation process, you are required to create database users:

This chapter includes the following topics:

Note:

The Argus Insight database must be created with the same character set as the Argus Safety database. Make sure you have installed the requisite software as explained in Section 1.2, "Software and Hardware Requirements".

3.1 Before You Run the Argus Insight Schema Creation Tool

The GLOBAL_NAME and NLS_LENGTH_SEMANTICS database parameters must be configured properly in order for the Argus Insight Schema Creation Tool to run. You must check those settings before you run the Argus Insight Schema Creation Tool. If the parameters are not set properly, the Schema Creation Tool will fail.

To review and modify these database settings:

  1. Contact your database administrator (DBA).

  2. Verify that the database configuration file for the Argus Insight database defines the following database parameter values:

    • GLOBAL_NAME = FALSE (This parameter must be set to FALSE for Argus Insight to be able to create the database links.)

    • NLS_LENGTH_SEMANTICS = CHAR

  3. Restart the database instance for your changes to take effect.

3.2 Argus Insight Configuration Requirements

This section lists the required and recommended values for:

  • Database parameters

  • Database I/O configuration

  • RAM and CPU

3.2.1 Database Parameters

Table 3-1 lists the database parameters and the values that must be set for Argus Insight.

For those parameters that require a numeric value, Table 3-1 lists the minimum value recommended. You may need to increase the value depending on your system configuration and the number of cases. It is the responsibility of the database administrator to monitor the system and adjust the database parameters as necessary.

Table 3-1 Database Parameters for Argus Insight

Database Parameter Required Value

COMPATIBLE (for Oracle 11gR2)

11.2.0.0.0 or later

CURSOR_SHARING

EXACT

GLOBAL_NAME

FALSE

JOB_QUEUE_PROCESSES

10 (Minimum value recommended)

NLS_LENGTH_SEMANTICS

CHAR

OPTIMIZER_MODE

ALL_ROWS

OPTIMIZER_SECURE_VIEW_MERGING

TRUE

PARALLEL_MAX_SERVERS

Minimum value recommended based on the total number of cases:

  • Small (< 30,000 cases): 16

  • Medium (30,000 to 200,000 cases): 32

  • Large (200,000 to 1,000,000 cases): Default

  • Extra Large (> 1,000,000 cases): Default

PGA_AGGREGATE_TARGET

Minimum value recommended based on the total number of cases:

  • Small (< 30,000 cases): 0.5 GB

  • Medium (30,000 to 200,000 cases): 2 GB

  • Large (200,000 to 1,000,000 cases): 3 GB

  • Extra Large (> 1,000,000 cases): 4 GB

QUERY_REWRITE_ENABLED

TRUE (if computing statistics regularly)

FALSE (if not computing statistics regularly)

SGA_MAX_SIZE

Greater than or equal to the value of the SGA_TARGET parameter.

SGA_TARGET

Minimum value recommended based on the total number of cases:

  • Small (< 30,000 cases): 1 GB

  • Medium (30,000 to 200,000 cases): 2.5 GB

  • Large (200,000 to 1,000,000 cases): 3.5 GB

  • Extra Large (> 1,000,000 cases): 4.5 GB

The 32-bit architecture allows for 4 GB of physical memory to be addressed. DBAs should verify the maximum addressable RAM for their respective architectures.

UNDO_MANAGEMENT

AUTO

WORKAREA_SIZE_POLICY

AUTO

DB_BLOCK_BUFFERS (in MB) / DB_CACHE_SIZE

Leave set to the Oracle default value

DB_BLOCK_SIZE (in bytes)

Leave set to the Oracle default value

QUERY_REWRITE_INTEGRITY

Leave set to the Oracle default value

SHARED_POOL_SIZE

Leave set to the Oracle default value


3.2.2 Database I/O Configuration

Table 3-2 lists the minimum amount of disk space to allocate for the redo log files, TEMP tablespace, and UNDO tablespace.

Table 3-2 Recommended Database I/O Configuration for Argus Insight


Total Number of Cases
Database I/O Configuration Small (< 30,000) Medium (30,000 to 200,000) Large (200,000 to 1,000,000) Extra Large (> 1,000,000)

Number and Size of Redo Log Files

Default

3 X 500 MB

5 X 500 MB

5 X 500 MB

 

The value depends on the characteristics of the I/O subsystem such as the I/O bandwidth, storage disks type, and RAID level. (Oracle recommends RAID 1+0 or similar.)

TEMP Tablespace Size

32 GB

32 GB

64 GB

128 GB

UNDO Tablespace Size

16 GB

32 GB

64 GB

128 GB

 

The recommended UNDO tablespace size is based on the projections with the following two parameter values:

RETENTION=NOGUARANTEE

UNDO_RETENTION=900 (seconds)


3.2.3 Recommended Configuration for the Database Server

Table 3-3 lists the recommended configuration (RAM and CPU) for the Argus Insight Database Server.

Table 3-3 Recommended Configuration for the Argus Insight Database Server


Total Number of Cases
Database Server Configuration Small (< 30,000) Medium (30,000 to 200,000) Large (200,000 to 1,000,000) Extra Large (> 1,000,000)

RAM

4–8 GB

8–16 GB

16–32 GB

16–32 GB

CPU

Equivalent to 2–4 Dual Core, 3 GHz

Equivalent to 4–8 Dual Core, 3 GHz

Equivalent to 8–12 Dual Core, 3 GHz

Equivalent to 8–12 Dual Core, 3 GHz


Note:

The Argus Insight Database and Argus Safety Database TNS names entry must be available in both Argus Insight Database Server and Argus Safety Database Server. Argus Safety Database TNS should also be present in the Argus Insight Web Server.

3.3 Argus Insight Data Mart Tablespaces

Table 3-4 lists the tablespaces for the Argus Insight data mart. Argus Insight creates these tablespaces when you create a database schema.

Note that the tablespace names begin with APR. The Argus Power Reports (APR) product was renamed to Argus Insight.

Table 3-4 Tablespaces Created for the Argus Insight Data Mart

APR_CFG_DATA_01

APR_MEDM_DATA_01

APR_MRPT_INDEX_01

APR_MCAS_DATA_01

APR_MEDM_INDEX_01

APR_MRPT_INDEX_02

APR_MCAS_DATA_02

APR_MEDM_LOB_01

APR_MRPT_INDEX_03

APR_MCAS_HIST_DATA_01

APR_MFACT_DATA_01

APR_MWHOC_DATA_01

APR_MCAS_HIST_DATA_02

APR_MFACT_HIST_DATA_01

APR_MWHOC_INDEX_01

APR_MCAS_HIST_INDEX_01

APR_MFACT_HIST_INDEX_01

APR_SESM_DATA_01

APR_MCAS_HIST_LOB_01

APR_MFACT_INDEX_01

APR_SESM_INDEX_01

APR_MCAS_INDEX_01

APR_MRPT_DATA_01

APR_SESM_LOB_01

APR_MCAS_INDEX_02

APR_MRPT_DATA_02

APR_STAGE_DATA_01

APR_MCAS_LOB_01

APR_MRPT_DATA_03

APR_STAGE_DATA_02

APR_MCFG_DATA_01

APR_MRPT_HIST_DATA_01

APR_STAGE_DATA_03

APR_MCFG_HIST_INDEX_01

APR_MRPT_HIST_DATA_02

APR_STAGE_INDEX_01

APR_MCFG_HIST_LOB_01

APR_MRPT_HIST_DATA_03

APR_STAGE_INDEX_02

APR_MCFG_INDEX_01

APR_MRPT_HIST_INDEX_01

APR_STAGE_INDEX_03

APR_MCFG_LOB_01

APR_MRPT_HIST_INDEX_02

APR_STAGE_LOB_01

APR_MCFG_LOG_01

APR_MRPT_HIST_INDEX_03

APR_SWHOC_DATA_01


3.4 Starting the Argus Insight Schema Creation Tool

To start the Argus Insight Schema Creation Tool:

  1. Log in to the Argus Insight Web Server.

  2. Click Start.

  3. Navigate to Programs > Oracle > Argus Insight, and select Schema Creation Tool. The main window for the Schema Creation Tool opens.

    Surrounding text describes schemac.gif.

Summary of the Schema Creation Tool options:

3.5 Creating the Database Schema

This section describes the tasks associated with creating the database schema:

3.5.1 Creating Users and Roles in the Argus Safety Database

To create users and roles:

  1. Start the Argus Insight Schema Creation Tool.

    Surrounding text describes schemac.gif.
  2. Click Argus User Creation. The Oracle Database Connect dialog box opens.

    Surrounding text describes odbc.gif.
  3. Connect to the Oracle Database:

    1. In the Password field, type the password for the SYSTEM user.

    2. In the Argus Safety Database field, type the name of your Argus Safety Database instance.

    3. Click OK. The Argus Safety Read Only User Creation dialog box opens.

  4. Click New User. The New User dialog box opens.

    Surrounding text describes newuser.gif.
  5. Complete the New User dialog box as follows:

    1. Enter a name for the new user.

    2. Specify and confirm the password for the user.

    3. Select the default and temporary tablespaces required by your corporate standards, or leave the default values.

    4. Click OK. The system returns to the Argus Safety Read Only User Creation dialog box.

    Note:

    You must create the INSIGHT_RO_USER and INSIGHT_RO_ROLE, if they do not exist in the Argus Safety schema. Make the appropriate selection in Step 8 below for New User Name and New Role drop downs and proceed.
  6. Click New Role. The New Role dialog box opens:

    Surrounding text describes newrole.gif.
  7. Enter the name of the new role to create and then click OK. The system returns to the Argus Safety Read Only User Creation dialog box.

    Surrounding text describes asrouc-lfn.gif.

    Note:

    In case you have upgraded the database from Argus Insight 7.0.2 to 7.0.3, you can also select the existing user, which you have already created earlier, from the New User Name drop-down list.
  8. Complete the Argus Safety Read Only User Creation dialog box as follows:

    1. In the New User Name field, select INSIGHT_RO_USER.

    2. In the New Role field, select INSIGHT_RO_ROLE.

    3. In the Log File Name field, enter the complete path for the location and name of the log file. Alternatively, you can click Browse to select the location for the log file, enter the file name, and then click Save.

      Surrounding text describes savelogfile.gif.
  9. Click OK when you are ready to create the specified user with the specified role.

    The system displays the command prompt as shown in the following figure:

    Surrounding text describes syspassword.gif.
  10. Enter the password for the SYSTEM user and press Enter.

  11. Verify that the script is successfully connected as <SYSTEM User Name>@<Argus Safety Database Name> as shown in the following figure:

    Surrounding text describes scrptdtls.gif.
  12. Press Enter. The system displays information about the Argus Safety database name, the name of the user to create, the role to assign to the user, and the name of the log file.

  13. Verify that the information is correct, and then press Enter to continue. The system displays additional information about creating the user and granting privileges.

  14. Press Enter to complete the installation. The system displays a message that the user account has been created successfully and lists the folder location of the log files as shown in the following figure:

    Surrounding text describes rousrconf.jpg.
  15. Click OK to close the message box. The system returns to the Argus Safety Read Only User Creation dialog box.

  16. Click View Log File.

    1. Review the information in the log file and check for any errors.

    2. Close the log file when you are done reviewing.

  17. Click Close to close the Argus Safety Read Only User Creation dialog box.

3.5.2 Clearing the Cache

If you are using the same Database Installer used to create an earlier schema, you must clear its cache.

To clear the cache:

  1. Press and hold the CTRL key and right-click the mouse. Argus Insight prompts for confirmation that you want to reset the Cache.

    Surrounding text describes resetcache.jpg.
  2. Click Yes.

    Argus Insight clears the cache and logs the action in the createlog.rtf file.

3.5.3 Creating a New Schema for Argus Insight

Note:

Before executing the steps for creating a new schema for Argus Insight, ensure that you have remote access to the SYS user.

If you do not have remote access to SYS user, execute the ai_sys{grant}.sql script through SYS user. This SQL script is located in the following folder:

drive:\Program Files\Oracle\ArgusInsight\Database\DBInstaller\DDL Folder

To create a new schema for Argus Insight:

  1. Start the Argus Insight Schema Creation Tool.

  2. Click Create Schema. The Oracle Database Connect dialog box opens.

    Surrounding text describes odc.gif.
  3. Connect to the Oracle Database:

    1. In the Password field, type the password for the SYSTEM user.

    2. In the Database field, type the TNS entry for the Argus Insight Database.

    3. Click OK.

    Note that:

    • If the NLS_LENGTH_SEMANTICS database parameter is not set to CHAR, the system displays an error message. You cannot proceed with the process of creating a new schema. You must set the NLS_LENGTH_SEMANTICS parameter to CHAR in the Argus Insight data mart and then restart the database instance. See Section 3.1, "Before You Run the Argus Insight Schema Creation Tool" for details.

    • If the NLS_LENGTH_SEMANTICS database parameter is set to CHAR, the system opens the New User dialog box for the APR_MART user.

      Surrounding text describes martnu.gif.
  4. Enter a password for the APR_MART user (which is the schema owner), and then re-enter to confirm the password.

  5. Click OK. The system opens the New User dialog box for the APR_APP user.

    Surrounding text describes appnu.gif.
  6. Enter a password for the APR_APP user, and then re-enter to confirm the password.

    Note:

    Argus Insight uses the APR_APP user account for all application access and reporting. The password for this user is stored in encrypted form in the CMN_PROFILE_GLOBAL table. If you need to change this password in the future or if you forget the password, you must contact Oracle Support for assistance in resetting the APR_APP password in the CMN_PROFILE_GLOBAL table. If the password for this user is not in synch with the value in the CMN_PROFILE_GLOBAL table, the Argus Insight application will not work.
  7. Click OK. The Argus Insight Schema Creation Options dialog box opens.

    Surrounding text describes aisco.gif.
  8. Click New User. The New User dialog box opens.

    Surrounding text describes stagenu.gif.
    1. In the New User Name field, type one of the following names:

      • APR_STAGE

      • APR_LOGIN

      • APR_LINK_USER

      • APR_HIST

      • RLS_USER

    2. In the New User Password field, type the password for the specified user.

    3. In the Re-enter Password field, type the user password again for verification.

    4. Click OK. The system returns to the Argus Insight Schema Creation Options screen.

    Repeat this step until you have created all the above users.

  9. Click New Role. The New Role dialog box opens.

    Surrounding text describes aprrole.gif.
    1. Enter one of the following names in the New Role field:

      • APR_ROLE

      • APR_LINK_ROLE

      • APR_APP_ROLE

    2. Click OK. The system returns to the Argus Insight Schema Creation Options screen.

    Repeat this step until you have created all three (3) roles.

  10. Define the following users and roles in the Argus Insight Schema Creation Options screen:

    1. Select APR_STAGE from the Staging Schema Owner drop-down list.

    2. Select APR_HIST from the History Schema Owner drop-down list.

    3. In the VPD Admin Schema Owner field of the Credentials for VPD Admin Users section, select RLS_USER.

    4. In the Schema Options section, select the Database Size and the Time Zone.

    5. Select APR_ROLE from the Mart Role drop-down list.

    6. Check the APR_LOGIN checkbox from the Mart Grantee section.

    7. Select APR_APP_ROLE from the Application Role drop-down list.

    8. In the Database Link Schema Owner drop-down list of the MART Database Link Information section, select APR_LINK_USER.

    9. In the Database Link Role drop-down list of the MART Database Link Information section, select APR_LINK_ROLE.

    10. In the Argus Database Link Information section:

      Note:

      The value you enter in the Database Link Schema Owner field should be the name of the Argus Insight read-only user that you created earlier in the installation process. See Section 3.5.1, "Creating Users and Roles in the Argus Safety Database" for details.
    11. Enter the name of the Argus Safety database in the Database Name field.

    12. Enter INSIGHT_RO_USER in the Database Link Schema Owner field.

    13. Enter the password for the INSIGHT_RO_USER in the Password field.

    14. Re-enter the password in the Verify Password field.

    15. Optionally, in the Credentials for APR_USER section, enter and verify a new password only if you want to change the password for APR_USER.

      All these inputs have been depicted in the following figure:

      Note:

      You must update the APR_USER password using the instructions in the Section 2.2.1, "Changing the APR_USER Password" section, if you change the default APR_USER password. This is to update the password on the database level and the Argus Insight Web Server/Cognos Server.
      Surrounding text describes schemacreation.jpg.
  11. Click Generate. The system prompts for the password of the staging user (APR_STAGE user).

    Surrounding text describes stageodc.gif.
  12. Enter the password and click OK. The system checks that Argus Insight and Argus Safety use the same character set. How the system continues depends on the result:

    • Different Character Set — If the character set for the Argus Insight database (that is, the MART character set) is different from the character set for the Argus Safety database, the system displays a warning message and prompts for confirmation that you want to proceed.

      Surrounding text describes ai.gif.

      Determine whether you want to continue with the schema creation.

      If the Argus Safety database uses the UTF character set and the Argus Insight database uses the ISO character set, the ETL process may fail due to the different character sets. In this case, Oracle recommends that you click No, fix the character set issue, and restart the create schema process.

      If the Argus Safety database uses the ISO character set and the Argus Insight database uses the UTF character set, then the system can proceed by ignoring the character set difference. In this case, you can click Yes.

    • Same Character Set — If the character set for the Argus Insight database is the same as the character set for the Argus Safety database, the following command screen is displayed:

      Surrounding text describes syspassword.jpg.
  13. If you have remote access to the SYS user, enter the password for the SYS user and press Enter.

    This displays the following command screen:

    Surrounding text describes scrptdtls.jpg.

    OR

    If you do not have remote access to SYS user, then execute ai_sys{grant}.sql script through SYS user. This SQL script is located in the following folder

    drive:\Program Files\Oracle\ArgusInsight\Database\DBInstaller\DDL Folder

    Open the ai_sys{grant}.sql file from the above mentioned location.

    Execute all the GRANT statements after replacing the names of the variables with their corresponding Schema Owner name. For example:

    • &mart_user. = APR_MART schema owner (APR_MART)

    • &mart_app_user. = APR_APP schema owner (APR_APP)

    • &rls_user. = VPD schema owner (RLS_USER)

    If you have already executed the ai_sys{grant}.sql script through SYS user, then go to Step17 of this procedure.

  14. Verify that the script is successfully connected as <SYS User Name >@<Argus Insight Database Name> and press Enter. This again displays the command screen with the Grant succeeded message displayed multiple times along with the location of the log file.

  15. Verify the location of the log file and press Enter.

  16. Wait until the Tablespace Creation dialog box opens.

    Surrounding text describes tblspcrtn.gif.
  17. Complete the Tablespace Creation screen as follows:

    1. In the Enter Database Server Directory where all Data Files will be Created field, enter the complete path to the directory for the tablespace data files that will be used by Argus Insight. For example, /u01/app/oracle/SMTEST. Note that the directory you specify must already exist.

    2. Click Generate DataFile Path and Name. The system automatically fills in the Complete Path and Datafile column for all tablespaces.

    Note that the system automatically selected the delimiter character to use for the directory path based on the Database Server operating system.

  18. Click Create Tablespace to create all tablespaces.

  19. Wait until the system creates the tablespaces and opens the Argus Insight Database Installation dialog box with the Application Type and the name of the default enterprise:

    Surrounding text describes aidi.jpg.
  20. Click Continue to start the schema creation. The system executes the scripts, displays status information during the schema creation process, and reports when the update is completed.

    Surrounding text describes aidi-success.gif.
  21. Click the Book icon to view the log file and check for errors.

    Alternatively, you can view the log file at any time at the following location:

    drive:\Argus_Insight_Working\AI703\Database\DBInstaller\CreateLog.rtf

  22. Click Finish to close the dialog box.

3.5.4 Loading Factory Data

To load the factory data:

  1. Start the Argus Insight Schema Creation Tool.

    Surrounding text describes schemac.gif.
  2. Click Factory Data to load the factory data. This displays the command screen, as shown in the following figure:

    Surrounding text describes aprmartusr.jpg.
  3. Enter the password for the APR_MART User and press Enter. This displays the following command screen:

    Surrounding text describes verfyscrpt1.jpg.
  4. Verify that the script is successfully connected as <APR_MART User Name>@<Argus Insight Database Name> and press Enter. This again displays the command screen with the row creation messages displayed multiple times along with the name and location of the log file. The name of the log file that is displayed is insight_factory_data_log.txt.

  5. Press Enter again. Argus Insight displays the following message when it finishes loading the factory data:

    Surrounding text describes loadfactory.jpg.
  6. Click OK to return to the Schema Creation Tool screen.

3.6 Validating the Schema

To validate the database schema:

  1. Start the Argus Insight Schema Creation Tool.

  2. Click Schema Validation. The Oracle Database Connect dialog box opens.

    Surrounding text describes systemodc.gif.
  3. Connect to the Oracle Database:

    1. In the Password field, type the password for the SYSTEM user.

    2. In the Database field, type the name of the Argus Insight Data Mart instance.

    3. Click OK. The Schema Validation Utility dialog box opens.

    Surrounding text describes validation.jpg.
  4. Complete the Schema Validation Utility dialog box as follows:

    1. For the Validation CTL Folder and File field, click Browse next to the field to navigate to the location of the CTL file that you want to verify. Select the CTL file and then click Open. The system returns to the Schema Validation Utility dialog box.

    2. For the Select Log Files Folder field, click Browse next to the field to navigate to and select the log files folder. Click OK to close the Select Folder dialog box and return to the Schema Validation Utility dialog box.

    Note that the system automatically inserts the default file names into the Validation LOG File Name (Record Diff) and Validation LOG File Name (Record Output) fields. You can change the log file names if you want.

  5. Click Validate Schema. This displays the following command screen:

    Surrounding text describes systempass.jpg.
  6. Enter the password for the SYSTEM user and press Enter. This displays the following command screen:

    Surrounding text describes verfyscrpt2.jpg.
  7. Verify that the script is successfully connected as <SYSTEM User Name>@<Argus Insight Database Name> and press Enter. This displays the screen that confirms the Database Name, Database Administrator User Name, Validation File Name, and the Folder Name for Log Files as shown in the following figure:

    Surrounding text describes schedtls.jpg.
  8. Review the information on the command screen and press Enter. This displays the following command screen:

    Surrounding text describes systempass1.jpg.
  9. Enter the password for the SYSTEM user and press Enter.

  10. Press Enter again on the next displayed screen. This displays a message that the validation of the Argus Insight Database is completed:

    Surrounding text describes aitl.gif.
  11. Click OK.

When the system returns to the Schema Validation Utility dialog box, you can:

  • Click View Difference Log File to check for any schema discrepancies, such as missing objects.

  • Click View Output Log File to see the list of errors, if any, that occurred during schema validation.

  • Click Close to close the dialog box.

3.7 Creating a Database Link from Argus Safety to Insight Database

This link allows real-time updates of some of the values from Argus Console to Argus Insight data mart.

To create the database link from the Argus Safety database to the Argus Insight database:

  1. Start the Argus Insight Schema Creation Tool.

  2. Click Argus DBLink.

  3. Connect to the Oracle Database:

    1. In the Password field, type the password for the SYSTEM user.

    2. In the Argus Safety Database field, type the name of your Argus Safety database.

    3. Click OK.

    The Argus To Insight Database Link Creation dialog box opens.

    Surrounding text describes dblinkcreation.jpg.
  4. Complete the fields in the Argus Safety Information section as follows:

    1. In the Schema Owner field, select the user account that owns the Argus Safety schema.

    2. In the Safety Role field, select the Argus Safety role.

    3. In the Read Only Role field, select the INSIGHT_RO_ROLE, which was created in Argus Safety.

  5. Complete the fields in the Argus Insight Information section as follows:

    1. In the Database field, enter the name of the Argus Insight database.

    2. In the RO User field, enter the name of the read-only user. See step 8 (a) of the Section 3.5, "Creating the Database Schema" section (APR_LINK_USER).

    3. In the RO User Password field, enter the password for the read-only user.

  6. Click the Log File Name field to specify the name of the log file that will store the DBLink creation information. You can click Browse to navigate to the file location, select the file, and Save your selection.

  7. Click OK to create the database link. The system first prompts for the information required to connect to the database as the ARGUS_APP user.

    Surrounding text describes dblinkuser2.jpg.
  8. Enter the ARGUS_APP password and the Argus Safety database information. Click OK.

    The system then prompts for the information to connect to the database as the SYSTEM user.

  9. Enter the password for the SYSTEM user and click OK.

    The system displays the following screen:

    Surrounding text describes appuser.jpg.
  10. Enter the password for the ARGUS_APP user and press Enter. This displays the following command screen:

    Surrounding text describes verfyscrpt3.jpg.
  11. Verify that the script is successfully connected as <ARGUS_APP User Name>@<Argus Safety Database Name> and press Enter.

  12. Press Enter again. Wait until the system reports that the Argus to Insight database link was created successfully:

    Surrounding text describes aisct1.gif.
  13. Click OK.

  14. Check the log files located in the following folder for status information:

    drive:\Program Files\Oracle\ArgusInsight\Database\DBInstaller

  15. Click Close to close the Argus To Insight Database Link Creation dialog box.

3.8 Upgrading Database from Argus Insight 7.0.2 to Argus Insight 7.0.3

Note:

The Argus Insight upgrade process will delete the entire Cognos/BusinessObjects Report Scheduling information from the Argus Insight database. If you intend to retain this information, you must ensure that before starting the upgrade process, you have taken a back-up of this information.

The scheduling information of CIOMS, CIOMS II Line listing and Medwatch reports will still be available after the upgrade process.

To upgrade the database from Argus Insight 7.0.2 to Argus Insight 7.0.3:

  1. Start the Argus Insight Schema Creation Tool.

  2. Click DB Upgrade. The Oracle Database Connect dialog box opens.

    Surrounding text describes systemodc.gif.
  3. Connect to the Oracle Database:

    1. In the Password field, type the password for the SYSTEM user.

    2. In the Database field, type the name of your Argus Insight database.

    3. Click OK. The Upgrade Parameters dialog box opens.

    Surrounding text describes upgrade4.jpg.
  4. Complete the Upgrade Parameters dialog box as follows:

    1. In the top section, verify that the database and upgrade information is correct. If the information is incorrect, click Cancel.

    2. In the Upgrade Parameters section, enter the correct password for each owner and user.

    3. In the Mart Login User field, select the user defined as mart login user (APR_LOGIN user).

  5. Click Next. The Tablespace Management dialog box opens.

    Surrounding text describes upgrade5.jpg.
  6. Verify that all tablespaces have enough free space.

    The green check mark indicates that the tablespace has enough free space.

    If the tablespace does not have enough free space, increase the size of the tablespace by below mentioned methods:

    • Click Add to add a new datafile to the existing tablespace.

      You will be prompted to add a name for the new datafile, containing the required additional space.

    • Alternatively, if you do not wish to add a new data file, the database administrator can resize the tablespace from the back-end.

      After resizing, click the Recalculate button to re-evaluate the tablespace size and refresh the tablespace grid, as per the updated tablespace size.

      Once updated, the Add button will not be displayed and the green check mark will be displayed, indicating that the tablespace has enough free space.

  7. Click Next.

    Surrounding text describes upgrade_continue.gif.
  8. Click Continue to start the upgrade process. During the upgrade process, the system loads the factory data, and then displays a message reminding you to check the Factory_Data folder for any .BAD files.

  9. Click OK to continue. The system executes the upgrade scripts, displays status information during the update, and reports when the update is completed.

    Surrounding text describes upgrade6.jpg.
  10. Click the Book icon to view the log file and check for errors.

    Alternatively, you can view the log file at any time at the following location:

    drive:\Program Files\Oracle\ArgusInsight\Database\Upgrades\UpgradeLog.rtf

  11. Click Finish to close the dialog box.

  12. Once you have upgraded the database from Argus Insight 7.0.2 to Argus Insight 7.0.3, you must create the Read-only user in the Argus Safety database using the steps given in Section 3.5.1, "Creating Users and Roles in the Argus Safety Database".