Administrator Guide

9.8.4
- 9.9.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.9
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Changing the Listener Port

If the Dynamic Data Masking service runs on a standalone server, you must modify the

tnsnames.ora

file to add a database alias for Dynamic Data Masking service. The

tnsnames.ora

file is a configuration file that defines the addresses that the client uses to connect to the database. When you add a database alias to the file, applications send requests to the Dynamic Data Masking listener instead of the database listener.

Before you change the

tnsnames.ora

file, back up the original copy.

Open

tnsnames.ora

. By default, this file is located in the following location:

<Oracle install directory>/app/oracle/product/<product version>/server/NETWORK/ADMIN

Find the following entry in the

tnsnames.ora

file:

DBNAME=(DESCRIPTION=
		(ADDRESS=(PROTOCOL=TCP)(HOST=dbServer)(PORT=1521))
				(CONNECT_DATA=(SERVICE_NAME=prod.mycompany.com)))

Replace the service listener port and host with the Dynamic Data Masking host and listener port.

The following tnsnames.ora file shows the entry updated with the updated host and listener port.

DBNAME=(DESCRIPTION=   
   (ADDRESS=(PROTOCOL=TCP)(HOST=DynamicDataMasking)(PORT=1525))     
     (CONNECT_DATA=(SERVICE_NAME=prod.mycompany.com)))

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Changing the Listener Port

Changing the Listener Port