AutoSys Workload Automation

 View Only
  • 1.  ORACLE Related Messages appeared in event_demon log

    Posted Aug 13, 2020 06:57 AM
    Hi everyone,

    I had installed AE 1136S8 in redhat 7.8 that is connected to a DB server installed with Oracle DB 19C, and I noticed that when i run "autosyslog -e" command, There are a bunch of these messages printed in the log. (As per the screenshot)

    Can I know what cause these messages to appear and how can this be solved?

    I had tried this method: https://knowledge.broadcom.com/external/article/110166/scheduler-or-application-server-is-stuck.html but, the messages still appear.

    Thank You,
    Best Regards


  • 2.  RE: ORACLE Related Messages appeared in event_demon log

    Posted Aug 13, 2020 11:05 AM

    This looks like probably your database has crashed. Check with you DBA.

     

    If it is in high availability mode, there are couple steps you need to perform before you bring back the application back online, otherwise your databases can go out of sync. Also some changes to your config files may be needed.

     

     

    Regards,

    Sandeep

     

     






  • 3.  RE: ORACLE Related Messages appeared in event_demon log

    Posted Aug 14, 2020 01:47 AM
    Hi Sandeep,

    I have 1 database and 2 scheduling  server.

    The HA mode you mentioned, is about database HA right?

    About the changes to the config file, can I know what changes I need to do?

    Thank You,
    Best Regards


  • 4.  RE: ORACLE Related Messages appeared in event_demon log
    Best Answer

    Posted Sep 14, 2020 12:22 PM
    it's probably timeout settings one the database side. similar to 12cR2 issues. check with DBA about serverside timeout setting

    SQLNET.EXPIRE_TIME=1

    and in tnsnames.ora you may need 
    (ENABLE=broken)
    (RETRY_COUNT=3)

    slow networks can cause this .. 
    Steve C.