Database Guide › Oracle Guidelines › Oracle Users › Manually Create a Primary User

Manually Create a Primary User

The procedure for manually creating the Oracle primary user before installing the CMS installation is similar to that for creating a schema owner (see the previous section). That is, you need to run CreateOracleUser.sql and then modify two CA DLP-provided scripts.

To manually create an Oracle primary user

1. If you have not already done so, copy the files CreateOracleUser.sql and WgnSetupOwner.sql to a local folder.
2. From a command line, navigate to the host folder you chose in step 1 and run this command:

   sqlplusw
   

   This launches the Oracle SQL Plus utility and sets the correct working directory for the script execution.

3. In SQL Plus, connect to the CA DLP database as a user with sysdba privileges.
4. Run the following command:

   @CreateOracleUser
   

   The script prompts you for:

   • A user name and password for the new Oracle primary user. You need to supply these credentials when you install your CMS and gateway servers.
   • A tablespace. This must be an existing tablespace.

   Finally, the script outputs a summary of the new account.

5. If you want to change the password or tablespace, rerun the script now.

   Important! You cannot change the password or tablespace after you have installed the CMS!

More information:

Requirements for Oracle Users

Tablespaces for CA DLP