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
.- Navigate to the following directory:<install_location>/Arcot Systems/dbscripts/
- Navigate to one of the following subdirectories that are based on the database that you are using:
- For Oracle: oracle\
- For Microsoft SQL: mssql\
- 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
- arcot-db-config-for-common-8.1.sqlIf you have installed CA Strong Authentication, donotrun arcot-db-config-for-common-8.1.sql.It already ran when CA Strong Authentication was installed.
- arcot-db-config-for-riskfort-8.1.sql
- (Optional)only if you must create the 3D Secure Channel) arcot-db-config-for-3dsecure-8.1.sql
Only run the script once.