Querying RDS PostgreSQL logs using Amazon Athena

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 Client connection and disconnection messages Failed DB connection request Database sql statement errors Database Fatal Errors Auditing Information Database Lock history Long running queries and Query plan logging High…

AskDba.org Weblog

S3 Bucket – IllegalLocationConstraintException

A quick one !!

Creating bucket failed with “IllegalLocationConstraintException” —

[ec2-user@ip-172-31-33-128 ~]$ aws s3api create-bucket --bucket labtestrand --region us-west-2

An error occurred (IllegalLocationConstraintException) when calling the CreateBucket operation: The unspecified location constraint is incompatible for the region specific endpoint this request was sent to.

Solution —

[ec2-user@ip-172-31-33-128 ~]$
[ec2-user@ip-172-31-33-128 ~]$ aws s3api create-bucket --bucket labtestrand --region us-west-2 --create-bucket-configuration LocationConstraint=us-west-2
{
"Location": "http://labtestrand.s3.amazonaws.com/"
}
[ec2-user@ip-172-31-33-128 ~]$

AWS Pricing Made Easy By Simple Monthly Calculator

With ever changing pricing model and services, its hard to keep track of AWS costing.





If you want to check how much would it cost to have a certain AWS service, tailored to your requirement then use the following Simply Monthly Calculator from AWS.

AWS Price Calculator.

AWS CLI is Boon for DBAs

For most of production RDS databases , we normally have a related EC2 server to access that RDS database through tools like datapump, sqlplus etc.



RDS is great for point and click but if you want to run your own monitoring or other administration related scripts, you need to have an EC2 instance with AWS CLI installed. For example if you want to check the status of RDS instances or if you want to check (more...)

Adventures in AWS land

I admit it…I’m a BTOARCFODBA. I learned computers on BASIC, COBOL, and  a wee bit of Pascal. Add in a smattering of DCL (Digital Control Language) and SQL.

Along the way (c. 1996), I entered the world of Oracle (7.0 to be exact) and became an Oracle DBA. Eventually specializing in diagnosis and optimization. While I have a accomplished a great deal in my career, I feel somewhat stagnated…time to explore new technology.

Amazon (more...)

RMOUG Training Days 2018

So Training Days is coming up in two weeks.  You haven’t registered to attend?  How you feeling about that?

Rocky Mountain Oracle User Group, (RMOUG) has the largest Oracle user group grassroots conference each February.  For the 2018 year, we decided to shake it up with:

  • A new venue, The Westminster Westin Conference Center
  • A new management company, EPS Conference Management
  • A new Training Days Director, Komal Goyal
  • A new management software, (more...)

Migrating Function based indexes from Oracle to PostgreSQL

In this post, I will share  challenges with function based index in PostgreSQL . I was performing database migration from Oracle to PostgreSQL and used AWS Schema Conversion Tool(SCT) for converting the database schema.AWS Schema conversion tool takes care of automatically converting schema from one database engine to other. You can get more information about…

Message Push Listener – Article Update

When I first wrote about Oracle Messaging Cloud we used a service called WebScript.io to make it easy to demonstrate the Message Push Listener. WebScript was essentially what we better know as a Serverless or Functions oriented offering (that is we wrote pieces of code and deployed them without any consideration servers etc). Well as I prepared my demos for Messaging Cloud for the UK Oracle User Group Tech 17 Conference I discovered that (more...)

Query Flat Files in S3 with Amazon Athena

Amazon Athena enables you to access data present in flat files stored in S3 (Simple Storage Service) as if it were in a table in the database. That and you don't have to set up any server or any other software to accomplish that.

That's another glowing example of being 'Serverless.'


So if a telecommunication has hundreds of thousands or more call detail record file in CSV or Apache Parquet or any other (more...)

List of Networking Concepts to Pass AWS Cloud Architect Associate Exam

Networking is a pivotal concept in cloud computing. Knowing it is a must to be a successful Cloud Architect. Of course you won't be physically peeling the cables to put RJ45 connectors on but you must know various facets of logical networking.


