ORA-12547: TNS :lost contact when try to connect to Oracle
ERROR: 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 MoreORA-00245: control file backup failed in Rman backup
A 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 More11i: “APP-FND-01542” Error When Logging Directly Into Forms Via the f60cgi in 11.5.10
Applies 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 MoreManually create database 12c -NON CDB
We 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 MoreAdcfgclone AppsTier Failing During Clone Into When Source And Target Are On Same Host
Applies 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 MoreEXPDP Hangs at Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
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 MoreORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2212698.1)
Applies 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 MoreJSON_TABLE Query Fails with ORA-7445
Patch 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 MoreScript to Find Apex Page hits
Below 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 Moreopatch prereq CheckConflictAgainstOHWithDetail Shows multiple HOME
When 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 More