ORA-00214: control file version inconsistent Due to the power outage, one of my production database giving the following error. When I try to startup the database the ORA-00214 controlfile inconsistent…
Read MoreCorrupted Redo log Files The unplanned power outage, my development database was not starting up because of Redo log files corrupted. Let’s have a look redo log file corrupt scenario:…
Read MoreAt Doyensys, we firmly believe that commitment and consistency in our services can make a substantial difference in the businesses of our clients. When a US-based floral and gourmet foods…
Read MorePetmate is a leading and trusted pet care solutions firm based in the US. They started in 1959 with kennels and subsequently progressed into making collars, leashes, and other accessories.…
Read MoreAPPLIES TO: Oracle XML Gateway – Version 12.0.0 to 12.1.3 [Release 12 to 12.1] Information in this document applies to any platform. SYMPTOMS Setup xml gateway with trading partner for…
Read MoreAPPLIES TO: Oracle Purchasing – Version 12.1.3 and later Information in this document applies to any platform. SYMPTOMS When attempting to send some Purchase Orders (POs) by XML Gateway after…
Read MoreRemote File Server (RFS) Process: The RFS process runs on the standby database and is responsible for communication between the primary and the standby database. For the log transport service,…
Read MoreWarning: ORA-16826: apply service state is inconsistent with the DelayMins property Workaround: Check DG configuration: DGMGRL> show configuration Configuration – ZEE_DG_CONFIG Protection Mode: MaxPerformance Databases: zee – Primary database zeedr…
Read MoreError: APP-SQLAP-10771: Could not reserve record. Unable to pay the AP invoice in full, Got above error while performing the action –> pay in full Solution: Database lock from another…
Read MoreSome useful fnd scripts which available in $FND_TOP/sql directory FNDATPRG.sql Purge audit trail tables before a given date FNDCPDC2.sql Delete a concurrent program and SRS definition if needed, calls FNDCPDCP.sql…
Read More