You never know what exactly gonna be in the exam but that's what exams are all about. In order to prepare for AWS Cloud Architect Associate exam you must thoroughly read and understand (more...)

Connecting to your AWS Instance with SSH

If you're using our AMIs from the Amazon Marketplace you might need some guidance on connecting using ssh. We've put together the steps below as a guide to help.

How to SSH using Mac/Linux

1. In (more...)

clckwrk Design Blueprint: Oracle e-Business Suite on AWS

Moving to the Cloud Made Simple: A Framework for Oracle e-Business Suite in AWS 

We wouldn’t blame you if you’re not 100% ready to jump into the Cloud, just because that’s what everyone else seems to be doing. Making the right decision for your business means taking a careful look at what exactly the benefits are going to be. How will your systems work in the Cloud? Can Cloud providers like AWS actually meet your (more...)

Navigating the Oracle Licensing Policy Update: A Look at the Facts

If you’re like us, then you’re never far from the pulse when it comes to changes in software licensing. Keeping up to date with this is a safe way to be sure that you’re making the best decisions for your business when it comes to saving costs and operating efficiently. 

The change that we all seem to be struggling to digest is Oracle’s January 2017 update to its online policy document, “Licensing Oracle Software (more...)

Sharing your Files Securely – A How-to Guide for AWS S3


Whatever your industry, this is sure to be something you’ve come across before. You need to share a file with an external business – it might be a client, a partner or an agency. In the old days, we’d just fire it across as an email attachment. But more businesses working together closely means large volumes of confidential information being shared more frequently. 

It’s something that comes up for us pretty regularly. The files (more...)

Enterprise Workloads – what can the cloud do for me?

What exactly can the Cloud do for me? 

We wouldn’t blame you if you’re bored of hearing it: if it’s in the cloud, it must be better. But…why is it better? Before you go ahead with a decision like this one, you’ll want to look at specific, concrete examples of the practical benefits of cloud-based hosting. A solution that matches the needs of one business isn’t guaranteed to be the perfect match for another. (more...)

Moving your Oracle Data to the Cloud with Minimal Downtime


Moving from an on-premise Oracle database to the Cloud can mean a whole host of different challenges, and these are different for every business. One of the things we’ve tackled for larger companies is the problem of migrating a lot of data, with not much time to play with. Big businesses come with big sets of data, and often don’t have time to spare for a lengthy window of downtime. Systems down means money spent, (more...)

AWS Solutions Architect – Associate Certification

Hi All,

I am glad to announce that I have completed AWS Solutions Architect – Associate Level certification

screen-shot-2017-01-16-at-3-36-11-pm

This is a completely new world with lots of opportunities to learn new things.

Below is the list of things that I used for doing the certification. This will be helpful for anyone who is aspiring for AWS solutions architect associate certification.

  • Thanks to acloud.guru for providing complete course material for this certification. It was really helpful. Using this course (more...)

Building Classrooms in the Cloud

Jumpbox Lab Server

Let’s face it: education without interaction is about as effective as shouting origami instructions at a lumberjack who is cutting down trees. Sure, your informative lessons will come in handy when the product of their work finally becomes paper, but it will be long forgotten and ultimately worthless by then. The only way a student is going to learn is if they can put (more...)

NFRs are easy – what about your NFO’s?

You're used to working on your Non-Functional Requirements (NFR's) - we're used to worrying about how secure our systems are, how many users they will support, how resilient they are to the failure of a component. What we're not used to thinking about are Non-Functional Opportunities - (NFO's) what are the unforeseen benefits that the business will find when they use IT?

The cloud blows the non-functional requirement (NFR) out of the water. You want (more...)

G-Cloud – Moving Your Oracle System to Amazon Web Services

G-Cloud was awarded a few weeks ago and we're glad to say that clckwrk were selected as a supplier in the areas of Infrastructure as a Service and Specialist Services.

The services we have on G-Cloud are specifically curated for implementing, moving and managing Oracle systems to the cloud. This is a quick guide for how to combine those services to migrate to the cloud. For public sector users of Oracle technology and applications this is the set (more...)