Disable worklist on the R12 home page
When you login in R12, you could see the workflow notifications listed in the home page. This is an new feature in R12 so that users will get notified whenever…
Read MoreORA-01403: no data found while activating SOURCE CONFIG in shareplex
While activating the config in SOURCE, received below error in event_log Warning 2020-01-12 01:13:51.386794 24843 2012734928 Activation: 13007 – No unique keys or primary key for object id 22581 …
Read MoreDatabase crash with error ORA-03113: end-of-file on communication channel
RAC DATABASE Crash with ORA-03113 error Sometimes, RAC database after clone failed to start with ORA-03113 error. This is because of log_archive_config is not same across all instances of the…
Read MoreORA-19808: recovery destination parameter mismatch
When 2 rac node database started, it throws ORA-19808 error as below. SQL> startup pfile=’/tmp/pfile.ora’; ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated ORACLE instance started. Total System Global…
Read MoreHow to Audit particular table in database?
To set audit: AUDIT [option] [BY user|SESSION|ACCESS] [WHENEVER {NOT} SUCCESSFUL] For example: SQL > audit select on dba_users by access whenever not successful; Audit Succeeded. How to check what object…
Read MoreUseful information about Database audit
Database auditing is the process of recording, monitoring and reporting of the actions performed on a database. It allows the security auditors to observe whether the database users are using…
Read MoreEBS User session expires before Idle time parameter values.
In oracle EBS, user session expires even before the time reaches the value of Idle time profile option. For example, Whatever the timeout setting the user sessions get timed out with the message below:…
Read MoreHow to find invalid objects created by patch using Oracle utility
Every DBA’s will generate pre and post invalid report before patching activity in oracle application environments. Comparing pre and post reports will give an insight about the invalids generated by…
Read MoreEBS Analyzer Bundle Menu – A must know for SYSADMIN/DBA’s
Most of the DBA’s know about many analyzers available in oracle support used for service requests in MOS. Most familiar analyzers for DBA’s are Workflow Analyzer, Concurrent Processing Analyzer ,…
Read MoreHow to find latest recommended patches or patchset in E-business suite?
There are many ways to find latest recommended patch collection or patchset for particual modules in E-business suite. The best way for me is using patchsets.sh tool. Just download from…
Read More