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

Author: Amit Bansal

Experienced professional with 16 years of expertise in database technologies. In-depth knowledge of designing and implementation of Disaster Recovery / HA solutions, Database Migrations , performance tuning and creating technical solutions. Skills: Oracle,MySQL, PostgreSQL, Aurora, AWS, Redshift, Hadoop (Cloudera) , Elasticsearch, Python
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
Amit Bansal

1 February, 2016

PROCESSED Messages not clearing from Oracle Queue

I was contacted by Dev team to look into Development database where Oracle queue size kept  on increasing. As per them messages were not getting cleared.They were running count on…

Read Full Recipe
188 views 9:16 am 0 Comments
12.1.0.2 PDB fails to come out of restricted mode
Amit Bansal

3 July, 2015

12.1.0.2 PDB fails to come out of restricted mode

This one is a nasty bug :) I was trying to setup Oracle PDB in a test environment for the first time and got stuck with ORA-01035 error [oracle@oracle11g ~]$ sqlplus hr/hr@//oracle11g:1522/engg…

Read Full Recipe
226 views 10:50 pm 2 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
  • Using SSL to securely connect to Amazon Redshift Cluster
  • Connections to DataBase Hang Including "/ as sysdba"
  • ERRORSTACK- Oracle Debugging Event
  • TNS file functionality for PostgreSQL
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