Configuring EAM Advanced Reporting Server for Oracle RAC - HxGN EAM - 12.0.1 - Installation & Upgrade

HxGN EAM Application Installation

Language
English
Product
HxGN EAM
Search by Category
Installation & Upgrade
HxGN EAM Version
12.0.1

Connect the HxGN EAM Advanced Reporting Server to the Oracle RAC configured database server. As a prerequisite you must first configure the HxGN EAM application and ensure it is working for Oracle RAC.

Prior to starting this process if you have any custom reports, export those reports, and then import them back in after this configuration is complete. If you are unfamiliar with the steps for exporting custom reports please see the HxGN EAM Advanced Reporting Author Guide.

  1. Open your Report Server.

  2. Browse to the Oracle install\network\admin directory.

  3. Open tnsnames.ora with a text editor.

  4. In this file you will need two entries one needs to be in the format of Instance Name and the other needs to be in the format of Instance Name_Host see the example below:

    instance.domain.com =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = ####)
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = instance.domain.com)
    )
    )
    instance.domain.com_hostname =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = ####)
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = instance.domain.com)
    )
    )

  5. Save your changes and close this file.

  6. Stop the HxGN EAM Advanced Reporting Server Services.

  7. Empty the Cognos Content Store database.

  8. Copy the ewsconfig.xml from the application server.

  9. Open the [report server]\depconfig\advrep_properties.xml in a text editor.

  10. Search for </instance> in the text editor.

  11. After the </instance> tag add the text <rac>true</rac> and save the file.

  12. Open a command window and go to the [report server]\depconfig directory and run the deploy command.

  13. Once the deploy finishes you will see a successful message.