Installing BMC ITBM for Remote configuration

If you want to separate BMC IT Business Management Suite in a Remote configuration using the Oracle databases, perform the following steps. In addition to the steps performed by the installer, there are steps that should be performed manually.

To install BMC IT Business Management Suite for Remote configuration

At a high level, the steps fall under the following sections:

• Shut down the JBoss Application Server.
• Back up your BMC Remedy Database.
• Create BMC IT Business Management database by creating the Oracle schema named ITBM.

• Export the BMC IT Business Management objects from the ARADMIN schema, including all tables, sequences, indexes, foreign keys, functions/stored procedures, triggers, etc.
  
  

  Information

  Example

  In the following example of the script, the system uses Oracle Data Pump Export (EXPDP), there is existing DP_DIR Oracle directory, and the ARADMIN schema name is assumed. Use this script to export BMC IT Business Management-only objects. You can modify this script as you need.

  expdp system/password@SID schemas=ARADMIN directory=DP_DIR dumpfile=ITBM_ONLY.dmp INCLUDE=TABLE:\"in \(select table_name from all_tables where owner=\'ARADMIN\'and \(table_name like \'ITT_%\' or table_name like \'IDD_%\'\)\)\",SEQUENCE:\"LIKE \'ITS_%\'\",VIEW:\"in \(select view_name from all_views where owner=\'ARADMIN\'and \(view_name like \'ITV_%\' or view_name like \'V_%\'\)\)\",TYPE:\"LIKE \'I%\'\",PACKAGE:\"LIKE \'ITP_%\'\",PROCEDURE:\"LIKE \'%\'\",FUNCTION:\"LIKE \'%\'\" logfile=ITBM_ONLY.log 

• Import the IT Business Management objects into the new IT Business Management database; verify that all objects are intact and functioning. Verify that all data is imported properly.

  Information

  Example

  In the following example of the script, the ITBM schema name is assumed. Use this script to export BMC IT Business Management-only objects. You can modify this script as you need.

  impdp system/password@SID REMAP_SCHEMA=ARADMIN:ITBM TRANSFORM=oid:n directory=DP_DIR dumpfile= ITBM_ONLY.dmp logfile=ITBM.log
• Create the database links for communication.
• Drop the IT Business Management objects from the ARADMIN schema by running the Drop_objects_ora script on the BMC Remedy AR System server.
• Create the remote views.
• Configure the BMC Atrium Integration Engine (AIE) (if it exists) to make the required changes to the installed BMC Remedy AR mappings.
• Reconfigure the JBoss Application Server data sources to point to the IT Business Management schema.