OraEasy

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. This guide will walk you through the creation of Oracle to MSSQL Server DB Link step-by-step. Prerequisites: Below are the minimum requirements for Linux environment. 1. Connectivity should be established between source and target environments. Crosscheck with ping or telnet command. 2. MSSQL Server ODBC Drivers should be installed on Oracle DB server. Below are the list of packages. a) msodbcsql17 b) mssql-tools c) unixODBC-devel Environment: ## Source Target Database Oracle MSSQL Server IP 192.168.80.33 10.50.19.5 DB Name ORCLPRD MSSQLDB Port 1521 1433...

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. This article will walk you through the creation of Oracle to MySQL DB Link step-by-step. Prerequisites: Below are the minimum requirements for Linux environment. 1. Connectivity should be established between source and target environments. Crosscheck with ping or telnet command. 2. MySQL connector odbc package should be installed on Oracle DB server. Crosscheck with “rpm -qa|grep mysql” command. mysql-community-client-8.0.35-1.el8.x86_64 mysql-connector-odbc-8.0.26-1.el7.x86_64 Environment: ## Source Target Database Oracle 19c MySQL IP 192.168.80.33 10.192.225.144 DB Name ORCLPRD mysql_db ...

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 of Oracle Database 23ai, known as Oracle Database 23ai Free, which allows users to explore and develop with the latest features without incurring any costs. This guide will walk you through the Oracle Database 23ai installation process step-by-step. Prerequisites: Below are the minimum requirements for Linux environment. 1. CPU - 2core 2. RAM - 2GB 3. Disk space - 12GB 4. Swap - 1.5 time of RAM 5. OS - Oracle Linux 8/9, Red Hat Enterprise Linux 8/9. Software Download: 1. oracle-database-preinstall-23ai : For Linux 8 and for For Linux 9 2. Oracle Database 23ai: Download RPM Environment Used: 1. Hostname: oracle23ai 2. OS: OL9 Note:  Keep enough space in / mount point as ORACLE_H...

Introduction: In Oracle, a switchover is a role transition operation between the primary and standby databases in a Data Guard environment. A switchover allows you to switch roles between the primary and standby databases in a planned manner, without data loss. This is typically done for maintenance, testing, or load balancing. Prerequisites: o Downtime required at Database end for 30 mins. o Application and Database connectivity for Standby site. o Primary and Standby databases should be in sync. Environment: Server Primary Standby Hostname Source Target IP 192.168.80.51 192.168.80.111 OS OEL 9 OEL 9 SID ORCLDC ORCLDR Service Name ORCLDC ORCLDR Now start Switchover activity step by step: 1. Check DB status and sync between Primary and Standby ==> At Prima...

Introduction: Oracle Data Guard (ODG) is a high-availability, disaster recovery, and data protection feature or solution 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. So here we will do Standby database set up in an easy and step by step manner. Prerequisites: o Primary server with Oracle database Software installed and running database. o Standby server with Oracle database Software installed. o Connectivity between Primary and Standby server. Environment: Server Primary Standby Hostname Source Target IP 192.168.80.51 192.168.80.111 OS OEL 9 OEL 9 SID...