12.2 FNDCPASS Error

[Husain]

Hi Erman,

we are getting error while changing apps password with FNDCPASS

Oracle error -29516: ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359
Uncaught exception Root of all Java exceptions: java.lang.UnsatisfiedLinkError sun.net.PortConfig.getLower0  - USER ( APPS ) has been detected in FND_WEB_SEC.GET_OP_VALUE

[ErmanArslansOracleBlog]

Hi Husain,

First, do the invalid object and java_pool_size checks documented in Original export fails ORA-29516 Aurora Assertion Failure (Doc ID 1171268.1)

[Husain]

I have already java pool size parameter in my pfile.And sql results ;

--select comp_id,comp_name,version,status from dba_registry order by 1;

AMD OLAP Catalog 11.2.0.4.0 INVALID
APS        OLAP Analytic Workspace 11.2.0.4.0 INVALID
CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
CATJAVA Oracle Database Java Packages 11.2.0.4.0 INVALID
CATPROC Oracle Database Packages and Types 11.2.0.4.0 INVALID
CONTEXT Oracle Text 11.2.0.4.0 VALID
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID
ORDIM Oracle Multimedia 11.2.0.4.0 VALID
RAC        Oracle Real Application Clusters 11.2.0.4.0 INVALID
SDO        Spatial 11.2.0.4.0 INVALID
XDB        Oracle XML Database 11.2.0.4.0 VALID
XML        Oracle XDK 11.2.0.4.0 VALID
XOQ        Oracle OLAP API 11.2.0.4.0 VALID


---select owner, object_type, status, object_name from dba_objects
where object_type like '%JAVA%' and status <> 'VALID';


