Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Do ALEPH processes require the Oracle Listener?

    • 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
    //doorbell.io feedback widged