AskDba.org Weblog https://askdba.org/weblog/ Oracle DBA Journey to Cloud, DevOps and Big Data.. Sun, 20 Sep 2020 06:45:45 +0000 en-US hourly 1 https://wordpress.org/?v=6.6.2 3933163 How to perform groupby using Python Itertools https://askdba.org/weblog/2020/09/how-to-perform-groupby-using-python-itertools/ https://askdba.org/weblog/2020/09/how-to-perform-groupby-using-python-itertools/#respond Sat, 19 Sep 2020 13:23:45 +0000 https://askdba.org/weblog/?p=3684 Original Post can be viewed at How to perform groupby using Python Itertools

Itertools is a powerful module and is part of python standard library. It provides a set of fast and memory efficient functions. You can learn more...

AskDba.org Weblog

]]> https://askdba.org/weblog/2020/09/how-to-perform-groupby-using-python-itertools/feed/ 0 3684 Using SSL to securely connect to Amazon Redshift Cluster https://askdba.org/weblog/2020/09/using-ssl-to-securely-connect-to-amazon-redshift-cluster/ https://askdba.org/weblog/2020/09/using-ssl-to-securely-connect-to-amazon-redshift-cluster/#respond Fri, 11 Sep 2020 08:06:15 +0000 https://askdba.org/weblog/?p=3658 Original Post can be viewed at Using SSL to securely connect to Amazon Redshift Cluster

Amazon Redshift is fully managed Cloud Datawarehouse from AWS for running analytic workloads. Lot of customers have requirements to encrypt data in transit as part of...

AskDba.org Weblog

]]> https://askdba.org/weblog/2020/09/using-ssl-to-securely-connect-to-amazon-redshift-cluster/feed/ 0 3658 Azure BLOB Storage As Remote Backend for Terraform State File https://askdba.org/weblog/2020/09/azure-blob-storage-as-remote-backend-for-terraform-state-file/ https://askdba.org/weblog/2020/09/azure-blob-storage-as-remote-backend-for-terraform-state-file/#respond Fri, 11 Sep 2020 02:14:27 +0000 https://askdba.org/weblog/?p=3636 Original Post can be viewed at Azure BLOB Storage As Remote Backend for Terraform State File

Terraform supports team-based workflows with its feature “Remote Backend”. Remote backend allows Terraform to store its State file on a shared storage so that any team...

AskDba.org Weblog

]]> https://askdba.org/weblog/2020/09/azure-blob-storage-as-remote-backend-for-terraform-state-file/feed/ 0 3636 Azure Infrastructure Automation With Terraform: Configuration https://askdba.org/weblog/2020/09/azure-infrastructure-automation-with-terraform-configuration/ https://askdba.org/weblog/2020/09/azure-infrastructure-automation-with-terraform-configuration/#comments Fri, 04 Sep 2020 01:03:51 +0000 https://askdba.org/weblog/?p=3510 Original Post can be viewed at Azure Infrastructure Automation With Terraform: Configuration

In this article I will explain how to configure Terraform to automate Azure infrastructure deployments. There are multiple ways to configure Terraform to work with Azure,...

AskDba.org Weblog

]]> https://askdba.org/weblog/2020/09/azure-infrastructure-automation-with-terraform-configuration/feed/ 1 3510 AWS Glue Python shell job timeout with custom Libraries https://askdba.org/weblog/2020/06/aws-glue-python-shell-job-timeout-with-custom-libraries/ https://askdba.org/weblog/2020/06/aws-glue-python-shell-job-timeout-with-custom-libraries/#respond Sat, 13 Jun 2020 07:55:55 +0000 https://askdba.org/weblog/?p=3504 Original Post can be viewed at AWS Glue Python shell job timeout with custom Libraries

AskDba.org Weblog

]]> https://askdba.org/weblog/2020/06/aws-glue-python-shell-job-timeout-with-custom-libraries/feed/ 0 3504 Identifying PostgreSQL Bloat and fixing it without downtime https://askdba.org/weblog/2019/04/identifying-postgresql-bloat-and-fixing-it-without-downtime/ https://askdba.org/weblog/2019/04/identifying-postgresql-bloat-and-fixing-it-without-downtime/#respond Sun, 21 Apr 2019 04:00:46 +0000 https://askdba.org/weblog/?p=3476 Original Post can be viewed at Identifying PostgreSQL Bloat and fixing it without downtime

MVCC (Multi-Version Concurrency Control) feature allows databases to provide concurrent access to data. This allows each SQL statement to see a snapshot of data as it...

