Lambda to Start EC2 Instances on schedule and send instant public IP over email to multiple recipients using SNS

Following article will describe how to start EC2 Instances on schedule using Lambda and send the public IP  instantly to multiple recipients over email using SNS. This activity will help to schedule start EC2 instances on a particular time during weekdays and send the public IP of the instances to the development team who useContinue reading Lambda to Start EC2 Instances on schedule and send instant public IP over email to multiple recipients using SNS

RMAN clone from data guard DR to different host and different backup location

This document describe the step to clone database in another host using RMAN from DR (Data gurad) .We need not to connect to source database.Moreover we will use different location for backup. A. Please follow below step for pre-requisites setup mentioned in below url 1.Copy the init parameter file from source . 2.In target placeContinue reading RMAN clone from data guard DR to different host and different backup location

Oracle Database 12c Release 1 (12.1) RAC GRID Infrastructure RHEL Redhat linux 7 VirtualBox

Introduction This document will help to guide you for installation of Oracle 12cR1 RAC grid infrastructure on Virtual Box which is very popular because of shared storage simulation feature. Below is overall requirement in nut-shell. Hostname:-rac1 Physical IP:-192.168.56.101 Private IP:-192.168.100.101 Virtual IP:- 192.168.56.103 Hostname:-rac2 Physical IP:-192.168.56.102 Private IP:-192.168.100.102 Virtual IP:- 192.168.56.104 SCAN name should beContinue reading Oracle Database 12c Release 1 (12.1) RAC GRID Infrastructure RHEL Redhat linux 7 VirtualBox

Database Link Oracle to Heterogeneous Database Systems SAP HANA

1 Background Often in many IT projects (involving Oracle as the primary RDBMS), we face an issue of bringing data from disparate systems. Now, the problem can be solved by implementing any ETL solution which has the required connectors/drivers to connect to different heterogeneous database systems and pull the required data. Often situation demands thatContinue reading Database Link Oracle to Heterogeneous Database Systems SAP HANA

RMAN cloning oracle 12c database RAC to single instance from tape backup to another host in new database name

1.Copy the init parameter file from source . 2.In target place this init file to $ORACLE_HOME/dbs 3.Change following parameter in init file to make it compatible to single instance. Replace original instance name to target name in pfile .For my case it should EBILTST as target. ##Remove following parameters## EBILDR12.__data_transfer_cache_size=0 EBILDR11.__data_transfer_cache_size=0 EBILDR11.__db_cache_size=5939134464 EBILDR12.__db_cache_size=3154116608 EBILDR12.__java_pool_size=234881024 EBILDR11.__java_pool_size=234881024Continue reading RMAN cloning oracle 12c database RAC to single instance from tape backup to another host in new database name

Database proactive patching step (PSU) 26635880 for 12.1.0.2 October 2017

PSU patching for 12.1.0.2:-   First Identify the patch to be downloaded:- Oracle 12.1.0.2 proactive DB patching . Patch number:-26635880.We needed to apply in RHEL 7 64-bit. Please download this patch from Oracle support. We need to follow below link for details of steps:- https://updates.oracle.com/Orion/Services/download?type=readme&aru=21529863   We need to download following OPATCH utility as wellContinue reading Database proactive patching step (PSU) 26635880 for 12.1.0.2 October 2017

Oracle database instance recovery is taking too much time after shutdown immediate

1.We were going to open DB after shutdown immediate but it went hang.In alert log , we could only notice following message for 40 minutes.   Completed: ALTER DATABASE MOUNT Tue Oct 31 01:08:39 2017 ALTER DATABASE OPEN Beginning crash recovery of 1 threadsparallel recovery started with 9 processes Started redo scanTue Oct 31 01:08:58Continue reading Oracle database instance recovery is taking too much time after shutdown immediate

Schedule Start & Stop RDS Instances and Save Money

Introduction If RDS Instances is AWS keep running without 24×7 usage, it can cost you very high in AWS billing. Take following example how idle RDS instances can cost you:- Lets take a medium sized RDS instance db.m4.xlarge (4CPU and 16GB RAM) in Sydney region for MySQL engine costs $0.492 per hour. Now if weContinue reading Schedule Start & Stop RDS Instances and Save Money

Troubleshoot connection issue using standalone jdbc driver to oracle

Hi All Please download following file from Google drive and keep in unix directory say /home/oracle https://drive.google.com/open?id=0B8-3R318F39hQUJOcnVPMUdrNzg The files to be downloaded:- Please use ojdbc7.jar downloaded for 12c.For 11g,you can use ojdbc6.jar.   Please provide execute permissions Now you can test connection using below:- [oracle@SBJ1ITESBDBV01 ~]$ sh sqlScript_new.sh 2017-10-26 09:45:53.0 Please note you may getContinue reading Troubleshoot connection issue using standalone jdbc driver to oracle