• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
We are trying to determine if our performance problems are hardware or aleph or database configuration. To eliminate differences in Oracle listener, our DBA has the following questions:

When we run p_union_13 does it go through Oracle listener or not?

If it goes through listener, what does the connect string look like? One example of connect string to database is like:
connect abc90/,pawword>@pr166 (this represents username/password@listener connecter)

Resolution:
The usage of the listener, for Oracle and ALEPH running on the same server (i.e., not TWO-TASK), is on the application level and not by a process.

The variable upon which Oracle usage of the listener is determined is defined in aleph_start:
ora_connect_mode=NO_LISTENER

• Article last edited: 10/8/2013