AskDba.org Weblog

]]> https://askdba.org/weblog/2019/04/identifying-postgresql-bloat-and-fixing-it-without-downtime/feed/ 0 3476 Speeding up Initial data load for Oracle to PostgreSQL using Goldengate and copy command https://askdba.org/weblog/2019/03/speeding-up-initial-data-load-for-oracle-to-postgresql-using-goldengate-and-copy-command/ https://askdba.org/weblog/2019/03/speeding-up-initial-data-load-for-oracle-to-postgresql-using-goldengate-and-copy-command/#respond Mon, 18 Mar 2019 07:39:30 +0000 https://askdba.org/weblog/?p=3469 Original Post can be viewed at 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...

AskDba.org Weblog

]]> https://askdba.org/weblog/2019/03/speeding-up-initial-data-load-for-oracle-to-postgresql-using-goldengate-and-copy-command/feed/ 0 3469 Saving AWS RDS and Redshift Billing Costs using Reserved Instances https://askdba.org/weblog/2019/03/saving-aws-rds-and-redshift-billing-costs-using-reserved-instances/ https://askdba.org/weblog/2019/03/saving-aws-rds-and-redshift-billing-costs-using-reserved-instances/#respond Sat, 16 Mar 2019 05:04:48 +0000 http://askdba.org/weblog/?p=3462 Original Post can be viewed at 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...

AskDba.org Weblog

]]> https://askdba.org/weblog/2019/03/saving-aws-rds-and-redshift-billing-costs-using-reserved-instances/feed/ 0 3462 Linux: ssh equivalence and SELinux https://askdba.org/weblog/2018/06/linux-ssh-equivalence-and-selinux/ https://askdba.org/weblog/2018/06/linux-ssh-equivalence-and-selinux/#respond Tue, 12 Jun 2018 14:59:03 +0000 http://askdba.org/weblog/?p=3145 Original Post can be viewed at 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...

AskDba.org Weblog

]]> https://askdba.org/weblog/2018/06/linux-ssh-equivalence-and-selinux/feed/ 0 3145 Querying RDS PostgreSQL logs using Amazon Athena https://askdba.org/weblog/2018/04/querying-postgresql-logs-using-amazon-athena/ https://askdba.org/weblog/2018/04/querying-postgresql-logs-using-amazon-athena/#respond Fri, 27 Apr 2018 16:32:19 +0000 http://askdba.org/weblog/?p=3110 Original Post can be viewed at 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...

AskDba.org Weblog

]]> https://askdba.org/weblog/2018/04/querying-postgresql-logs-using-amazon-athena/feed/ 0 3110 Migrating Function based indexes from Oracle to PostgreSQL https://askdba.org/weblog/2018/01/migrating-function-based-indexes-from-oracle-to-postgresql/ https://askdba.org/weblog/2018/01/migrating-function-based-indexes-from-oracle-to-postgresql/#respond Thu, 18 Jan 2018 05:04:31 +0000 http://askdba.org/weblog/?p=3054 Original Post can be viewed at 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...

AskDba.org Weblog

]]> https://askdba.org/weblog/2018/01/migrating-function-based-indexes-from-oracle-to-postgresql/feed/ 0 3054 Update WordPress Installations to >4.7.2 https://askdba.org/weblog/2017/05/update-wordpress-installations-to-4-7-2/ https://askdba.org/weblog/2017/05/update-wordpress-installations-to-4-7-2/#respond Sun, 14 May 2017 08:16:10 +0000 http://askdba.org/weblog/?p=2964 Original Post can be viewed at 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...

AskDba.org Weblog

]]> https://askdba.org/weblog/2017/05/update-wordpress-installations-to-4-7-2/feed/ 0 2964 How To Configure Exadata Database Machine in Enterprise Manager Cloud Control 13c (OEM13c) https://askdba.org/weblog/2016/07/how-to-configure-exadata-database-machine-in-enterprise-manager-cloud-control-13c-oem13c/ https://askdba.org/weblog/2016/07/how-to-configure-exadata-database-machine-in-enterprise-manager-cloud-control-13c-oem13c/#respond Sat, 16 Jul 2016 18:18:41 +0000 http://askdba.org/weblog/?p=2796 Original Post can be viewed at How To Configure Exadata Database Machine in Enterprise Manager Cloud Control 13c (OEM13c)

I have followed the steps in Oracle Documentation link: https://docs.oracle.com/cd/E63000_01/EMXIG/ch2_deployment.htm#EMXIG215 to configure Exadata Database Machine in OEM13c. If you want to configure your Exadata in OEM13c you have...

AskDba.org Weblog

]]> https://askdba.org/weblog/2016/07/how-to-configure-exadata-database-machine-in-enterprise-manager-cloud-control-13c-oem13c/feed/ 0 2796 Is Your Data Center Ready For Exadata Machines!! https://askdba.org/weblog/2016/05/is-your-data-center-ready-for-exadata-machines/ https://askdba.org/weblog/2016/05/is-your-data-center-ready-for-exadata-machines/#comments Tue, 17 May 2016 15:05:46 +0000 http://askdba.org/weblog/?p=2768 Original Post can be viewed at Is Your Data Center Ready For Exadata Machines!!

