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
Last Modified: 2023-10-06
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
What is the procedure for backing up and restoring the FIM database in clustered mode 19Number of Views Add Default Security Domain Mappings 17Number of Views RSA Authentication Manager 8.x SNMPGET error: No Such Instance currently exists at this OID 94Number of Views How to troubleshoot 'NIC server is currently not available' 161Number of Views RSA SecurID Software Token for iOS App Currently Unavailable in App Store 58Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Identity Governance & Lifecycle Attribute Synchronization fails with Access Fulfillment Express (AFX) error
Don't see what you're looking for?