3 Replies Latest reply on Feb 2, 2017 5:21 PM by Prashant Umap

    Demantra application server and EBS Database listener and local_listener value

    Aditya R

      We've an EBS test instance and Demantra associated with it. Recently we had an issue with Demantra application server not coming up.


      TWO_TASK value of EBS application services is "test03"


      the connection string mentioned in data-sources.xml of Demantra application server is "jdbc:oracle:thin:@test.compy.com:1522:test03


      Listener status when we had the issue:


      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.compy.com)(PORT=1522)))

      STATUS of the LISTENER


      Alias                     test03

      Version                   TNSLSNR for IBM/AIX RISC System/6000: Version - Production

      Start Date                11-JUL-2016 23:20:48

      Uptime                    90 days 10 hr. 35 min. 0 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      ON

      Listener Parameter File   /u01/test03/db/tech_st/11.2.0/network/admin/test03_test/listener.ora

      Listener Log File         /u01/test03/db/tech_st/11.2.0/admin/test03_test/diag/tnslsnr/test/test03/alert/log.xml

      Listening Endpoints Summary...


      Services Summary...

      Service "test03" has 1 instance(s).

        Instance "test03", status UNKNOWN, has 1 handler(s) for this service...

      The command completed successfully


      SQL> show parameter local


      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      local_listener                       string      (ADDRESS_LIST=(ADDRESS=(PROTOC




      EBS application services were working fine.


      However, Demantra was not coming up. We changed the local_listener value to "test03", which was its previous value (got that from alert.log). And then Demantra came up.


      Question is If the issue is with local_listener, how EBS application services were working fine and why did Demantra not come up.


      Please help us to understand.