Before opting to procure Exadata machines, the first thing you need to check is the readiness of your data center to hold these machines. Exadata’s dimensions are...

AskDba.org Weblog

]]> https://askdba.org/weblog/2016/05/is-your-data-center-ready-for-exadata-machines/feed/ 1 2768 Exadata X6-2 Launched https://askdba.org/weblog/2016/04/exadata-x6-2-launched/ https://askdba.org/weblog/2016/04/exadata-x6-2-launched/#respond Fri, 08 Apr 2016 08:34:22 +0000 http://askdba.org/weblog/?p=2751 Original Post can be viewed at Exadata X6-2 Launched

5th April 2016, Oracle announced arrival of Exadata X6-2. Overview of all its capabilities can be found HERE. Check DataSheet for list of hardware components and capacity...

AskDba.org Weblog

]]> https://askdba.org/weblog/2016/04/exadata-x6-2-launched/feed/ 0 2751 Planning Database Hardware Upgrade !!! Consider Oracle Exadata https://askdba.org/weblog/2016/04/planning-database-hardware-upgrade-consider-oracle-exadata/ https://askdba.org/weblog/2016/04/planning-database-hardware-upgrade-consider-oracle-exadata/#respond Thu, 07 Apr 2016 15:35:57 +0000 http://askdba.org/weblog/?p=2745 Original Post can be viewed at Planning Database Hardware Upgrade !!! Consider Oracle Exadata

Upgrading database hardware in an organization is always a cumbersome process. The most time consuming step is, planing for the upgrade, which mainly includes choosing right...

AskDba.org Weblog

]]> https://askdba.org/weblog/2016/04/planning-database-hardware-upgrade-consider-oracle-exadata/feed/ 0 2745 PROCESSED Messages not clearing from Oracle Queue https://askdba.org/weblog/2016/02/processed-messages-not-clearing-from-oracle-queue/ https://askdba.org/weblog/2016/02/processed-messages-not-clearing-from-oracle-queue/#respond Mon, 01 Feb 2016 03:46:46 +0000 http://askdba.org/weblog/?p=2730 Original Post can be viewed at 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...

AskDba.org Weblog

]]> https://askdba.org/weblog/2016/02/processed-messages-not-clearing-from-oracle-queue/feed/ 0 2730 12.1.0.2 PDB fails to come out of restricted mode https://askdba.org/weblog/2015/07/12-1-0-2-pdb-fails-to-come-out-of-restricted-mode/ https://askdba.org/weblog/2015/07/12-1-0-2-pdb-fails-to-come-out-of-restricted-mode/#comments Fri, 03 Jul 2015 17:20:57 +0000 http://askdba.org/weblog/?p=2662 Original Post can be viewed at 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...

AskDba.org Weblog

]]> https://askdba.org/weblog/2015/07/12-1-0-2-pdb-fails-to-come-out-of-restricted-mode/feed/ 2 2662 ORA-01873 error running SAP pre-upgrade scripts https://askdba.org/weblog/2015/03/ora-01873-error-running-sap-pre-upgrade-scripts/ https://askdba.org/weblog/2015/03/ora-01873-error-running-sap-pre-upgrade-scripts/#respond Mon, 30 Mar 2015 05:00:33 +0000 http://askdba.org/weblog/?p=2633 Original Post can be viewed at ORA-01873 error running SAP pre-upgrade scripts

While trying to run pre_upgrade_status.sql script for DB upgrade (10.2.0.4 to 11.2.0.4), we got following error @pre_upgrade_status.sql ERROR at line 1: ORA-01873: the leading precision of...

AskDba.org Weblog

]]> https://askdba.org/weblog/2015/03/ora-01873-error-running-sap-pre-upgrade-scripts/feed/ 0 2633 LGWR terminating instance due to error 338 https://askdba.org/weblog/2014/12/lgwr-terminating-instance-due-to-error-338/ https://askdba.org/weblog/2014/12/lgwr-terminating-instance-due-to-error-338/#comments Wed, 24 Dec 2014 06:15:57 +0000 http://askdba.org/weblog/?p=2607 Original Post can be viewed at LGWR terminating instance due to error 338

Recently we came across a issue where our DB crashed with ORA-00338 error . Errors in file /oracle/diag/rdbms/orcl11g/orc11g/trace/orc11g_lgwr_24118.trc: ORA-00338: log 2 of thread 1 is more...

AskDba.org Weblog

]]> https://askdba.org/weblog/2014/12/lgwr-terminating-instance-due-to-error-338/feed/ 3 2607