Clarity PPM

Expand all | Collapse all

PPM 15.2 with Oracle 12.2.0.1 (on-premise)?

  • 1.  PPM 15.2 with Oracle 12.2.0.1 (on-premise)?

    Posted 05-14-2018 04:45 PM

    Is anybody using this combination? Oracle 12.2.0.1 (12 Rc2) is not certified by CA to be installed with V15.2

     

    We are executing a Clarity Database mirror project for reporting purpose and discovered an Oracle Defect that makes us upgrade Oracle from 12.1.0.2 to 12.2.0.1, we are not prepared to do Clarity Upgrade and think that oracle can be much quickly upgraded  and Clarity will follow in next Qtr.

     

    If anybody has this configuration and still running without any issues please let me know.



  • 2.  Re: PPM 15.2 with Oracle 12.2.0.1 (on-premise)?

    Posted 05-17-2018 02:53 AM

    Hi Suhashk_nissan ,

     

    Clarity should run without any issues, though 15.2 is compatible with "Oracle Standard and Enterprise Edition 12.1.0.2.x".

     

    Could you mention the error log which you are facing.

     

    /Shubham



  • 3.  Re: PPM 15.2 with Oracle 12.2.0.1 (on-premise)?

    Posted 05-17-2018 04:49 PM

    Clarity Patch 2 is the answer to this problem.



  • 4.  Re: PPM 15.2 with Oracle 12.2.0.1 (on-premise)?

    Posted 05-25-2018 08:34 AM

    CA PPM 15.2 is indeed officially not supported with Oracle 12.2.0.1 database. But I would not say that you cannot upgrade as of now as I saw that you mentioned you will upgrade the PPM soon. Till then the following thing can help you, else, as per as my knowledge, you might run into different kind of performance issues.

     

    For Oracle 12c R2 (12.2.0.1), enable the following parameter and set the optimizer to 12.1.0.2.

    To improve performance, database administrators can run the following commands:


    sqlplus / as sysdba
    ALTER SYSTEM SET "_fix_control" = '17800514:0';
    ALTER SYSTEM SET OPTIMIZER_FEATURES_ENABLE= '12.1.0.2' SCOPE=BOTH;
    Exit;

     

    Best of luck!!!