Context creation fails on Oracle

On Oracle, configuration fails because the context could not be created for a site.

Context creation fails for the following reasons:

• The tnsnames.ora file on the reports data warehouse database server does not contain the TNS entry for the BMC Server Automation database or the TNS Name does not match with the SID.
• The tnsnames.ora file on the BMC Server Automation database server does not contain the TNS entry for the reports data warehouse or the TNS Name does not match with the SID.

Solution

To resolve the issue, complete the following steps:

1. Ensure that the following requirements are met:
   • The tnsnames.ora file on the reports data warehouse database server contains the TNS entry for the BMC Server Automation database and the TNS Name matches with the SID.
   • The tnsnames.ora file on the BMC Server Automation database server contains the TNS entry for the reports data warehouse and the TNS Name matches with the SID.
2. Run the postinstallation configuration wizard again.