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

Windows 2016 - Install AZ CLI & KUBECTL

#AZ CLI msiexec /i https://aka.ms/installazurecliwindows #Kubectl curl.exe -LO "https://dl.k8s.io/release/v1.30.1/bin/windows/amd64...