Category: Technology

  1. Home
  2. Technology
November 17, 2017

MySQL Admin

  Install mysql 5.7 in Ubuntu root@ubuntu:~# sudo apt-get install mysql-server Reading package lists… Done Building dependency tree Reading state information… Done The following additional packages will be installed:  libaio1 libhtml-template-perl mysql-client-5.7 mysql-client-core-5.7  mysql-common mysql-server-5.7 mysql-server-core-5.7 Suggested packages:  libipc-sharedcache-perl mailx tinyca The following NEW packages will be installed:  libaio1 libhtml-template-perl mysql-client-5.7 mysql-client-core-5.7  mysql-common mysql-server mysql-server-5.7 mysql-server-core-5.7 0 upgraded, 8 newly […]

Read More
November 16, 2017

How to add raw disk first in vmware host RHEL 7 from datastore and attach to ASM diskgroup using udev rules and asmca

First Add disk from datastore to the VM server node using following steps Login to vCenter console and Right Click Server -> Edit Settings. Click Add and add a New Disk Create a new virtual disk. Provide capacity and all related setting. Also specify the Datastore.   Select proper settings in Virtual Device Node Check all the settings and Finish […]

Read More
November 16, 2017

ORACLE DATA GUARD FOR RAC 12C USING SEPARATE REPLICATION NETWORK

ORACLE DATA GUARD FOR RAC 12C USING SEPERATE REPLICATION NETWORK Table of Contents Revision history   3 1       Environment   4 1.1         Hardware  4 1.2         Software  4 1.3         Networking  4 1.3.1      Primary Site  4 1.3.2      Disaster recovery Site  5 1.4         LISTENER_DG both for primary and standby  5 1.4.1      Listener Configuration Kolkata1  10 1.4.2      Listener Configuration Kolkata2  11 1.4.3      Listener Configuration Delhi1  12 […]

Read More
November 15, 2017

Case Study on Network Bandwidth Calculation in 12c dataguard environment and testing with redo generation rate

Data loading:- create table t(c1 char(2000),c2 char(2000)); insert into t select ‘A’,’B’ from dual connect by rownum<1000000; commit; the data loading of 8 GB data took 160 sec . Now redo generation rate by 2 nodes RAC database as calculated by following example is:- SYS@EBILPD11> select thread#,sequence#,blocks*block_size/1024/1024 MB,(next_time-first_time)*86400 sec, blocks*block_size/1024/1024/((next_time-first_time)*86400) “MB/s” from v$archived_log where ((next_time-first_time)*86400<>0) and first_time between  to_date(‘2017/11/15 06:00:00’,’YYYY/MM/DD […]

Read More
November 14, 2017

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 use those instances for some development […]

Read More
November 10, 2017

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 place this init file to $ORACLE_HOME/dbs […]

Read More
November 7, 2017

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 be resolved by following 3 IP. […]

Read More
November 4, 2017

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 that not only an operational RDBMS […]

Read More
November 3, 2017

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=234881024 EBILDR12.__large_pool_size=5335154688 EBILDR11.__large_pool_size=5268045824 EBILDR11.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from […]

Read More

Debasis Maity

Translate

Ad

Please connect me in linkedin

Top Posts & Pages

Follow Us