SYS JAVA CLASS INVALID /b74ccd0_ExecutionAgent1
SYS JAVA CLASS INVALID /7e1d8d98_ExecutionAgent2
SYS JAVA CLASS INVALID /1de40116_ExecutionAgent3
SYS JAVA CLASS INVALID /85cda709_ExecutionAgent4
SYS JAVA CLASS INVALID /bc8d77f9_ExecutionAgent5
SYS JAVA CLASS INVALID /a319ea29_ExecutionAgent6
SYS JAVA CLASS INVALID /44ac4c18_ExecutionAgent7
SYS JAVA CLASS INVALID /9df83f46_ExecutionAgent8
SYS JAVA CLASS INVALID /b4b592ec_ExecutionAgent
SYS JAVA CLASS INVALID oracle/scheduler/agent/Worker
SYS JAVA CLASS INVALID /a90b6d0b_FileWatcherRun
SYS JAVA CLASS INVALID /32803cc0_fileWatchRepos
SYS JAVA CLASS INVALID /760a572_DatabaseEntry
SYS JAVA CLASS INVALID /50a5a5ad_fwStartTask
SYS JAVA CLASS INVALID /c84f9cf2_agtFWTrace
SYS JAVA CLASS INVALID /b136a894_Utilities
SYS JAVA CLASS INVALID /9f191242_StreamRedirector
SYS JAVA CLASS INVALID /413c9966_DatabaseListManager
APPS JAVA CLASS INVALID /d2c5f8fe_DBConnectionCache
APPS JAVA CLASS INVALID oracle/apps/fnd/common/FileLog
APPS JAVA CLASS INVALID /33a4d771_FunctionManager
APPS JAVA CLASS INVALID /584c2e1f_FunctionManager1
APPS JAVA CLASS INVALID /d5c606b3_FileLogDisplay
APPS JAVA CLASS INVALID /7f39acb4_LookupCache
APPS JAVA CLASS INVALID /fd145681_DBCFileCache
APPS JAVA CLASS INVALID /2cbb85e5_PoolExample
APPS JAVA CLASS INVALID /50770738_AppsConnection
APPS JAVA CLASS INVALID /ee02a3a6_Client
APPS JAVA CLASS INVALID /c77f0342_MMTT_lines
APPS JAVA CLASS INVALID /9ba85768_wmsjavautil
APPS JAVA CLASS INVALID /62ad1490_Cartonization
APPS JAVA CLASS INVALID /c9004206_DataClass
APPS JAVA CLASS INVALID /40456eef_MMTT_line
APPS JAVA CLASS INVALID /a20f5c7_AssignCarton
APPS JAVA CLASS INVALID /610c5884_Log_utility
APPS JAVA CLASS INVALID /ccb90065_Carton_line
APPS JAVA CLASS INVALID /72ac25dd_Carton_list
APPS JAVA CLASS INVALID /c310fb7b_PMNode
APPS JAVA CLASS INVALID oracle/apps/eam/pm/meter/Meter
APPS JAVA CLASS INVALID /a15e0917_PMNodeVistor
APPS JAVA CLASS INVALID /2b74df2e_PMSchedule
APPS JAVA CLASS INVALID /48bc71c7_UsageRateStrategy
APPS JAVA CLASS INVALID /96345010_PMLogger
APPS JAVA CLASS INVALID /e5348776_RunningContext
APPS JAVA CLASS INVALID /cebef299_EqualWeightStrategy
APPS JAVA CLASS INVALID /96ec0a23_AssetPM
APPS JAVA CLASS INVALID /54b03167_RescheduleVistor
APPS JAVA CLASS INVALID /39ef2cb9_PMNodesIterator
APPS JAVA CLASS INVALID /5c67a10_EvaluateRulesVistor
APPS JAVA CLASS INVALID /b4758481_RuntimeIntervalRule
APPS JAVA CLASS INVALID /d2f86d0a_WriteTableVistor
APPS JAVA CLASS INVALID /a94ecacd_PMEngine
APPS JAVA CLASS INVALID /d02245b3_ServiceDateVistor
APPS JAVA CLASS INVALID /2857d5b5_DBClient
APPS JAVA CLASS INVALID /415b1e5b_DBTimerThread
APPS JAVA CLASS INVALID /9ad64510_DBUrlThread
APPS JAVA CLASS INVALID /657b367f_TimerThread
APPS JAVA CLASS INVALID /931ba817_UrlThread
APPS JAVA CLASS INVALID /9984256c_SuppressVistor
APPS JAVA CLASS INVALID /3e76bead_WebAppsContextStoreE
APPS JAVA CLASS INVALID /d6725ac4_LDAPOperations
APPS JAVA CLASS INVALID /8eefd33b_ConnectionManagerTra
APPS JAVA CLASS INVALID /507067f1_JePTRecSigGen
APPS JAVA CLASS INVALID /5e316ace_CommonsLogger
APPS JAVA CLASS INVALID /4c1aa541_Decryptor

[ErmanArslansOracleBlog]

Your in-db java and some internal packages are invalid.

CATJAVA Oracle Database Java Packages 11.2.0.4.0 INVALID
CATPROC Oracle Database Packages and Types 11.2.0.4.0 INVALID

You need to make them valid first.

[Husain]

Erman,

Catalog and Catproc - How to find what Objects are keeping them Invalid in the Registry (dba_registry) (Doc ID 578841.1)

This document updated the CATPROC component(ultrp.sql)

But it doesn't work for CATJAVA.

Below sql result is ;

Please compile Invalid object /b74ccd0_ExecutionAgent1
Object_id 508899

PL/SQL procedure successfully completed.


how to compile this java class????

---------------------------------------------------------
set serveroutput on;
declare
start_time date;
end_time date;
object_name varchar(100);
object_id char(10);
begin
SELECT date_loading, date_loaded into start_time, end_time FROM registry$
WHERE cid = 'CATJAVA';
SELECT obj#,name into object_id,object_name
FROM obj$
WHERE status > 1 AND
(ctime BETWEEN start_time AND end_time OR
mtime BETWEEN start_time AND end_time OR
stime BETWEEN start_time AND end_time) AND
ROWNUM <=1;
dbms_output.put_line('Please compile Invalid object '||object_name||'
Object_id '||object_id );
EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line('CATPROC can be validated now' );
end;
/

[ErmanArslansOracleBlog]

That document is for "CATALOG, CATPROC  ".
It is not for CATJAVA..

How did you end up with this?
After any patching or upgrade activity? (which patch if it started after patching)
Any errors in the log files of that patching or update activity?