Posts by Doyensys

Unable to Save New Item in Master Items EBS

Error: 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 More

adoacorectl.sh: exiting with status 150 & exiting with status 204

Error: 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 More

Purging the SYSAUX tablespace statistics

Purging 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 More

Query on largetables from remote Client hangs

Symptoms: 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 More

ORA-00600: Internal Error Code, Arguments: [krccckp_scn_low]

Symptoms: After converting from Snapshot Standby to Physical Standby, managed recovery fails: ORA-00600: internal error code, arguments: [krccckp_scn_low], [723613753], [71234534], [], [], [], [], [], [], [], [], [] Errors…

Read More

ORA-00600: internal error code, arguments: [krcgrsz_bad_shrink]

Symptoms: 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 More

ORA-1017 after DB upgrade to 12cR2

Symptoms: 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 More

ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance

Cause: 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 More

ORA-28041 Occurs Attempting to Change an Expired Password through Forms

The 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

Code Review Tools

Code Review plays a essential role in the Software development Life cycle This Result in Higher quality code and avoid the cost and time which we suppose to spend after…

Read More