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
Add a Security Domain 35Number 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 RSA SecurID Software Token for iOS App Currently Unavailable in App Store 58Number of Views How to troubleshoot 'NIC server is currently not available' 161Number of Views
Trending Articles
Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update Authentication Manager How to Retrieve the LDAPS Certificate and Configure an External Identity Source to Use LDAPS
Don't see what you're looking for?