Skip to main content

Posts

Showing posts from 2019

How to find 18c Grid version without connecting to SQLPLUS

How to find Oracle 18c ASM/Grid version without connecting to SQLPLUS < Grid_Home/bin >: +ASM > ./oraversion This program prints release version information. These are its possible arguments: -compositeVersion : Print the full version number: a.b.c.d.e. -baseVersion : Print the base version number: a.0.0.0.0. -majorVersion : Print the major version number: a. -buildStamp : Print the date/time associated with the build. -buildDescription : Print a description of the build. -help : Print this message.

How to Perform Real Application Testing(RAT) using SQL Plus

How to Perform Real Application Testing(RAT) using SQL Plus Real Application Testing (RAT) using SQLPLUS, Step 1. Capture the Load,using DBMS_WORKLOAD_CAPTURE SQL > create directory <DIR NAME> as '<OS Location>';  SQL > exec dbms_workload_capture.start_capture(name => '<Name>', dir => '<CAPTUREDIR>'); <<Simulate the load or Capture during high load time>> SQL > exec dbms_workload_capture.finish_capture(); SQL> exec dbms_workload_capture.export_awr (capture_id => 1); Step 2. Process the load on Snapshot Standby using DBMS_WORKLOAD_REPLAY, SQL > create directory <DIR NAME> as '<OS Location>'; $ cp <Capture load dir created in step 1>* <DIR location of step 2> SQL> exec DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE (capture_dir => '<CAPTUREDIRstep2>'); Step 3. Replay multiple time, SQL> exec DBMS_WORKLOAD_REPLAY.INITIALIZE_REPLAY(repla...

How to setup Goldengate

How to Setup GoldenGate environment. Scope Bi-Directional Replication also known as Active-Active Replication, is a configuration where both databases are used as an active site and applications perform DML/DDL activities on both Databases. The Oracle Golden Gate (OGG) processes are configured to replicate the transactional data of both the source databases back and forth to each other. This document describes the steps to be followed to configure bidirectional replication between source and target. Procedure Database version : 12.1 GoldenGate Version : 12.2 I.                    Prepare source database for replication . Step 1: SQL> SHOW PARAMETER ENABLE_GOLDENGATE_REPLICATION. If parameter value is set as “FALSE” then make it “TRUE”. SQL>ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE; Step 2: Check the current Stream Pool Size SQL> SHO...