Setting global_names to true for Oracle databases

Before you set the global_names parameter to true, ensure that the db_domain parameter is configured for the database instances in the environment (BMC Server Automation, the reports data warehouse, and the portal content store instances). Log on to each database server as a sysdba user and type the following query:

SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = 'db_domain';

The value of db_domain is returned. This value should not be blank and should be the appropriate value for your site configuration.

If the db_domain parameter is not configured properly, work with the database administrator to configure it properly for your environment.

To set the global_names parameter to true

1. Log on to your database as a sysdba user and type the following query:

   Alter system set global_names = true scope=both;

2. Ensure that the ORACLE_HOME/network/admin/tnsnames.ora file on all database servers in your BMC Decision Support for Server Automation installation contains the connection information (TNS Alias) for the BMC Server Automation instance, the reports data warehouse instance, and the portal content store instance. 

   The same connection information must be used for all instances, as illustrated in the following examples:

   CP =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = bldb-ora-01.bmc.com)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = cp.bmc.com)
       )
     )
   
   BLDW =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = bldb-ora-01.bmc.com)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = blrdw.bmc.com)
       )
     )
   
   BLOGIC =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = bldb-ora-01.bmc.com)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = blogic.bmc.com)
       )
     )