Oracle 19c Server

Net Service Name Configuration

Net Service Names Configuration Overview

The configuration data for Net Service Names is stored in the $ORACLE_HOME/network/admin/tnsnames.ora file. Oracle Net Manager is one of several GUIs that can be used to edit and maintain the Net Service Name configuration data in tnsnames.ora.

When the Oracle multitenant database was created, DBCA automatically added the CDB (container database) name as a Net Service Name to the tnsnames.ora file on the DBMS host. However, DBCA does not automatically add to tnsnames.ora a Net Service Name for the PDB (pluggable database) created as part of the multitenant database creation or for additional PDBs created later. So you need to add a Net Service Name entry for each PDB to the tnsnames.ora file on the DBMS host. If you have a split system, you should also add a Net Service Name entry for each PDB to the tnsnames.ora file on the application host.

Add a Net Service Name entry for each PDB to tnsnames.ora

1. Log on the DBMS host as the Oracle software owner.
2. Run the Oracle Net Manager GUI by entering at the Unix prompt:

   % netmgr

3. Navigate to Oracle Net Configuration » Local » Service Naming.
4. From the Edit menu, select Create.
5. Enter these values at the Net Service Name Wizard prompts:

   Prompt	Value
   Net Service Name	net-service-name-for-PDB
   Protocol	TCP/IP
   Host Name	DBMS-hostname
   Port Number	1521
   Service Name	PDB-name.domain-name
   Connection Type	Dedicated Server

     LeasePak requires Oracle dedicated server connections. Do not use Oracle shared server connections.

6. From the File menu, select Save Network Configuration.
7. Repeat steps 3 through 6 for each PDB.
8. Exit Oracle Net Manager.
9. If you have a split system: log on the application host as the Oracle software owner and repeat steps 2 through 8.

Set Unix permissions on tnsnames.ora file

There is a bug in Oracle 19c whereby world users cannot access the tnsnames.ora file on the DBMS host due to insufficient Unix permissions. As a workaround, manually grant read-only Unix permission to world users.

Grant world users (i.e. "other" users) read-only Unix permission for the tnsnames.ora file on the DBMS host:

1. Log on the DBMS host as the Oracle software owner.
2. Enter this command at the Unix prompt:

   % chmod o+r $ORACLE_HOME/network/admin/tnsnames.ora