October 2015 »

Data Guard Protection Modes

The availability and consistency of the Standby Database changed evermore throughout the last years and by that the loss of transactions decreased till 0 transactions. Originally only the archived Redolog files were transmitted to the Standby side and loaded there. By this the loss of transactions was in scale of one redolog file. With the 9i version Oracle then introduced the Standby Redologs, so transactions could now be transmitted right from the Online Redologs into the Standby Redologs and loaded immediately. So the loss of transactions was only a few transactions. With the 10g version then the LNS process was

Data Guard Protection Modes Blogbeitrag lesen »

By Johannes Ahrends • 30. October 2015 • 3 minutes of reading

Uncategorized

PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX

Confusion about Oracle Profile Parameters I spend a lot of time with the right configuration of profiles and certainly I consulted the oracle documentation for that. Because not all of the parameters are self-explaining. PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX are such candidates, maybe you can guess what they mean by yourself but in the end you need the documentation to understand their real behaviour. So I did. After a few minutes I choose an appropriate strategy for my case by the help of the Oracle Documentation. But when I started to configure these parameters over OEM I got an inconsistent error message.

PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX Blogbeitrag lesen »

By Johannes Ahrends • 23. October 2015 • 3 minutes of reading

Uncategorized

OEL 7 Preperation for Oracle 12c

Since Standard Edition 2 is available by now and I already described in my previous blog how easy it is, to set up a database, the question comes up, how to install SE2 on Oracle Enterprise Linux Version 7. Who already worked with OEL 6, will notice when switching to OEL 7, that quite a bit has happened. You’ll be searching the old [inlinecode]/etc/init.d[/inlinecode] in vain, as now the startup of daemons and programs is managed by the command [inlinecode]systemctl[/inlinecode]. By this the commands [inlinecode]service[/inlinecode] and [inlinecode]chkconfig[/inlinecode] are dropped – however I’d like to mention that there are quite a

OEL 7 Preperation for Oracle 12c Blogbeitrag lesen »

By Johannes Ahrends • 7. October 2015 • 4 minutes of reading