Database Guide › Database Storage and Partitioning › Run the DDL Scripts › Run the Oracle Scripts: Main Tables

Run the Oracle Scripts: Main Tables

This procedure installs the main database tables for the CMS. There is a separate procedure for installing the Data Warehouse tables.

You run the Oracle scripts from the SQL*Plus utility.

Install the CMS database tables

1. Create the tablespaces required by the scripts, typically:
   • WGN
   • WGNIDX
   • WGNDATA
   • WGNIDX
2. Create the Primary User and (optional) Schema Owner database accounts that you need to install CA DataMinder.

   Verify that all necessary privileges and roles are assigned to these accounts. For details about creating these accounts, see the references at the end of this section.

3. Verify the schema owner and primary user accounts have access to and sufficient quota on the tablespaces created in step 1.
4. Verify that you have modified the Grant_user.sql script to reference the primary user.

   (Optional) Verify that you have modified the Synonyms.sql script to reference the schema owner.

   For details, see Modify the Grant_User and Synonyms Scripts.

5. Copy the modified script files to a location where SQL*Plus can access them.
6. Browse to the folder containing the script files and open Native_Wrapper.sql.
7. Start SQL*Plus, and connect to the database as the user who will own the CA DataMinder schema tables. That is, you must connect as the:
   • Schema owner if you have created a separate schema owner, or
   • Primary user if you have not created a separate schema owner.
8. From the SQL*Plus prompt, type:

   start native_wrapper
   

   This creates the tables and indexes and populates the tables with basic data.

9. Review the native_wrapper.log file to confirm that the script executed correctly.
10. If you have created separate Primary User and Schema Owner accounts, go to step 11.

    If you do not have separate accounts (that is, the primary user also owns the CA DataMinder schema tables), this completes the script installation.

11. Grant the primary user access to the tables you created in step 8, and create synonyms for this user.
    1. Verify that you are connected to the database as the schema owner.
    2. In SQL*Plus, type this command:

       start Grant_user
       

    3. Still in SQL*Plus, reconnect to the database as the primary user. See step 7 for command details.
    4. To create the Oracle synonyms against the primary user, type this command:

       start synonyms
       

    This completes the native script installation for the CMS.

12. (Optional) Run a native script installation for the data warehouse.

    This procedure installs the database tables for the data warehouse. See the next section for details. Complete the data warehouse installation using native scripts before you continue to step 13.

    If you do not want to install the data warehouse using native scripts, you can install the data warehouse when you run the CMS installation wizard (see step 13).

13. Install your CMS. See the reference below for CMS installation details.

    Note: The CMS installation wizard allows you to install the CMS and data warehouse at the same time.

    Important! When you run the CMS installation wizard, you specify the Primary User, Schema Owner accounts in the Database Accounts screen. Do not click the Create User checkboxes for the these accounts! However, you can create an account for the Search User when you run the wizard (you do not need to specify an existing account).

More information:

Manually Create a Schema Owner

Manually Create a Primary User