Monthly Archive October 2018

ByJoel Pérez ( Oracle ACE Director )

Generate SSH Key Pairs to Access Oracle Linux instances in the Oracle Cloud Infrastructure..!!

Subscribe to get the notifications of our daily articles in your email..!

Generate SSH Key Pairs to Access Oracle Linux instances in the Oracle Cloud Infrastructure..!!

Hi Readers

Introduces Secure Shell key pair generation and demonstrates how to generate a SSH key pair to use when remotely connecting to Oracle Cloud Infrastructure instances.

To watch click here:

Subscribe to get the notifications of our daily articles in your email..!

We hope the content could be useful for your Oracle DBA Tasks!

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

ByJoel Pérez ( Oracle ACE Director )

Can two Oracle sessions be blocked when accessing DIFFERENT rows.. ?..!! By  Connor McDonald @connor_mc_d

Subscribe to get the notifications of our daily articles in your email..!

Can two Oracle sessions be blocked when accessing DIFFERENT rows.. ?..!! 

By  Connor McDonald @connor_mc_d

Hi Readers

To watch click here:

Subscribe to get the notifications of our daily articles in your email..!

We hope the content could be useful for your Oracle DBA Tasks!

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

ByJoel Pérez ( Oracle ACE Director )

When Oracle MERGE gets MUNTED..!! By  Connor McDonald @connor_mc_d

Subscribe to get the notifications of our daily articles in your email..!

By  Connor McDonald @connor_mc_d

Hi Readers

MERGE is a great SQL command to capture both update and inserts in a single command. But how to diagnose and solve the problem when MERGE crashes with “ORA-30926: unable to get a stable set of rows in the source tables” And what the hell is a “stable set of rows” anyway ?

to watch click here:

Subscribe to get the notifications of our daily articles in your email..!

We hope the content could be useful for your Oracle DBA Tasks!

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/

 

ByJoel Pérez ( Oracle ACE Director )

Oracle Replication Done Right..!!

Subscribe to get the notifications of our daily articles in your email..!

Oracle Replication Done Right..!!

Larry Carpenter, guest author —

Whether it is a cloud, an on-premises, or a hybrid environment, the question asked most often is “What is the right solution to protect my data from failures – with the least amount of downtime and data loss?” Well, one choice that comes to mind is to replicate the data to another physical site. This means all the data changes are physically copied to a remote location using some application-agnostic replication technology. You can then activate the remote site in the event of a primary failure. So far so good. Which means “replication” is the solution which fits the bill. The default replication choice is to just replicate all the changes happening to the data at the storage level. Simple enough. Right?

Not really. For most common deployments using generic storage-based replication, the replication simply stops at the storage level. It never gets deeper. When the replication happens at the block level, the storage system has no clue about the type of data it is replicating. It just replicates whatever you throw at the storage, faithfully. There is both a good and a really bad aspect to this method. 

Peeling back some layers you will find that you opened a big can of worms. To start with, what if you accidentally delete a file? Guess what, that deletion gets replicated and the file is lost in the remote site too. What if there is a logical corruption on your production database? That too gets replicated faithfully. What if you want to offload your read-only analytical queries or reporting to the remote site while the replication is going on? Good luck with that, as mirrored copies of data are ‘dark’. The point is, while application agnostic storage replication seems to be easy, it just adds complexity when replicating databases that store your mission critical data. 

To look at it in another way, take the database server as an example. The IO changes in the memory usually traverse through various layers – from memory to HBA to a storage switch to a storage controller and finally to an actual disk. All pieces of the stack have their own firmware. A software bug or any issue with any component in the stack can result in data corruption – which the storage is not aware of and it does not care about either.  The corrupted data is replicated. I am not making this up, but there are real-world use cases.  See the following:

to continue reading the article, click the link down below:

https://blogs.oracle.com/maa/replication-done-right

Subscribe to get the notifications of our daily articles in your email..!

We hope the content could be useful for your Oracle DBA Tasks!

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/

 

 

ByJoel Pérez ( Oracle ACE Director )

Oracle Flashback Database and Archived Redo..!! By  Connor McDonald @connor_mc_d

Subscribe to get the notifications of our daily articles in your email..!

Oracle Flashback Database and Archived Redo..!! By  Connor McDonald @connor_mc_d

By  Connor McDonald @connor_mc_d

Hi Readers

To watch click here:

Subscribe to get the notifications of our daily articles in your email..!

We hope the content could be useful for your Oracle DBA Tasks!

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com