ora2pg oracle to postgres

How to use Ora2pg for Oracle to Postgres Migration

comment 0 Comment time 1 week ago

We will review Ora2pg, great open source solution for migrations to PostgreSQL. All companies have requests to migrate their small databases to postgres. Ora2pg is a great utility full of features. Prerequisites Oracle clientOracle DatabasePostgres DatabasePerl modules DBI DBD:Oracle DBD:PG Latest version of ora2pg Establish You can install oracle client for first connection Or rpm

Read More

Oracle Software

How to Install Oracle Trace File Analyzer (TFA)

comment 0 Comment time 3 months ago

TFA is now called the Autonomous Health Framework (AHF). After this installation you will have (TFA) & ORAchk/EXAchk service. Oracle Trace File Analyzer TFA setup is very simple, please follow the steps below. Download Here Then put the downloaded file in any folder. Login as root. You can run the file. ./ahf_setup Make a note

Read More

Oracle Resource Manager

Limiting Parallel Degree at User Level with Oracle Resource Manager

comment 0 Comment time 5 months ago

Oracle Database Resource Manager allows you to manage multiple workloads within a database that compete for system and database resources. The Resource Manager helps overcome these issues by allowing the database to gain greater control over how hardware resources are allocated. In an environment with multiple concurrent user sessions running jobs with different priorities, not

Read More

Oracle Streams

Database Replication with Oracle 11G Streams

comment 0 Comment time 3 years ago

Starting from Oracle HA (High Availability) products, Oracle Dataguard, RAC and RMAN are the most commonly used products. Oracle Streams emerges as a replication product, but mainly uses Oracle Logical Standby technology. Oracle Streams generally consists of three different processes called Apply, Propagate and Capture. Apply is the process that runs the LCR records in

Read More

golden-gate-step-by-step

Database Replication with Oracle Goldengate 11G İnstallation Step By Step On Oracle Linux

comment 1 Comment time 3 years ago

Oracle’s GoldenGate is a software solution that enables DML, DDL, DCL and TCL replication of existing data between databases. If you want to explain this sentence briefly, thanks to Oracle GoldenGate, we can transfer and operate the records of the transactions performed on the source database on the target databases we want, in real time

Read More

oracle-block-corruption

Oracle Block Corruption Fix

comment 0 Comment time 3 years ago

This post describes how to repair multiple or single-block corruption of data files, including system data files, in the Oracle database. Block corruption is a common source of database outages. Database block becomes corrupted when its content is different from what the Oracle database expects to find. If block corruption is not prevented or repaired,

Read More

Oracle cluster check

Big DBA as one of the Top 100 Oracle Blogs on the web.

comment 0 Comment time 2 months ago

Today I received an email from Anuj Agarwal, founder of Feedspot .Thank you for your attention. I will try to be worthy.

Read More