You need to determine the optimal length of time for undo retention in your database. Use the following formula to calculate the optimal value of the UNDO_RETENTION parameter: OPTIMAL UNDO_RETENTION…
Read MoreError: Unable to save new item in Master Items form (INVIDITM).Also unable to assign the item to new organization.After saving, nothing happens. No error occurs and no message is shown…
Read MoreError: Executing service control script: /u01/applR12/inst/apps/TEST_linuxerp1/admin/scripts/adoacorectl.sh stop script returned: **************************************************** You are running adoacorectl.sh version 120.13 Stopping OPMN managed OACORE OC4J instance … adoacorectl.sh: exiting with status 150 adoacorectl.sh: check…
Read MorePurging statistics from the SYSAUX tablespace Whenever statistics in the dictionary are modified, old versions of statistics are saved automatically for future restoring. The old statistics are purged automatically at regular…
Read MoreSymptoms: Particular queries are hanging when they are executed from remote Clients and also when using database links. But the smaller queries are successful and run without issues. Example: select…
Read MoreSymptoms: After converting from Snapshot Standby to Physical Standby, managed recovery fails: ORA-00600: internal error code, arguments: [krccckp_scn_low], [723613753], [71234534], [], [], [], [], [], [], [], [], [] Errors…
Read MoreSymptoms: When issued alter database open the below error occurs. ORA-00600: internal error code, arguments: [krcgrsz_bad_shrink] Cause: The issue occurs when Block Change Tracking is enabled Solution: Disable block change…
Read MoreSymptoms: After db upgrade to 12cR2 user log in fails with ORA-1017. Cause: This is due to sec_case_sensitive_logon set to false. sec_case_sensitive_logon parameter is set to true by default in release 12…
Read MoreCause: Setting log_archive_config to null in RAC standby database and Startup of node 2 fails with ORA-16188. Alter system set log_archive_config=” scope=both sid=’*’ Solution: This is due to v$dataguard_config not…
Read MoreThe error occurs when changing expired password after database upgrade to 12cR2. Cause: The SQL client used in Forms 11.1.1.x is not supported against the 12.2.x database Solution: Upgrade the…
Read More