FRM-18108: Failed to load the following objects. Source Module:APPSTAND Source Object: STANDARD_PC_AND_VA Source Module:APPSTAND Source Object: STANDARD_TOOLBAR Source Module:APPSTAND Source Object: STANDARD_CALENDAR Compiling package specification APP_CUSTOM… No compilation errors. We…
Read MoreERROR: ORA-12547: TNS :lost contact when try to connect to Oracle There could be many reasons for the above error, but one of the common issue is due to incorrect…
Read MoreA snapshot controlfile is a read consistent copy of a database controlfile which RMAN creates because the controlfile is changed constantly. The snapshot controlfile must be on a location shared…
Read MoreApplies to: Oracle E-Business Suite Technology Stack – Version 11.5.10.0 to 11.5.10.0 [Release 11.5] Information in this document applies to any platform. Checked for relevance on 25-SEP-2013 Goal How to…
Read MoreWe are going to see about manual database creation on oracle 12c nonCDB When we get the request to create a database on a Linux server. The basic prerequisite we…
Read MoreApplies to: Oracle Applications Manager – Version 12.2.4 and later Information in this document applies to any platform. Symptoms E-Business Suite 12.2 Applications Manager, Rapidclone related issues Cloning the applications…
Read MoreWe got a request to do a schema refresh, We prepared the parfile as below $cat DEV_SCHEMA.par directory=MY_DIR dumpfile=DEV_SCHEMA_%u.dmp logfile=DEV_SCHEMA.log SCHEMAS=DEV_SCHEMA1,DECSCHEMA01 estimate=statistics parallel=8 filesize=2G and ran in background as $ nohup…
Read MoreApplies to: Oracle Applications Manager – Version 12.2.4 and later Information in this document applies to any platform. Symptoms On : 12.2.4 version, Rapidclone While running autoconfig the following error…
Read MorePatch for JSON_TABLE Query Fails with ORA-7445 [__intel_ssse3_rep_memcpy] (Doc ID 2311377.1) Prerequisite : Install OCT Patch : Patch 28662603 – Database Oct 2018 Release Update 12.2.0.1.181016 Make sure Database and listener are…
Read MoreBelow script is for finding the Apex page hits ********************************************************************************************************** /home/oracle/backup/scripts/pagehits.sh . /home/oracle/db.env export SC_LOG=/Backup/pagehits/fms_`date +%d_%b_%H_%M_%Y`.log sqlplus -s <<EOF >>/usr/tmp/tmp1.log connect /as sysdba spool \$SC_LOG select flow_id,step_id,count(*) from FLOWS_030100.WWV_FLOW_ACTIVITY_LOG where…
Read More