[UNEXPECTED]Error occurred while performing database validations adop R12.2 phase=prepare

Step -1

[appl8020@ghorizon d02]$ . EBSapps.env

  E-Business Suite Environment Information

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

  RUN File System           : /app/8020/d02/fs1/EBSapps/appl

  PATCH File System         : /app/8020/d02/fs2/EBSapps/appl

  Non-Editioned File System : /app/8020/d02/fs_ne

  DB Host: ghorizon.galanaoil.com  Service/SID: CRP

  E-Business Suite Environment Setting

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

  - Enter [R/r] for sourcing Run File System Environment file, or

  - Enter [P/p] for sourcing Patch File System Environment file, or

  - Enter anything else to exit

  Please choose the environment file you wish to source [R/P]:r

  Sourcing the RUN File System ...

[appl8020@ghorizon d02]$ echo $FILE_EDITION

run

[appl8020@ghorizon d02]$ pwd

/app/8020/d02

[appl8020@ghorizon d02]$ adop phase=prepare

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:

Validating credentials...

Initializing...

    Run Edition context  : /app/8020/d02/fs1/inst/apps/CRP_ghorizon/appl/admin/CRP_ghorizon.xml

    Patch edition context: /app/8020/d02/fs2/inst/apps/CRP_ghorizon/appl/admin/CRP_ghorizon.xml

    Patch file system freespace: 30.89 GB

Validating system setup...

    Node registry is valid.

    [ERROR]     Failed to execute SQL statement :

   declare

    l_msg varchar2(4000);

  begin

    ad_zd_adop.adop_database_validations(l_msg);

    dbms_output.put_line(l_msg);

  end;

    [ERROR]     Error Message :

    [UNEXPECTED]Error occurred while performing database validations

[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.

adop exiting with status = 1 (Fail)

[appl8020@ghorizon d02]$

Step 2 –

Solution:
ALTER SYSTEM SET "_system_trig_enabled" = TRUE SCOPE=BOTH;