How to add a domain name to the DB service name on tnsnames.ora in RSA Identity Management and Governance
2 years ago
Originally Published: 2016-08-26
Article Number
000059325
Applies To
RSA Product Set:  Identity Management and Governance
RSA Product/Service Type: Hardware Appliance
RSA Version/Condition: 7.0
Issue
By 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?
Resolution
Follow 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
Notes
This solution will only work on a local DB.