000033878 - How to add a domain name to the DB service name on tnsnames.ora in RSA Identity Management and Governance

Document created by RSA Customer Support Employee on Jan 18, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033878
Applies ToRSA Product Set:  Identity Management and Governance
RSA Product/Service Type: Hardware Appliance
RSA Version/Condition: 7.0
IssueBy default, tnsnames.ora uses AVDB as the service_name to connect to the Aveksa database, meaning the database is listening locally.
AVDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1555))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AVDB)
)
)

Since the database is currently listening locally, how do we configure it so it can be listened throughout the network?
ResolutionFollow the steps below to configure so it can be listened throughout the network :
  1. Open the /<ORACLE_HOME>/network/admin) e.g. /u01/app/12.1.0/grid/network/admin/tnsnames.ora file in a text editor.  The tnsnames.ora is a configuration file that defines databases addresses for establishing connections to them.
  2. Append the generic top-level domain name (e. g., .COM) to the the SERVICE_NAME value.  For example, change (SERVICE_NAME = AVDB) as follows:

AVDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1555))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AVDB.COM)
)
)


  1. Stop ACM:

$ acm stop


  1. Connect to the database as sysdba and run the below:

$ sqlplus sys/<password> as sysdba
SQL> ALTER DATABASE RENAME GLOBAL_NAME TO AVDB.COM;
SQL> alter system set db_domain="com" scope=spfile sid='*';
SQL> commit;
SQL> exit


  1. Restart the database:

$ acm stoporacle
$ acm startoracle


  1. Open the /home/oracle/Aveksa_System.cfg file in a text editor.  
  2. Change the value of the ORACLE_SERVICE_NAME from ORACLE_SERVICE_NAME=AVDB to ORACLE_SERVICE_NAME=AVDB.COM, as shown:
ORACLE_SERVICE_NAME=AVDB.COM

  1. Start ACM again:

$ acm start

NotesThis solution will only work on a local DB.
 

Attachments

    Outcomes