How to execute empty patching cycle without applying any patch.
n: 12.2 version, we will execute the emptly patching cycle. Can a cutover be run, from fs1 to fs2 outside of patching cycle? For testing purposes, without applying any…
Read MoretxkGenADOPWrapper.pl line 143 ) ERRORCODE = 1 ERRORCODE_END WARNING: [AutoConfig Error Report]
txkGenADOPWrapper.pl line 143 ) ERRORCODE = 1 ERRORCODE_END WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution. Errors are grouped by directory…
Read MoreHow to configure patch file system in R12.2
To re-create or configure the patch file system in ebs. Follow the below step’s to configure the patch file system in R12.2. 1. Run adpreclone.pl on run file system Source…
Read MoreHOW TO RESOLVE THE ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
In this tutorial, we are going to learn about, “How to resolve these ORA ERRORS: ORA-01092, ORA-00704 and ORA-39700”. I got the below type of error while startup the database.…
Read MoreOracle 19c Grid Silent installation
Step by Step installation of 19c Grid software, 1. Download the 19c Grid software from ORACLE, https://www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html 2. Copy Grid sofwatare to Grid home mkdir -p /u01/oracle/product/19.3.0.0/grid unzip the…
Read MoreORA-65114: space usage in container is too high
ORA-65114: space usage in container is too high While an import for a pluggable database and it ran out of space so I tried to resize one of the datafile…
Read MoreORA-20100: Error: FND_FILE failure. Unable to create file in the directory
Problem details: ————— The Concurrent program is getting completed successfully, able to view output & logfile. But in the log file, it shows below error. Oracle error 20100: java.sql.SQLException: ORA-20100:…
Read Moreupload of Context file and templates to database…ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -4063: ORA-04063: package body “APPS.FND_GLOBAL” has errors has been detected in FND_GSM_UTIL.upload_context_file.
Error: upload of Context file and templates to database…ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -4063: ORA-04063: package body “APPS.FND_GLOBAL” has errors has been…
Read MoreScript to Detecting Unindexed Foreign Keys
SELECT table_name, constraint_name, cname1 || Nvl2(cname2,’,’ ||cname2,NULL) ||Nvl2(cname3,’,’ ||cname3,NULL) || Nvl2(cname4,’,’ ||cname4,NULL) ||Nvl2(cname5,’,’ ||cname5,NULL) || Nvl2(cname6,’,’ ||cname6,NULL) ||Nvl2(cname7,’,’ ||cname7,NULL) || Nvl2(cname8,’,’ ||cname8,NULL) columns from ( SELECT b.table_name, b.constraint_name, max(decode( position,…
Read MoreORA-01516: nonexistent log file, data file, or temporary file container in stand by Database
ORA-01516: nonexistent log file, data file, or temporary file container in stand by Database: ============================================================================================= ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01516: nonexistent log file, data…
Read More