Run the Database Scripts

Run the required database scripts to create the database tables.
aa9
Run the required database scripts to create the database tables.
 
Follow these steps:
 
 Verify that you are logged in as the same database user that you created in 
Configure Database Server
.
  1. Navigate to the following directory:
    <
    install_location
    >/Arcot Systems/
    dbscripts
    /
  2. Navigate to one of the following subdirectories that are based on the database that you are using:
    • For Oracle: oracle\
    • For Microsoft SQL: mssql\
  3. Run the scripts in the following order, using the following example as a guide:
For Oracle on Linux:
sqlplus username/password @script-name.sql
For Microsoft SQL Server on Windows:
sqlcmd -U username -P password -I -i script-name.sql
    1. arcot-db-config-for-common-8.1.sql
       If you have installed CA Strong Authentication, do 
      not
       run arcot-db-config-for-common-8.1.sql.It already ran when CA Strong Authentication was installed.
    2. arcot-db-config-for-riskfort-8.1.sql
    3.  
      (Optional) 
      only if you must create the 3D Secure Channel) arcot-db-config-for-3dsecure-8.1.sql 
 Only run the script once.