Issue: DB reported slowness with the following error in DB ORA-1653: unable to extend table SYS.AUD$ by 5314958 in tablespace SYSTEMORA-1653: unable to extend table SYS.AUD$ by 5314958 in tablespace…
Read MoreDatabase backups fail if the TDE wallet is not in the proper state. The following scenarios can cause this problem If the database was started using SQL*Plus, and the ORACLE_UNIQUENAME environment…
Read MoreIssue : Concurrent request failed with the following error password verify function error Error: java.sql.SQLException: ORA-28001: the password has expired applmgr@of200:/FINOECD1/inst/apps/FINOECD1_of200/appl/fnd/12.0.0/secure $ FNDCPASS apps/apps4doyen 0 Y system/manager SYSTEM APPLSYSPUB PUB…
Read MoreIssue: ADCFGCLONE fails in Autoconfig with gentns error in DB node. Error : StackTrace: java.lang.NullPointerException at oracle.apps.ad.tools.configuration.DataModelHandler.getDBName(DataModelHandler.java:912) at oracle.apps.ad.tools.configuration.NetServiceHandler.registerDbNode(NetServiceHandler.java:981) at oracle.apps.ad.tools.configuration.NetServiceHandler.registerNode(NetServiceHandler.java:1208) at oracle.apps.ad.tools.configuration.NetServiceHandler.processNode(NetServiceHandler.java:2307) at oracle.apps.ad.tools.configuration.NetServiceHandler.main(NetServiceHandler.java:3182) Closing connection Connection Closed instantiate…
Read MoreISSUE:XML reports complete in warning. Error: ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ ORA-06512: at “APPS.FND_CP_OPP_IPC”, line 85 This is a freshly cloned instance and all managers and…
Read MoreWith the following we can add multiple user name and multiple responsibilities through backend. set define off; declare res_user_name varchar2(100); res_app_sn …
Read MoreThe Following query is to get the memory consuming forms sessions. #!/bin/sh ALLPROCS=`ps -ef|grep “f60webmx webfile=” | grep -v grep | tr -s ” ” | cut -f3 -d” “`…
Read MoreThe following query will give the values of some important parameters to be considered post clone. SELECT e.profile_option_name Profile, e.profile_option_id, f.user_profile_option_name User_Profile_Name, c.application_short_name, decode(a.level_id,10001,’Site’,10002,’Application’,10003,’Resp’,10004,’User’) LevelSet_At, decode(a.level_id,10001,’Site’,10002,c.application_short_name, 10003,b.responsibility_name,10004,d.user_name) LValue, nvl(a.profile_option_value,’Is Null’)…
Read More