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 MoreDatabase 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 MoreIn 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 MoreEvery 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 MoreMost 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 MoreThere 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 MoreIf you are confused with SSL and TLS, this blog will help you to understand at higher level. Before knowing about SSL, lets know about what is SSL? Secure Socket…
Read MoreUsually, any Service Request created in Oracle requires supported log files and trace files to be uploaded. The usual way of uploading from your desktop to My oracle Support (MOS)…
Read More