Database Guide › Database Storage and Partitioning › Run the DDL Scripts › Run the Oracle Scripts

Run the Oracle Scripts

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

1. Create the tablespaces required by the scripts, typically WGN, WGNIDX, WGNDATA, and WGNIDX.
2. Create the database schema owner and primary user accounts needed to install CA DLP.

   Ensure that all necessary privileges and roles are assigned to these accounts.

3. Ensure the schema owner and primary user accounts have access to and sufficient quota on the tablespaces created in step 1.
4. Copy the modified script files to a location where SQL*Plus can access them.
5. Browse to the folder containing the script files and open Native_Wrapper.sql.
6. Start SQL*Plus, and connect to the database as the user who will own the CA DLP 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.
7. From the SQL*Plus prompt, type:

   start native_wrapper
   

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

8. Review the SQL*Plus output to confirm that the script executed correctly.
9. If you have created separate Primary User and Schema Owner accounts, go to step 10.

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

10. You now need to grant the primary user access to the tables you created in step 4, and create synonyms for this user.

    You must still have Native_Wrapper.sql open in SQL*Plus and be connected to the database as the schema owner.

    1. Type the following:

       start Grant_user
       

    2. Still in SQL*Plus, reconnect to the database as the primary user. Type:

       connect <user>/<password>@<SID>_<server>
       

       where:

       • <user>/<password>--Specifies the Oracle primary user for CA DLP and this user’s password.
       • <SID>_<server>--Jointly comprise the connection string. Here, <SID> is the service provider (SID) that identifies the CMS database. The SID corresponds to the SID_NAME value in the listener.ora file on the Oracle host server. <server> is the name or IP address of the database host machine.
    3. To create the Oracle synonyms against the primary user, type:

       start synonyms
       

11. This completes the script installation. You now need to install your CMS.

More information:

Install the CMS

Oracle Users

Storage: Oracle Default Tablespace Configuration