Monday, February 4, 2019

UNLOCK user in ADG

›
In our production databases, all users have FAILED_LOGIN_ATTEMPTS set to 5 on their PROFILES. After 5 incorrect passwords their account w...
4 comments:
Tuesday, October 30, 2018

OS Logfiles via SQL

›
Due to security restrictions it has become cumbersome to login to a DB Server or to even login as SYS to the DB. I've had to quickly ad...
Monday, October 8, 2018

Move datafile to another ASM diskgroup

›
From Oracle 12.1 you can execute SQL commands from within RMAN, which was great for this exercise so I did not have to jump between RMAN and...
Wednesday, October 3, 2018

Data Guard Failover surprise

›
Ran into a interesting scenario after reinstating the previous primary DB after an emergency failover. A Data Guard failover is done durin...
Saturday, September 29, 2018

Connection Pooling for Scalability and Performance

›
Got a call from our web support team, seems that a critical database transaction with a 2 second SLA is sometimes taking 6 seconds to compl...
Friday, September 21, 2018

Cloning a RAC DB on the same cluster

›
We are using OMF in ASM so will include the following 3 lines in the RMAN DUPLICATE TARGET command: SET DB_FILE_NAME_CONVERT '+DG_DAT...
Monday, September 17, 2018

ORA-16047 - DGID mismatch between destination setting and target database

›
A few days after a DG planned switchover I got a call from the DBAs. OEM and v$dataguard_stats shows no lag, but archives have not shipped f...