Problem Scheduled Request Goes Inactive/On Hold Status Automatically by Concurrent Manager User Cause: It is an oracle bug Solution 1.Apply the Patch -22549247 2.It will give you a newer file…
Read MoreFollow the below steps to resolve program stuck in OPP issues, 1.You will need to check and fix the Invalid FND Objects : select owner, object_name,object_type,status from dba_objects where status =’INVALID’ and object_name like ‘FND%’; 2.AQ$_FND_CP_GSM_OPP_AQTBL tables has a lot of rows and purge is needed select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_T; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_G; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_H; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_I;…
Read More1.Start the Tomcat a.source the java path $ cat tomcat_java.env export JAVA_HOME=/rupdb01/oracle/tomcat/java71_64 export PATH=/rupdb01/oracle/tomcat/java71_64/jre/bin:$PATH b.Go to the tomcat installed location $ cd apache-tomcat-8.5.37/bin c.execute startup.sh $ sh startup.sh Using CATALINA_BASE:…
Read MoreBelow steps for installing tomcat in oracle 1.Pre-req: Install Java 8 For Apache Tomcat 9 to be installed and configured properly, you need to have Java version 8 installed on…
Read MoreBelow is the steps to do export and import in AWS Cloud Environment 1.CONNECT TO PROD AWS CLOUD FROM LOCAL PROD DB sqlplus root/<root_password>@awscld 2.EXPORT DECLARE hdnl NUMBER; BEGIN hdnl := DBMS_DATAPUMP.OPEN( operation => ‘EXPORT’, job_mode => ‘SCHEMA’, job_name=>null); DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => ‘<DUMP_NAME>‘, directory => ‘DATA_PUMP_DIR’, filetype => dbms_datapump.ku$_file_type_dump_file); DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => ‘<EXPDUMP_LOG_NAME>‘, directory => ‘DATA_PUMP_DIR’, filetype => dbms_datapump.ku$_file_type_log_file); DBMS_DATAPUMP.METADATA_FILTER(hdnl,’SCHEMA_EXPR’,’IN (”<SCHEMA_NAME>”)’); DBMS_DATAPUMP.START_JOB(hdnl); END; / 3.CHECK THE STATUS OF THE EXPORT BY USING BELOW QUERY SELECT text FROM table(rdsadmin.rds_file_util.read_text_file(‘DATA_PUMP_DIR’,'<DUMP_LOG_NAME>’)); 4.MOVE THE DUMP FILE TO AWS DEV CLOUD Move the DUMP to AWS DEV CLOUD…
Read MoreAPPLIES TO: Oracle Internet Directory – Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11g] Oracle Fusion Middleware – Version 11.1.1.9.0 to 11.1.1.9.0 [Release Oracle11g] Information in this document applies to RHEL 7/OEL…
Read MoreAPPLIES TO: Oracle Fusion Middleware – Version 11.1.2.2.0 and later Information in this document applies to any platform. ERROR: FMW 11.1.1.9 OID installation or 11.1.2.2 Forms and reports installation on…
Read MoreAPPLIES TO: Oracle HTTP Server – Version 11.1.1.7.0 to 11.1.1.9.0 [Release Oracle11g] Linux x86-64 ERROR: When applying the patches Patch 22290164 and Patch 26610710 on Red Hat 7 or Oracle Linux 7 x86-64 bit,…
Read MoreAPPLIES TO: Oracle Fusion Middleware – Version 12.2.1.0.0 and later Information in this document applies to any platform. ERROR: Running RCU fails with ORA-28104, ORA-06512 Errors when 12.2.x database is used…
Read MoreAPPLIES TO: Oracle EBS Applications Translation – Version 12.1.3 to 12.1.3 [Release 12.1] Information in this document applies to any platform. ERROR: While applying RUP patches 27212160 and 22698083,this error…
Read More