Skip to content

AskDba.org Weblog

  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us
Speeding up Initial data load for Oracle to PostgreSQL using Goldengate and copy command
Amit Bansal

18 March, 2019

Speeding up Initial data load for Oracle to PostgreSQL using Goldengate and copy command

Oracle Goldengate supports Oracle to PostgreSQL migrations by supporting PostgreSQL as a target database, though reverse migration i.e PostgreSQL to Oracle is not supported. One of the key aspect of…

Read Full Recipe
272 views 1:09 pm 0 Comments
Saving AWS RDS and Redshift Billing Costs using Reserved Instances
Amit Bansal

16 March, 2019

Saving AWS RDS and Redshift Billing Costs using Reserved Instances

  In this post, we would understand what are reserved instances, when do you need them and various ways to monitor them in your environment. As more enterprises are embracing…

Read Full Recipe
170 views 10:34 am 0 Comments
Amit Bansal

12 June, 2018

Linux: ssh equivalence and SELinux

This is quick post summarizing issues encountered while setting up ssh equivalence on EC2 instance. I was setting up  RHEL7 EC2 instances and followed below procedure to setup ssh equivalence…

Read Full Recipe
91 views 8:29 pm 0 Comments
Querying RDS PostgreSQL logs using Amazon Athena
Amit Bansal

27 April, 2018

Querying RDS PostgreSQL logs using Amazon Athena

PostgreSQL logs contains useful information which can help in troubleshooting performance issues,auditing and performing historical analysis. Some of items which can be logged are listed below Client connection and disconnection…

Read Full Recipe
220 views 10:02 pm 0 Comments
Migrating Function based indexes from Oracle to PostgreSQL
Amit Bansal

18 January, 2018

Migrating Function based indexes from Oracle to PostgreSQL

In this post, I will share  issue faced while working with function based index in PostgreSQL . I was performing database migration from Oracle to PostgreSQL and used AWS Schema…

Read Full Recipe
118 views 10:34 am 0 Comments
Amit Bansal

14 May, 2017

Update WordPress Installations to >4.7.2

This post is applicable for hosted wordpress installations where auto-updates are disabled. Yesterday, I noticed there was blog post "Hacked by Unknown" on Askdba blog. Post was written by White…

Read Full Recipe
60 views 1:46 pm 0 Comments

Posts navigation

Older posts
Newer posts
Disclaimer!!

This blog reflect our own views and do not necessarily represent the views of our current or previous employers.

The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.

Recent Comments
  • Prabhav Pushkar on MGMTDB: Grid Infrastructure Management Repository
  • Azure BLOB Storage As Remote Backend for Terraform State File - AskDba.org Weblog on Azure Infrastructure Automation With Terraform: Configuration
  • tolu on 11g: Multiple failed login attempt can block New Application connections
  • venkatesh on Retrieving Database SID,Port information from Grid Control repository
  • Patrick on Solving ORA-1031 while connecting as “/ as sysdba” :
Trending
  • Resolving Shutdown Immediate Hang Situations
  • Recreating Database Link
  • Limiting I/O and CPU resources using 11g Oracle Resource Manager
  • Connections to DataBase Hang Including "/ as sysdba"
  • Using SSL to securely connect to Amazon Redshift Cluster
  • Simplified Approach to Resolve ORA-4031
  • Deciding "PROCESSES" parameter value
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 188 other subscribers
Proudly powered by WordPress | Tech Blog WordPress Theme by TheMagnifico
TOP