Creating the TNS Names Entries to Connect to the Instance

To add TNS and LISTENER entries you will need to use the netca utility. The <ORACLE_HOME\network\admin\netca.rsp file needed for the netca utility is created by the Oracle Database Configuration Utility. It's content, based on a server called <HOSTNAME> and ORACLE_SID called <ORACLE_SID> looks like the following:

[oracle.net.ca]

INSTALLED_COMPONENTS={"server","net8"}

INSTALL_TYPE=""custom""

LISTENER_NUMBER=1

LISTENER_NAMES={"LISTENER"}

LISTENER_PROTOCOLS={"TCP;1521"}

LISTENER_START=""LISTENER""

NAMING_METHODS={"TNSNAMES","EZCONNECT"}

NSN_NUMBER=1

NSN_NAMES={"PPM"}

NSN_SERVICE={"<ORACLE_SID>"}

NSN_PROTOCOLS={"TCP;<HOSTNAME>;1521"}

Note: The netca.rsp file must exist before running the netca utility.

1. From the Command window, execute the following command:

   <ORACLE_HOME>\bin\netca /silent /responsefile <ORACLE_HOME>\network\admin\netca.rsp

2. A new entry is appended to the <ORACLE_HOME>\network\admin\tnsnames.ora file at the instance creation stage by means of the netca utility.

   This entry, based on a server called <HOSTNAME> and ORACLE_SID called <ORACLE_SID> appears as follows:

   PPM =

   (DESCRIPTION =

   (ADDRESS_LIST =

   (ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME>)(PORT = 1521))

   )

   (CONNECT_DATA =

   (SERVICE_NAME = <ORACLE_SID>)

   )

   )

   Where:

   <HOSTNAME>: The name of the host where the database is installed.

   <ORACLE_SID>: A Primavera Portfolio Management Oracle Instance name which was created. For example, ORCL.

3. A new entry is appended to the <ORACLE_HOME>\network\admin\listener.ora file at the instance creation stage by means of netca utility.

   This entry, based on a server called <HOSTNAME> and ORACLE_HOME called <ORACLE_HOME> appears as follows:

   SID_LIST_LISTENER =

   (SID_LIST =

   (SID_DESC =

   (SID_NAME = CLRExtProc)

   (ORACLE_HOME = <ORACLE_HOME>)

   (PROGRAM = extproc)

   (ENVS = "EXTPROC_DLLS=ONLY:<ORACLE_HOME>\bin\oraclr11.dll")

   LISTENER =

   (DESCRIPTION_LIST =

   (DESCRIPTION =

   (ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME>)(PORT = 1521))

   )

   )

   Where:

   <HOSTNAME>: The name of the host where the database is installed.

   <ORACLE_HOME>: A path to Oracle Home. For example, “C:\oracle\product\11.2.0\db_1”.

4. Ensure the AUTHENTICATION_SERVICES entry is not commented in the <ORACLE_HOME>\network\admin\sqlnet.ora file.

   SQLNET.AUTHENTICATION_SERVICES= (NTS)

Legal Notices | Your Privacy Rights
Copyright © 1998, 2020

Last Published Tuesday, December 8, 2020