AWS Systems Manager (SSM) is a managed service by AWS, which is used to configure and manage EC2 instances, other AWS resources, and on-premise VMs/servers at scale. SSM frees you up from having ssh or bastion host access to the remote resources.
Fahd Mirza's Blog About Oracle and Cloud
Blog By Fahd Mirza Chughtai
Sunday, February 10, 2019
Thursday, January 24, 2019
awk -F option
I often need to extract subset of data from one command so that it could be used in another during the DBA tasks performed through shell scripts.
One such requirement is that when you need to feed the name of ASM disks to the querydisks command.
One such requirement is that when you need to feed the name of ASM disks to the querydisks command.
Friday, January 11, 2019
Step by Step Installation of PostgreSQL 11 on Oracle Linux 7
This is quick spit-out of commands, I used on my test virtual machine to install PostgreSQL 11 on Oracle Enterprise Linux 7.
Thursday, November 22, 2018
Quickly Download Oracle Software From My Oracle Support
In order to quickly download Oracle software from My Oracle Support (MOS) to your server or local host, you must have curl or wget installed.
Check these by using:
[oracle@test working]$ which curl
/usr/bin/curl
[oracle@test working]$ which wget
/usr/bin/wget
Check these by using:
[oracle@test working]$ which curl
/usr/bin/curl
[oracle@test working]$ which wget
/usr/bin/wget
Wednesday, November 7, 2018
Goldengate ERROR OGG-02037 Failed to retrieve the name of a missing Oracle redo log.
One extract got abended and wasn't able to start in Oracle Goldengate Version 12.2.0.1.160517 23194417_FBO. The redologs were present but extract was still abended and threw following error in the report file.
Error:
ERROR OGG-02037 Failed to retrieve the name of a missing Oracle redo log.
Solution:
Error:
ERROR OGG-02037 Failed to retrieve the name of a missing Oracle redo log.
Solution:
Thursday, October 11, 2018
Graceful Stop of Goldengate Extract
It's always a good idea to stop extracts after checking if there is any long running transaction in the database being captured. Failing to do so might later result in hung or unstable processes.
Thursday, September 6, 2018
Step by Step: Ansible Role To Setup Oracle ACFS On Multiple Nodes
This post contains step by step instructions for creating an Ansible role acfssetup to setup Oracle ASM Cluster Filesystem (ACFS) on multiple nodes of a cluster. This assumes that Grid Infrastructure 12.1.0.2.0 is already installed on the nodes, and ASM is working fine. This also assumes that there already is Ansible installed on some controller host with ssh equivalency setup between root and Oracle users.
Thursday, August 9, 2018
OPS$Oracle user after Wallet Creation in Oracle 12c
----- In Oracle 12.1.0.2, created the wallet by using below commands:
TEST$ orapki wallet create -wallet "/u01/app/oracle/admin/TEST/wallet" -pwd **** -auto_login_local
Oracle PKI Tool : Version 12.1.0.2
Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved.
Sunday, July 29, 2018
Network Slowness Caused Database Contention That Caused Goldengate Lag
I got paged for a goldengate extract lagging behind. Checked the extract configuration and it was normal extract and it seemed stuck without giving any error in the ggserr.log or anywhere else. It wasn't abended either and was in running state.
Saturday, June 2, 2018
Log Buffer #546: A Carnival Of The Vanities For DBAs
This Log Buffer Edition covers Cloud, Oracle, and PostgreSQL.
Cloud:
Google Maps platform now integrated with the GCP Console
Getting more value from your Stackdriver logs with structured data
Improving application availability with Alias IPs, now with hot standby
Performing a large-scale principal component analysis faster using Amazon SageMaker
Optimized TensorFlow 1.8 now available in the AWS: deep learning AMIs to accelerate training on Amazon EC2 C5 and P3 instances
Subscribe to:
Posts (Atom)