OraEasy

Introduction: In this article, we will see how to configure Shared Listener in Oracle database. It is especially beneficial in environments with many light or intermittent user connections, such as web or application servers. Type of Server: Dedicated Server: It provides one server process per session, offering maximum performance and isolation but using more memory. Shared Server: It allows multiple clients to share a pool of server processes, providing scalability and memory savings but introducing some queue-related latency. Parameters: Below parameters are need to configure for Shared Listener. DISPATCHERS: It specifies one or more dispatcher processes that handle incoming client connections in a Shared Server configuration. LOCAL_LISTENER: It specifies the database how to locate the listener running on the local machine. It ensures the instance registers properly with the listener so clients can connect using shared server, dedicated server,...

Introduction: Oracle Logical Standby database is a type of standby database created and maintained using Oracle Data Guard (ODG), where redo data from the primary database is transformed into SQL statements and applied logically on the standby database. A Logical Standby differs from a Physical Standby by applying redo through SQL apply rather than block-level recovery. This approach keeps the standby database open in read/write mode while it remains in sync with the primary. Logical Standby databases are particularly well suited for environments that require both robust data protection and effective workload offloading, without adding performance overhead to the primary system. In this article, we will configure the Logical Standby. Prerequisites: Oracle Data Guard (Physical Standby) should be configured. For Physical Standby Setup Click here . Verify the unsupported objects for Logical Standby. Tables must have a primary key or unique constraint. Envir...

Introduction: We are going to configure a Bidirectional Golden Gate setup between two Oracle database environments. We will use Oracle Golden Gate 19c classic version. In the previous article we have done the Golden Gate software installation and prepared the database for replication. Please visit below link. Bidirectional Golden Gate - Installation and Preparation In this article, we will configure the Extract & Replicat for bidirectional replication. Scenario: Suppose there are two bracnhes of a company one in Delhi & one in Noida. Both branches have similar business setup but using different database instances. So both databases are being used for read/write operation, thus in order to make both databases in sync we can use Bidirectional Golden Gate setup. Environment: Server Source Target Hostname delhi.oraeasy.com noida.oraeasy.com OS OEL 8.5 OEL 8.5 ...

Introduction: We are going to configure a Bidirectional Golden Gate setup between two Oracle database environments. We will use Oracle Golden Gate 19c classic version. In this article, we will install the Golden Gate software and prepare the database for replication. Scenario: Suppose there are two bracnhes of a company one in Delhi & one in Noida. Both branches have similar business setup but using different database instances. So both databases are being used for read/write operation, thus in order to make both databases in sync we can use Bidirectional Golden Gate setup. Prerequisites: Below are the minimum requirements for Bidirectional Golden Gate setup. Databases should be installed & running in source & target. Connectivity between source & target servers. Free Disk space (approx. 15GB) for Golden Gate binary on both servers. Working TNS entry in tnsnames.ora file for database in both servers. Software Download: Oracle GoldenGate 19c on Linu...