We 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 MoreWhen i got a request to apply a patch, i did a prereq check and faced the below error. RAM:oracle$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version…
Read MoreApplies to: Oracle Application Object Library – Version 12.1.1 to 12.1.3 [Release 12.1] Information in this document applies to any platform. Symptoms Unable to login R12 Applications with Sysadmin user…
Read MoreBelow script is for finding the Apex Page Time ********************************************************************************************************** /home/oracle/backup/scripts/pagetime.sh . /home/oracle/db.env export SC_LOG=/Backup/pagetime/fms_`date +%d_%b_%Y_%H_%M`.log sqlplus -s <<EOF >>/usr/tmp/tmp2.log connect /as sysdba spool \$SC_LOG select flow_id,step_id,sum(elap)/count(*) “Average” from FLOWS_030100.WWV_FLOW_ACTIVITY_LOG…
Read MoreWe can use the below script for moving files (like export dumps/RMAN backups) to FTP server for safety purpose. ******************************************************************************************************************** cat /TESTDB/app/bkp_scripts/test_sunday_to_ftp.sh . /home/oracle/test.env USERNAME=”—-Enter your username here—-” PASSWORD=”—-Enter your…
Read MoreError: ======= while creating a database using Database Configuration Assistant (DBCA) the following error is encountered: “Recovery Manager Failed to Restore Datafiles Solution:-1 Check the compatibility of ASM & Database…
Read MoreHow to Backup ORACLE_HOME binaries and Oracle INVENTORY ORACLE_HOME and INVENTORY need to backup before Database / OS level patching Table of Contents ______________________________________ Backup ORACLE_HOME and INVENTORY 1. Shutdown…
Read More