Article Number | 000033878 |
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 :
- 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:
- 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:
|
Notes | This solution will only work on a local DB. |