Prerequisites for locating BMC Remedy AR System Server and BMC IT Business Management Suite databases separately

If your BMC Remedy AR System Server database is located on a network separate from the BMC IT Business Management Suite database, you must meet the following prerequisites before installing the application.

• Create a database for BMC IT Business Management Suite.
• Create a link between the BMC IT Business Management Suite database and the BMC Remedy AR System Server database. The database link is required for the integrations between BMC Service Resource Management and BMC Demand and Resource Management to function.
• BMC recommends that you encrypt the BMC Remedy AR System API calls.
• Use the same type of database for both BMC Remedy AR System Server and BMC IT Business Management Suite. For example, if you are using an Oracle database for BMC AR System Server, use an Oracle database for BMC IT Business Management Suite as well.
• The BMC IT Business Management Suite application server and the BMC IT Business Management Suite database server must be collocated to eliminate any significant network latency.
• Run the BMC IT Business Management Suite installation program on the same computer on which you install the BMC IT Business Management Suite database.
• The following communication ports must be open between the BMC Remedy AR System and the BMC IT Business Management Suite environments:
  • BMC IT Business Management Suite database server: port 1521 (Oracle)/ port 1433 (MSSQL)
  • BMC Remedy AR System Server: portmapper-specified port
  • BMC Remedy AR System Server database: port 1521 (Oracle)/ port 1433 (MSSQL)

  • BMC IT Business Management Suite application server: port 8080/9090 (depending on where JBoss is listening) 

    Warning

    Note

    These ports are typically used to communicate to databases. However, if other ports have been configured for this purpose, then they must be opened.

Prerequisite specific to Microsoft SQL Server databases

In deployments using SQL Server databases, you must enable network DTC access:

• Enable Network DTC Access on all nodes participating in the distributed transaction.
• Enable Allow Remote Clients.
• Enable Allow Outbound on the BMC Remedy AR System database node.
• Enable Allow Inbound on the BMC IT Business Management Suite database node.
• Enable XACT_ABORT on the BMC Remedy AR System database. From the Server Properties dialog box, select Connections in the Select a Page pane, and select the xact abort check box in the Default connection options panel.
  
  After enabling XACT_ABORT, you must restart the BMC Remedy AR System Server, because the BMC Remedy AR System Server maintains the database connection pool and changes in the database Server connection properties are not reflected in the existing database connection sessions. After BMC Remedy AR System is restarted, new database connection sessions are created, and then the distributed transactions over remote views start working.

If the distributed transactions over remote views do not work, then read Troubleshooting-DTC-communication-through-a-firewall-using-RPC and perform the procedures described in it.

Prerequisites specific to Oracle databases

On the BMC Remedy AR System computer, edit the TNSNAMES.ORA file to add the connection strings for establishing connections to the BMC IT Business Management Suite database.