Automic Workload Automation

Expand all | Collapse all

after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

Jump to Best Answer
  • 1.  after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

    Posted 9 days ago
    Good morning,

    after Upgrade from AE11.2.10 to V12.3.GA.HF3 we observed that no SQL jobs were sucessfully running on those (Oracle RAC) agents.

    Err message:

    PLOG

    2019-11-02 00:12:22 - U02000005 Job 'JOBS.UC4.REORG_DB.SQLEXEC' with RunID '342960657' started.

    2019-11-02 00:12:22 - U02012031 The database driver returned the following error message:

    2019-11-02 00:12:22             IO Error: Invalid connection string format, a valid format is: "host:port:sid"

    2019-11-02 00:12:22 - U02004025 Job-script execution was aborted.


    In V11.2.10 they ran fine and there was definitely no change on job content.

    SQL Agents were upgraded with new ini file (and values from old inifiles took over), so there was no change as well - at least to my best knowledge....

    Any Hints from your side?

    many thanks
    Wolfgang

    ------------------------------
    I know I do NOT really know it!
    ------------------------------


  • 2.  RE: after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

    Posted 9 days ago
    Hi,

    I'm waiting for the support guy who writes: "if you are using one of the latest version of AWA ( = 12.3.1 or 12.2.​4 or 12.1.6) please get in contact with Support to open a ticket. Otherwise update/upgrade your system and check if the problem still exists." ;-)

    Sorry Wolfgang, but I have no idea and cannot help you (besides the hint to upgrade to 12.3 SP1).

    Good luck,
    Tim

    ------------------------------
    Automation Evangelist
    Fiducia & GAD IT AG
    ---
    Mitglied des deutschsprachigen Automic-Anwendervereins FOKUS e.V.
    Member of the German speaking Automic user association FOKUS e.V.
    ------------------------------



  • 3.  RE: after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

    Posted 9 days ago
    Hi Tim,

    Thank you for the kind words, I fear the answer from support as well...

    You are waiting way to long, they (we) did this occasionally :-P

    It is somehow related to oracle OCI - my colleagues found out.

    cheers, Wolfgang


    ------------------------------
    I know I do really know it!
    ------------------------------



  • 4.  RE: after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail
    Best Answer

    Posted 9 days ago
    Hi,
    I had a similar problem regarding ignore useOraClient=1 and I changed the type in the sql-agent-ini from type=ORACLE to type=ORACLE_OCI.
    After restart of the agent everything works fine. It's not documented but it works.
    For the docu of get_connection the type is documented but not for the ini of the sql-agent
    docs.automic.com/documentation/webhelp/english/AA/12.3/...





  • 5.  RE: after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

    Posted 9 days ago
    Hi Christian,

    THX for the hint, will give it  try.

    cheers, Wolfgang

    ------------------------------
    I know I do really know it!
    ------------------------------



  • 6.  RE: after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

    Posted 8 days ago
    Edited by Leon Carroll 8 days ago
    Hi.  I have the same issue and have a support case open - 20098835.  I did the upgrade from 12.2 to 12.3.0_HF3 build date of 25th October and DB events and Oracle Jobs failed.  I had to change all Connection objects from Oracle to Oracle_OCI.  With the SQL_Agent on 12.3.0_HF3  the SQL Jobs failed.
    I upgraded to 12.3.1 (Build 1/11/2019) with the same issue.  I uninstalled the Oracle 12c drivers and installed Oracle 19c.
    The 12.2 SQL agent works but 12.3.0_HF3 or 12.3.1 does not.

    Changing the Agent type in the ini from ORACLE to ORACLE_OCI does work with V12.3.1, and I can run SQL jobs again.  I'll continue testing and checking if the DBService works with the events.





  • 7.  RE: after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

    Posted 8 days ago
    Thanks a lot  guys that (ORACLE to ORACLE_OCI ) worked for me too!.

    KR
    Wolfgang

    ------------------------------
    I know I do really know it!
    ------------------------------



  • 8.  RE: after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

    Posted 8 days ago
    I saw the ORACLE_OCI solution but just out of curiosity, did you have useOraClient=1  in you INI previously?


  • 9.  RE: after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

    Posted 8 days ago
    Edited by Leon Carroll 8 days ago
    Yes, but changing it to 0 did not help.  Jobs still failed when using ORACLE_OCI connections and TNS names.





  • 10.  RE: after Upgrade V12.3 Oracle RAC SQL Agent - Jobs fail

    Posted 7 days ago
    Yes - we did not change it.

    cheers, Wolfgang

    ------------------------------
    Support Info:
    if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
    Otherwise update/upgrade your system and check if the problem still exists.
    ------------------------------