OraEasy

Introduction : Oracle Database Auditing is a crucial tool that helps database administrators monitor and record activities occurring within the database environment. By tracking actions such as data modifications, user access, and system changes, auditing provides a detailed record of who did what and when. Types of Auditing in Oracle: Mandatory Auditing : Certain critical actions or users (like SYSDBA) are audited by default without configuration, ensuring that highly sensitive operations are always tracked. Mandatory Auditing refers to the automatic auditing of specific database actions related to highly privileged users and system-level operations. These include: Logons by privileged users such as those connecting with the SYSDBA, SYSOPER, or similar administrative roles. Startup and shutdown operations of the Oracle instance. DDL statements and DML operations affecting the data dictionary and audit infrastructure. ...

Introduction: Oracle Enterprise Manager (OEM) is Oracle’s unified management platform for overseeing the full Oracle technology stack. OEM enables administrators to monitor, configure, and optimize Oracle Databases, Oracle Middleware, Oracle Applications, and Oracle Engineered Systems. It streamlines critical operations such as patching, configuration management, performance diagnostics, and lifecycle automation, ensuring that Oracle workloads remain secure, reliable, and high-performing. In this article, we will see how to configure the OEM on Linux environment step by step. Prerequisites: Below are the minimum requirements for Linux environment. CPU - 2core RAM - 10GB Disk space - 45GB (/u01) & 50GB (/oem) OEM Binary. Download here. Must have root user or sudo access. Disable the firewall. Environment: Hostname oem.oraeasy.com/192.168.1.33 OS OL 7.3 OEM Version 13c Rel...

Introduction: In Oracle Database, it is important to automatically start and stop the database services during server reboots or shutdowns to avoid manual work and ensure smooth operations. Oracle provides built-in scripts dbstart and dbshut for this purpose. By using these scripts with Linux services like systemd or init.d, we can make sure the database and listener start automatically when the server starts and shutdown properly during server shutdown. In this article, we will see how to implement this script step by step. Prerequisites: Must have root user or sudo access. Environment: Hostname orcl.oraeasy.com OS OL9 Database Name ORCLDC Database Version 19.27.0 Oracle Home /u01/app/oracle/product/19.0.0/dbhome_1 Approach: We will use Oracle provided script for auto startup (dbstart) and shutdown (dbshut) and those are located in $ORACLE_HOME/bin . Now l...

Introduction: As Oracle 19c stands as the Long-Term Support (LTS) release in Oracle’s database roadmap, upgrading from Oracle 12c is not merely a version shift—it’s a strategic move to maintain support, unlock advanced features, and ensure long-term performance, stability, and compliance. In this article, we will see how to upgrade the database from 12c to 19c step by step. Methods of Upgradation: Using DBUA (Database Upgrade Assistant) Using Manual method Using autoupgrade.jar We have already covered the upgrade using DBUA and using Manual method. Please visit: Upgrade Using DBUA Upgrade Using Manual Method In this article we will use autoupgrade.jar method for upgrade. Prerequisites: 12c binary installed with database. 19c binary installed without database. Java version should be 8 or later. Download latest autoupgrade.jar file. Click here Sufficient disk space for tablespace & archive growth. Min...