Tuesday, April 30, 2019

Resolves Very Long Time to Apply Patches (WLS)

Enhancement for WLS BSU (Smart Update): Resolves Very Long Time to Apply Patches - Especially When Checking for Patch Conflicts (Doc ID 2271366.1)

Thursday, April 25, 2019

Java.lang.OutOfMemoryError: GC

Weblogic 10.3.6 Patching Error Using BSU - "java.lang.OutOfMemoryError: GC overhead limit exceeded" (Doc ID 2007492.1)

Wednesday, April 24, 2019

Online Patching Enablement Patch 13543062 Fails With Error ORA-44305: Service Ebs_patch Is Running (Doc ID 1917886.1)

How to resolve ADOP error  ORA-44305 error.

sqlplus '/as sysdba'
exec dbms_service.STOP_SERVICE('ebs_patch');



Friday, January 11, 2019

TNS-12546,TNS-12560,TNS-00516 Solaris Error: 13: Permission denied




TNS-12546: TNS:permission denied

TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Solaris Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

Go to this hidden directory /var/tmp/.oracle

touch a

touch: cannot create a: Permission denied. After read and write permission to this directory to /var/tmp/.oracle

Then listener able to start...

LSNRCTL>  start SID


Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "SID" has 1 instance(s).
  Instance "SID", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Tuesday, December 18, 2018

EBS 12,2 code level check

SQL> l
  1  select
  2    substr(abbreviation,1,10)
  3  ,substr(codelevel,1,10)
  4  from
  5    ad_trackable_entities
  6  where
  7    abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' )
  8  order by
  9*   abbreviation
SQL> /

SUBSTR(ABB SUBSTR(COD
---------- ----------
ad         C.10
atg_pf     C.7
fnd        C.7
fwk        C.7
icx        D.3
txk        C.10

6 rows selected.

Friday, December 14, 2018

FND_DIAGNOSTICS Is Invalid (Doc ID 2217255.1)

1. Add grant to DBA_DATAPUMP_JOBS view;
sqlplus / as sysdba
SQL> grant select on dba_datapump_jobs to apps;
SQL> alter package APPS.FND_DIAGNOSTICS compile body;


2. Verify that the FND_DIAGNOSTICS object is valid:

SQL> select object_name,status from dba_objects where object_name like 'FND_DIAGNOSTICS';

APPS.AD_ZD_ADOP invalid (Doc ID 2175698.1)

 $grant execute on DBMS_METADATA_UTIL to apps;
$ alter package APPS.AD_ZD_ADOP compile body;

2. Verify the Status of APPS.AD_ZD_ADOP package is valid.