Single Sign-On Service › SSO Getting Started Guide › SSO Using CloudMinder as an OAuth Authorization Server › Create the OTK/OIDC Database (Oracle)

Create the OTK/OIDC Database (Oracle)

Create the Layer 7 Oracle tablespaces, and an Oracle user, for your tenant.

Note: Perform this procedure for each tenant for which you configure CA CloudMinder as an external IdP using OAuth. Perform this procedure only once for each tenant, even if the tenant has many OAuth clients.

Follow these steps:

1. Connect to the CloudMinder Oracle database as the system user.

   For example, connect with SQL Developer.

2. Open the following file:

   oracle_oidc.sql
   

3. Save a copy of the file with a name that is specific to the tenant for which you are configuring OAuth.

   For example:

   oracle_oidc_forwardinc.sql
   

4. Replace all instances of <OTKDB-USERNAME> with a user name you choose. Choose a user name that is unique to the current tenant.
5. Replace <OTKDB-PASSWORD> with a password you choose.

   Note: Make a note of the username and password for use later in the configuration process. For an Oracle RAC installation, specify the data file based on the Disk Group Name.

6. For an Oracle RAC installation, modify the Oracle script to specify a disk group name as defined in the Oracle environment. Replace the existing CREATE TABLESPACE query with a query in a form similar to this example:

   CREATE TABLESPACE tbs_<OTKDB-USERNAME>
     DATAFILE '+DATA' 
       SIZE 10M
       REUSE
       AUTOEXTEND ON NEXT 10M MAXSIZE 200M;
   

7. Save and close the file.
8. Execute the modified version of the script.
9. Click Commit.