Actions Expresses Priorities
When an Oracle database is installed, a DBSNMP user is provisioned out-of-the-box that is primarily used for monitoring that database… READ MORE
OEM Architecture The configuration that will be used for Oracle Enterprise Manger is a modified level 3 Architecture. This approach… READ MORE
Overview Password rotation is not the most exciting task especially with different type of Oracle Databases like Standalone, RAC & Multitenant and it’s… READ MORE
Basically Shell script with PLSQL Block which changes database user passwords for both standolne and Multitenant databases, it is not… READ MORE
Digital Certificates or Custom Certificates have become an essential part of Cyber Security and are widely used to verify the… READ MORE
On Windows 10, you can create a local user account, or you can create an account that is connected to… READ MORE
Install Attunity Replicate using the AttunityReplicate__X64.exe installation kit. This kit runs on Windows 64-bit (x64) environments. All of the data… READ MORE
The idea is to manage the OEM agent by Oracle Grid CRSCTL utility, so we can manage OEM agent along… READ MORE
Surprisingly, a popular question is about the possibility of using the Enterprise Manager (EM) Job System to replace customer’s numerous… READ MORE
For EMCLI and patching automation, there are two scripts used that generate the patch plan property file(s), create the patch… READ MORE
As per PCI requirements, we need to secure the Web server URL. Therefore we need to replace the built-in self-signed… READ MORE
Overview You will follow 7 high-level steps to complete the process of securing your EM13c environment with custom third-party SSL/TLS… READ MORE
PCI Compliance The Payment Card Industry Data Security Standard (PCI DSS) is a set of security standards designed to ensure… READ MORE
Prerequisites Install the packages rpmdevtools and rpm-build, these packages contain command line like rpmdev-setuptree and rpmbuild that will help to… READ MORE
Download below libraries to your python. pip install csv pip install openpyxl import openpyxl import cx_Oracle #Oracle connection starts here… READ MORE
Python is a popular general purpose dynamic scripting language. With the rise of Frameworks, Python is also becoming common for… READ MORE
Introduction Oracle 12.2 introduced the concept of real-time materialized views, which allow a statement-level wind-forward of a stale materialised view,… READ MORE
Oratop is a utility very similar in nature to the ‘top’ unix OS utility. It provides an almost real-time overview… READ MORE
Encrypt Server/Client data in network traffic i.e., whenever client[customer] triggers a query to Oracle Databases[server] the data transfer in the… READ MORE
Here’s an example of counting logons (established connections) at the listener: By minute: fgrep “23-JUL-2018 10:” listener.log | fgrep “establish”… READ MORE
“I asked my database for a joke, but it returned a NULL value. Guess it doesn’t have a sense of humor.”
~ Gpt
A passionate Dhoni & Basketball fan
If this website has helped you understand your database faster, troubleshoot smarter, or save DBA time — consider buying us a coffee ☕ to fuel future improvements.