OraEasy

Introduction Oracle's Heterogeneous Services lets you query non-Oracle databases directly from an Oracle database through a database link, without a separate ETL pipeline. We covered the MySQL version of this setup in an earlier post; this guide covers connecting Oracle to Microsoft SQL Server specifically, which uses Microsoft's own ODBC driver and command-line tooling rather than MySQL's. While the overall Heterogeneous Services architecture is the same, the driver installation, connectivity testing tools, and a couple of configuration parameters differ enough that it's worth its own walkthrough. Prerequisites Network connectivity established between the source and target environments. Verify with ping or telnet . The Microsoft SQL Server ODBC drivers and tools installed on the Oracle DB server: msodbcsql17 , the Microsoft ODBC Driver 17 for SQL Server mssql-tools , which provides sqlcmd , Microsoft's native command-line query tool unixODBC-devel , the...

Introduction In Oracle, a heterogeneous database link allows you to connect to non-Oracle databases from an Oracle database. This is useful for querying and manipulating data across different database systems, such as SQL Server, MySQL, or others, without needing a separate ETL process just to read data. This article walks through creating an Oracle to MySQL database link step by step, using Oracle's Heterogeneous Services and the ODBC driver for MySQL. Prerequisites Network connectivity established between the source and target environments. Verify with ping or telnet . The MySQL ODBC connector package installed on the Oracle DB server. Verify with rpm -qa | grep mysql . You should see packages similar to: mysql-community-client-8.0.35-1.el8.x86_64 mysql-connector-odbc-8.0.26-1.el7.x86_64 Environment Used in This Guide ## Source Target Database Oracle 19c MySQL IP 192.168.80.33...

Introduction Oracle Database 23ai, released in May 2024, is Oracle's latest long-term support release, introducing over 300 new features designed to integrate artificial intelligence (AI) capabilities directly into enterprise data management. Oracle offers a free version, Oracle Database 23ai Free, which lets you explore and develop with the latest features without incurring any licensing costs. This guide walks through the Oracle Database 23ai Free installation process step by step, using the RPM-based install on Oracle Linux. Prerequisites Below are the minimum requirements for a Linux environment: CPU: 2 cores RAM: 2GB Disk space: 12GB Swap: 1.5 times the amount of RAM OS: Oracle Linux 8/9 or Red Hat Enterprise Linux 8/9 Software Download oracle-database-preinstall-23ai : for Linux 8 or for Linux 9 Oracle Database 23ai: Download RPM Environment Used in This Guide Hostname: oracle23ai OS: OL9 Note: keep enough free space on the / mount point, since ORA...

Introduction In Oracle, a switchover is a role transition operation between the primary and standby databases in a Data Guard environment. A switchover lets you swap roles between the primary and standby databases in a planned, controlled manner, without any data loss. This is typically done for maintenance, patching, hardware testing, or periodic load balancing between data centers, and unlike a failover, it's a graceful operation both databases participate in willingly. Prerequisites Plan for roughly 30 minutes of database downtime during the switchover window. Confirm application and database connectivity are ready at the standby site, since it will become the new primary. Primary and standby databases must be fully in sync before starting. Switching over with a lag risks losing the unapplied redo. Environment Used in This Guide These are the primary and standby details used throughout this walkthrough, following on from our earlier standby database setup guide . ...

Introduction Oracle Data Guard (ODG) is a high-availability, disaster recovery, and data protection feature provided by Oracle Database. It ensures the availability of critical data by maintaining one or more synchronized standby databases as replicas of a primary database. These standby databases can be used for disaster recovery, reporting, or backups, minimizing downtime and data loss in the event of unexpected failures. In this guide, we'll set up a physical standby database step by step. Prerequisites Primary server with Oracle Database software installed and a running database. Standby server with Oracle Database software installed. Network connectivity between the primary and standby servers. Environment Used in This Guide These are the primary and standby server details used throughout this walkthrough. Swap them for your own hostnames, IPs, and SIDs, just keep the values consistent across every step below. Server Primary Standby ...