Search

Top 60 Oracle Blogs

Recent comments

TOI

orapwd gives OPW-00029 Password complexity failed in #Oracle 12.2

https://uhesse.files.wordpress.com/2017/06/complex1.png?w=600&h=508 600w, htt

Getting started with VPD in #Oracle

https://uhesse.files.wordpress.com/2017/06/vpd.png?w=150 150w" sizes="(max-width: 302px) 100vw, 302px" />

Joining Accenture Enkitec Group

I have accepted an offer by the Accenture Enkitec Group to join them starting next month. That unit is a kind of ‘special force’ inside the large Accenture Corporation with particular expertise in Oracle Database and Oracle Engineered Systems technology.

Although I feel quite a bit sad to leave Oracle after all those years, the opportunity to work together with all these bright people – you can see some of them here – outshines that largely </p />
</p></div>

    	  	<div class=

Fast-Start Failover for Maximum Protection in #Oracle 12c

Fast-Start Failover is supported with Maximum Protection in 12cR2. Also Multiple Observers can now monitor the same Data Guard Configuration simultaneously. I will show both in this article. Starting with a (Multitenant) Primary in Maximum Protection mode with two Standby Databases. It is still not recommended to have the highest protection mode configured with only one standby. So this is my starting point:

DGMGRL> show configuration;

Configuration - myconf

Protection Mode: MaxProtection
Members:
cdb1 - Primary database
cdb1sb - Physical standby database
cdb1sb2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 57 seconds ago)

All three databases have flashback turned on. I want to have a setup like this in the end:

Auto Sync for Password Files in #Oracle 12c Data Guard

synchttps://uhesse.files.wordpress.com/2017/01/sync.png?w=600&h=538 600w, https://uhesse.files.wordpress.com/2017/

Real-Time Materialized Views in #Oracle 12c

helpshttps://uhesse.files.wordpress.com/2015/10/helps.png?w=600&h=558 600w, https://uh

How to move Partitions ONLINE and make them READ ONLY in #Oracle 12c

readonlyhttps://uhesse.files.wordpress.com/2017/01/readonly.png?w=574&h=60