Oracle DB TNS Identifier

Database Connection and Account Details Menu

Description

The TNS identifier of the Oracle instance that the iProcess Engine will connect to.

Value

 

Installation Type

New Installation

Upgrade Installation

Value

The appropriate Oracle Service Name that is the entry in the $ORACLE_HOME/network/admin/tnsnames.ora file for the Oracle instance that you want to use to hold the iProcess Engine tables.

The current Oracle connect string taken from the fifth entry (after the fourth backslash character) on line 9 of the $SWDIR/etc/staffpms file.

You cannot change this value.

Default Value

Either:

—the value of the TWO_TASK environment variable, if that variable is defined in the installing user’s environment.

—no value, if TWO_TASK is not defined.

Note: The TNS Identifier is the only menu item that can be blank (that is, have no value). If this menu item has a value and you want to reset it to have no value, you must type Ctrl + D at the prompt to enter a new value.

 

Node Cluster

If you are installing a slave server, the TNS identifier used must connect to the same database, using the same users, as the master server.

Notes

You must define a TNS identifier if you intend to use:

a TNS connection to the Oracle database (whether it is remote or local).
Oracle’s Transparent Application Failover (TAF) feature (whether the Oracle instance is local or remote).

For more information about TAF and how to set up and configure it, see Setting up Oracle Transparent Application Failover (TAF) and your Oracle documentation.

If a TNS identifier is not defined, the iProcess Engine will attempt to connect to the local Oracle instance, and TAF will not be supported.

Control File Keyword

IPEI_DBIDSTR