Tuesday, May 28, 2013

Oracle EBS compile APPS schema without running adadmin

Script to check the invalid objects:

select count(*), object_type 
from dba_objects 
where STATUS='INVALID' 
group by object_type;



SQL> @invobj

  COUNT(*) OBJECT_TYPE
---------- -----------------------
         2 PROCEDURE
      5137 VIEW
        57 TRIGGER
       157 FUNCTION
         3 MATERIALIZED VIEW
        13 SYNONYM
     13749 PACKAGE BODY
      2993 PACKAGE


compile objects via script:


APPS_PASS=apps
SYSTEM_PASS=manager
sqlplus -s APPS/$APPS_PASS @$AD_TOP/sql/adutlrcmp.sql APPLSYS $APPS_PASS APPS $APPS_PASS $SYSTEM_PASS 0 0 NONE FALSE

Ubuntu - Install trivy image scanner

How to Install Trivy Image Scanner on Ubuntu (Step-by-Step Guide) Trivy is a popular open-source vulnerability scanner used in DevSecOps ...