This documentation supports the 9.0 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

Setting database options

Use the Database tab to view and configure information about the database that you are using.

To display and update information about the database

  1. In a browser, open the AR System Administration Console, and click System > General > Server Information.
    The AR System Administration: Server Information form appears.
  2. Click the Database tab.

    AR System Administration: Server Information form — Database tab
    (Click the image to expand it.)

    The information displayed on this tab varies depending on the relational database you have installed.
  3. Edit the options, as needed:

    Database tab fields

    Field NameDescription
    Database TypeDisplays the type of database that the AR System server is using.
    Database Home(UNIX only) Displays the directory path of the underlying database that the AR System server is using.
    Database NameDisplays the name of the database created for AR System in the underlying database server.
    Database VersionDisplays the version of the database that the AR System server is using.
    Database User NameDisplays the user name that BMC Remedy AR System uses to access the database.
    Database Password(Oracle, Microsoft SQL Server databases only) Enables you to define the password that BMC Remedy AR System uses to access the database. The existing password is not displayed. To change the password, enter a value in the Database Password field. The default database password created by BMC Remedy AR System is AR#Admin#. If you changed the password and do not remember it or if you changed it outside AR System and must reflect the change in AR System, log on to the database as the database administrator and change it back to the default. If the encrypted password is in the ar.confconfiguration file, delete it from that file.
    Database Configuration FileDisplays the contents of the ardb configuration file used by the advanced BMC Remedy AR System feature that appends clauses to the SQL statements that create tables and indexes. For more information about the ardb file, see ardb.cfg or ardb.conf.
    System IDID of the Oracle database you are accessing. This option has a value only if you are using an Oracle database.
    Service NameThe two-task environment setting for remote access to an Oracle database. This option has a value only if you are using an Oracle database.
    Database Case SensitiveIndicates whether the database in use is case sensitive. This field is read-only.
    Request ID Uses Clustered Index(Microsoft SQL Server only) Indicates whether AR System creates the Request ID field as a clustered index to boost performance. By default, this option is selected.
    Store CLOB In-Row

    (Oracle databases only) Specifies how Oracle CLOBs are stored:

    • By default, this option is not selected, and CLOBs are created "out row." Out-row CLOBs can cause the database to grow rapidly.
    • If this option is selected, CLOBs are created "in row." In-row CLOBs can degrade CPU performance.

    Note: Before installing BMC Remedy AR System applications, select this option so that all database tables for applications are created in-row.

  4. Click Apply.
Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Jan Hartung

    A quick remark on the "Database Password" field. The password cannot contain the characters !, &, %, ., (,$ and +. Furthermore, when you are using Oracle 12 with the verify option enabled, you cannot change the password, unless your AR system database user is granted the ALTER USER permission.

    Dec 18, 2015 06:38
    1. Prachi Kalyani

      Hello,

      Thank you for your comment. We will update the documentation soon.

      Thanks,

      Prachi

      Dec 21, 2015 03:39
    1. Prachi Kalyani

      Hello,

      Sorry for the delay in response.

      There is restriction by each database for password for special characters and password length.

      The characters are mentioned are restricted by Oracle so they won’t work expected. To use ! char it should be included in double quotes.

      For Oracle 12C there is no need to add extra permission. Customer here is mentioning about verify option may be there is he is using database Verify function to impose more restriction.

       The verify option updates ar.cfg with the new password and does not update the database with new password. You must update the password in database.

      Thanks,

      Prachi

      Apr 28, 2016 03:22