Execute the Batch File

  1. Double-click the setup_centralized_coding_interface_schema.bat file and enter:

    1. Log folder name

    2. Database name

    3. DBA user credentials, such as system and password

    4. RLS schema owner name and password

      Execute the following query to get the RLS schema owner name:

      SELECT owner
      FROM all_objects
      WHERE object_name = PKG_RLS AND object_type = PACKAGE;
      
    5. Argus schema owner name, such as ARGUS_APP and password

    6. Argus Safety role name

    The script creates two users, ARGUS_DMS and DMS_LOGIN, and their tablespaces.

    The Interface schema object is present in the ARGUS_DMS schema.

  2. Enter the following:

    1. Password for user ARGUS_DMS.

    2. Password for user DMS_LOGIN.

    3. Temporary tablespace name.

      If no input is provided, TEMP tablespace is taken by default.

      The script creates two tablespaces: DMS_DATA_01.DBF, and DMS_INDEX_01.DBF.

    4. Path and data file name of the tablespaces, such as:

      C:\APP\ORADATA\DBNAMD\DMS_DATA_01.DBF

      C:\APP\ORADATA\DBNAMD\DMS_INDEX_01.DBF

    5. A log file name

  3. Press Enter when the Users and Roles are located.

  4. Check the log file to validate the successful completion of the script.

  5. Log in to the application and enable the Centralized Coding module.

    Configure Centralized Coding from the dictionary selection page in the Console.