Creating the Oracle Central Designer database user

  1. On the database server computer, extract the CreateCentralDesignerSchema folder from the product ZIP file.

    Note:

    You must use the ZIP file for the product version being installed, or the Oracle Central Designer database user will not be given the appropriate grants.
  2. From the CreateCentralDesignerSchema folder, run the following command:
    sqlplus <Database Administrator user name>/<Database Administrator password>@<Database> @_task.sql <Central Designer database user name> <Central Designer database user password> <Central Designer tablespace>

    In the previous command:

    • Database Administrator user name / password—Credentials of the database administrator used to create the Oracle Central Designer database user.
    • Database—Alias from the TNSnames.ora file.
    • Central Designer database user name / password—Credentials of the Oracle Central Designer database user account you are creating.
    • Central Designer tablespace—Default value: DESIGNER.

    When you run the Oracle Central Designer installation, you must enter the database parameters set up during this procedure.