Using global_names parameter for Oracle databases

If your company policy requires global_names parameter to be set back to true after the TrueSight Server Automation - Data Warehouse installation is completed, your database administrator must do the following:

1. Log in to SQL Plus as the sysdba user on the Oracle database instance where the TrueSight Server Automation - Data Warehouse user is located.
2. Set the value of the global_names parameter to true.
3. On the database server in your TrueSight Server Automation - Data Warehouse environment, navigate to the ORACLE_HOME/network/admin directory.

4. Ensure that the tnsnames.ora file contains the connection information (TNS Alias) for the TrueSight Server Automation instance and the TrueSight Server Automation - Data Warehouse instance. 

   Click here for an example of the connection information.

   BLDW =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = bldb-xxx-xx.bmc.com)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = blrdw.bmc.com)
       )
     )
   
   BLOGIC =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = bldb-xxx-xx.bmc.com)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = blogic.bmc.com)
       )
     )
5. Configure the database link.
   1. In the TSSADW_DW database, create a new database link with the same name as the TrueSight Server Automation database. For example, ORA121DB.
   2. Navigate to the <TSSA-DWInstallationDirectory>\TSSA-DW\shared\ConfigurationManagement directory.
   3. Open the bds.properties file and update the TSSA_SITE1_SOURCE_DATABASE_LINK_NAME parameter with the new database link name.
      For example, TSSA_SITE1_SOURCE_DATABASE_LINK_NAME=ORA121DB.

   4. Open the command prompt and run the following command to login to the TSSADW_DW database:

      sqlplus <DataWarehouse_Database_User>/< DataWarehouse_Database_User_Password>@<TNS_ENTRY

   5. In the BL_SITE table, update the LINK_NAME field with the new database link name for the corresponding BL_SITE_ID.

      UPDATE TSSADW_DW.BL_SITE SET LINK_NAME = '<newDbLink>' WHERE BL_SITE_ID = <SiteID>;
      For example, UPDATE TSSADW_DW.BL_SITE SET LINK_NAME = 'ORA121DB' WHERE BL_SITE_ID = 1;

   6. Exit the command prompt.

      Exit

   7. Open the command prompt and run the following command to login to the TSSADW_ETL_MASTER database:

      sqlplus <DataWarehouse_ETLMasterDatabase_User>/<DataWarehouse_ ETLMasterDatabase _User_Password>@<TNS_ENTRY>

   8. In the SNP_CONNECT table, update the DSERV_NAME field with the new database link name WHERE I_CONNECT=3000.

      UPDATE TSSADW _ETL_MASTER.SNP_CONNECT SET DSERV_NAME = '<newDbLink>' where I_CONNECT = <correspondingValuetoTheAddedSite>;

      For example, UPDATE TSSADW _ETL_MASTER.SNP_CONNECT SET DSERV_NAME = 'ORA121DB' where I_CONNECT = 3000;

6. Run the ETL process. 
7. Verify that the ETL process is successful. Do the following:
   1. As a TrueSight Server Automation - Data Warehouse administrator (DWAdmin), launch the TrueSight Server Automation - Data Warehouse console.
   2. Click ETL Management > ETL Status to check the status.