Execute the Batch File
-
Double-click the setup_centralized_coding_interface_schema.bat file and enter:
-
Log folder name
-
Database name
-
DBA user credentials, such as system and password
-
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;
-
Argus schema owner name, such as ARGUS_APP and password
-
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.
-
-
Enter the following:
-
Password for user ARGUS_DMS.
-
Password for user DMS_LOGIN.
-
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.
-
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
-
A log file name
-
-
Press Enter when the Users and Roles are located.
-
Check the log file to validate the successful completion of the script.
-
Log in to the application and enable the Centralized Coding module.
Configure Centralized Coding from the dictionary selection page in the Console.
Parent topic: setup_centralized_coding_interface_schema.bat