If upgrading from 8.1.x, upgrade the Scripted Signal Management
Configuration.
Navigate to the Database directory, for example:
$ cd /u01/stage/Database
Start sqlplus as the Oracle Empirica Signal database user, for example:
$ sqlplus webvdme@<TNS_NAME>
When prompted, enter the password.
Start logging, for example:
SQL> spool <log file name>
Execute the create_product_field_tables.sql script, for
example:
SQL> @create_product_field_tables.sql
<SMC_Id>
Execute the create_configurable_alerts_tables.sql
script, for example: SQL>
@create_configurable_alerts_tables.sql <SMC_Id>
Execute the populate_signalcodelist_table.sql
script, for example: SQL>
@populate_signalcodelist_table.sql <SMC_Id>
Execute the update_signaldrugoverview_view.sql script, for
example:
SQL>
@update_signaldrugoverview_view.sql <SMC_Id>
Exit sqlplus, for example:
SQL> quit
Copy 06_create_drugoverview_view.sql file from
Database/update_ssm folder into the
sigmgt/db subfolder of the Scripted Signal
Management software directory. For instance, if Scripted Signal
Management software installed in
/u01/stage/projects/vaers_prep directory, run the
following command: