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

apt-key warning when sudo apt update run

Issue: apt-key warning when sudo apt update run Update below file: cat /etc/apt/sources.list.d/download_docker_com_linux_ubuntu.list ...