Flashing Back a Failed Primary Database into a Physical Standby Database The following steps assume the user has already performed…
Category Uncategorized
I know we are an Oracle DB blog. But for Technology enthusiasts an opportunity to learn something new shouldn’t pass by.
“An irrefutable tenet of physics argues that matter cannot exist in two places at one time. But data definitely can and often should.” So DBA’s…
————- Drop Database Manually Oracle ——————— 1. First get the datafiles, control files and redo log files location Login to…
Well to put it across in a few words. A trigger is a part of a transaction and not a…
This is a script to create a logon trigger for blocking third party tools like Toad, SQl Navigator etc from…
Sorry Guys.. It has been a while since I have written anything. I’m on a long summer break. But I…
Upgrade APEX 3.2.1 to 4.1.1 on Oracle Database 11gR2. via Upgrade APEX 3.2.1 to 4.1.1 on Oracle Database 11gR2.
Error during doing import in RAC environment from one node. This error occurs on impdp (Data Dump) Solution: use parameter…
SCAN (Single Client Access Name) is a new concept introduced in since 11gR2. It eliminated to have VIP )Virutal ip)…
If you have multiple remote connections like VNC/ RDP/ SSH/ TELNET. There is a good software to manage multiple connections…
Installing Oracle Grid Infrastrcture This document provides a step by step guide to, installing Oracle 11gR2 Real Application clusters on…
Apple use’s Oracle Active Dataguard 11g for its AppStore. In Oracle 11g data guard you can have upto 30 active…
I’m now a certified expert in Oracle. Just cleared the 1z0-048 exam for Oracle RAC 10g Cluster. The exam tests…
Oracle Database philosophy is Data Recover-ability. This is the reason if you have a huge table with more than 100…