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 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 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 MoreORA-01000: maximum open cursors exceeded – It’s typical error encountered in Oracle database. It happens when too much cursors are opened on an oracle instance. Maximum number of opened cursors…
Read MoreModify the entry in “/etc/fstab” to have persistent settings between reboot of your machine. Here shared segments are set to 3500M. tmpfs /dev/shm tmpfs size=3500M 0 0 remount it mount…
Read Moreyum localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm Loaded plugins: langpacks, ulninfo Examining oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-18c-1.0-1.el7.x86_64 Marking oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm to be installed Resolving Dependencies –> Running transaction check —> Package oracle-database-preinstall-18c.x86_64 0:1.0-1.el7 will be installed –> Processing…
Read MoreSnapshot Carousel This is a repository for periodic point-in-time copies of a PDB. The Snapshot Carousel is ideally suited to development environments that typically require multiple copies of databases at different…
Read MoreOracle Database 18c introduces the concept of a private temporary table—a memory-based temporary table that is dropped at the end of the session or transaction depending on the setup. In…
Read MoreThe new password file location enables you to mount one shared read-only Oracle Home on different systems, making deployment for complex architectures more reliable and simpler. In other words, a…
Read More