Create database user accounts

If you are performing a new Oracle Central Coding installation, Oracle recommends that a database administrator performs the following steps before the Oracle Central Coding application is installed.

  1. Download and extract the Oracle Central Coding 7.0.1 product archive.
  2. To create the Central Coding Database User and Coding Platform Database User:
    1. Open a Windows command prompt in the CodingDBSteup folder.
    2. Enter the following command: sqlplus /nolog @CodingDBSetup.sql
    3. Enter the user account information when prompted.
    During the Oracle Central Coding installation, when configuring the two database user accounts, the system administrator can select the options to use existing users, and enter the credentials of the users created during this step.

    Note:

    If you create the Central Coding Database User and Coding Platform Database User during the installation, you must enter the credentials of a user with DBA privileges.
  3. To create the Coding Dictionary Database Administrator User:
    1. Open a Windows command prompt in the CodingDBSteup folder.
    2. Enter the following command: sqlplus /nolog @CreateDictAdminUser.sql
    3. Enter the user account information when prompted.
    In the Dictionary Loader tool, when performing certain operations, such as creating a dictionary repository or a dictionary, the dictionary administrator must enter the credentials of the user you created during this step.