How to add a domain name to the DB service name on tnsnames.ora in RSA Identity Management and Governance
Originally Published: 2016-08-26
Article Number
Applies To
RSA Product/Service Type: Hardware Appliance
RSA Version/Condition: 7.0
Issue
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
- 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.
- 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) ) )
- Stop ACM:
$ acm stop
- 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
- Restart the database:
$ acm stoporacle $ acm startoracle
- Open the /home/oracle/Aveksa_System.cfg file in a text editor.
- 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
- Start ACM again:
$ acm start
Notes
Related Articles
Access Manager - Multiple vulnerabilities reported in Spring Source "spring-core-3.0.3.RELEASE.jar" - False Positives 50Number of Views RSA Authentication Manager 8.x SNMPGET error: No Such Instance currently exists at this OID 93Number of Views How to troubleshoot Oracle database ORA-04030 errors in RSA Identity Governance & Lifecycle 196Number of Views Error message "NIC Server is currently not available" displayed for RSA enVision 272Number of Views Cancel a Log Archive Job That is Currently Executing 17Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?