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"

      and

      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 11.2.0.3.0 - 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...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.compy.com)(PORT=1522)))

      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

                                                       OL=TCP)(HOST=192.168.0.15)(P

                                                       ORT=1523)))

       

      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.

       

      Regards,

      Aditya