Modifying Database Server Properties

You can modify the database server properties.

Notes:

  • For information on the Oracle or Microsoft SQL permissions required by ALM, refer to theMicro Focus Application Lifecycle Management Installation and Upgrade Guide.

  • You can configure the site administration database schema for Oracle RAC support. For details, refer to the Micro Focus Application Lifecycle Management Installation and Upgrade Guide.

  • For debugging issues related to closure, see the DEBUG_CLOSURE_LOG_DOM_PROJ site parameter.

To modify database server properties:

  1. In Site Administration, click the DB Servers tab.

  2. Select a database server in the Database Servers list.

  3. To modify the connection string, click the Edit Connection String button , or click the Connection String link. Edit the connection string in the Connection String Editor and click OK. For details on connection strings, see Defining New Database Servers.

  4. To modify the database administrator's login name, click the Database Administrator User Name link. In the Database Administrator User Name dialog box, type the new login name and click OK.

    For details on defining a new login name for a database administrator, see step 5 under Defining New Database Servers.

  5. To modify the database administrator's password, click the DatabaseAdministrator Password button , or click the Database Administrator Password link. In the Database Administrator Password dialog box, type the new password and then retype it. Click OK.

  6. To modify the default ALM user password for accessing the database schema, click the Application Lifecycle Management User Password link. In the User Password dialog box, type the new password and retype it. Click OK.

    Note: If you change the ALM user password, you must update the user password in the database server accordingly:

    1. Replace the value of DefaultUserPassword in the siteadmin.xml file with the value of DB_USER_PASS in the dbid.xml file.

    2. Modify the td user password in the database.

    3. Restart the ALM service or restart the server machine.

    4. If you changed the password in the database before changing it in ALM:

      1. Update DB_USER_PASS in the dbid.xml file of each project.

      2. Updated DB_USER_PASS in the PROJECTS table and the DBSERVERS table of the qcsiteadmin_db schema.
  7. To enable text search capabilities in ALM, click the Text Search link.

    If the text search is enabled, you can set the default text search language for the database server in the Default Search Language list.

    For details on text search, see Configuring Text Search.

  8. To check whether you can connect to the database server, click the Ping Database Server button. The DB admin user and password you entered are displayed in the Ping Database Server dialog box. Click OK.

  9. To delete a database server from the Database Servers list, select it and click the Delete Database Server button . Click Yes to confirm.

  10. Click the Refresh Database Servers List button to refresh the database servers list.