This chapter provides a complete listing of the tnsnames. This tnsnames. A net service name is an alias mapped to a database network address contained in a connect descriptor. A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect. Clients and database servers that are clients of other database servers use the net service name when making a connection with an application. By default, the tnsnames. Oracle Net will check the other directories for the configuration files. For example, the order checking the tnsnames.
General Syntax of tnsnames.ora
Join Stack Overflow to learn, share knowledge, and build your career. Connect and share knowledge within a single location that is structured and easy to search. I'm using an Oracle 11g R2 database.
Try DataDirect Drivers Now. If using a tnsnames. The following table lists the Oracle driver properties that correspond to tnsnames. To prevent connection information conflicts, do not specify the listed properties if you use a tnsnames. Table Oracle Driver Property Mappings to tnsnames.
The maximum number of prespawned servers the listener creates. Set this value to the average expected number of connections at any given time. This parameter is used to prevent server processes from being immediately shut down after a client disconnects. For greatest efficiency, provide a short time value for this parameter.