Setting up authentication

You must set up an authentication method for Oracle databases. There are two types of authentication: external authentication, which is the default, and database authentication.

About this task

You must choose one authentication method, because mixed-mode authentication is not supported.

Setting up external authentication

Procedure

  1. Create user OPS$CCM_ROOT in your Oracle database in order for Rational® Synergy to run. Use the following SQL statement as an example:
    create user OPS$CCM_ROOT identified externally
    default tablespace ccm
    temporary tablespace temp
    quota unlimited on ccm;
  2. Grant the CREATE SESSION and SELECT_CATALOG_ROLE privileges to user OPS$CCM_ROOT as follows:
    grant CREATE SESSION, SELECT_CATALOG_ROLE to OPS$CCM_ROOT;

Setting up remote authentication (optional)

Procedure

If you plan to run on remote engines, you must enable remote authentication. Set the initialization parameter as follows.

  • Set REMOTE_OS_AUTHENT to TRUE
  • Set REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE
  • Set OS_AUTHENT_PREFIX to OPS$

Setting up database authentication

Procedure

For database authentication, you must set the parameters in the following procedure:

  1. Create user CCM_ROOT in your Oracle database in order for Rational Synergy to run. Use the following SQL statement as an example:
    create user CCM_ROOT identified by ccm_root
    default tablespace ccm
    temporary tablespace temp
    quota unlimited on ccm;
  2. Grant the CREATE SESSION and SELECT_CATALOG_ROLE privileges to user CCM_ROOT as follows :
    grant CREATE SESSION, SELECT_CATALOG_ROLE to CCM_ROOT;
  3. Make sure that ccmdb auth -d is run after the installation is completed. This sets the password of the Oracle database user CCM_ROOT.

Feedback