Lorem Ipsum has been the industry's standard dummy
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 […]
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 […]
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 […]
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 […]
This post video provide you basic method how oracle calculate cost from explain plan it derives
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. […]
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 […]
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 […]
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 well as this patch requires version12.2.0.1.7 . […]
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:58 2017 Completed redo scan read […]