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
Oracle 12c TEMP_UNDO_ENABLED parameter for managing GTT UNDO activity in RSA Identity Governance & Lifecycle RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Unable to attach a replica instance due to a configuration error when enabling replication for the RADIUS server for RSA A… RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle
Don't see what you're looking for?