Blogspot - msutic.blogspot.com - Marko Sutic's Oracle Blog
General Information:
Latest News:
How to detach storage device from running virtual machine in VirtualBox 7 Jul 2013 | 01:04 am
In this post I want to show how to test what will happen with your cluster if you simply detach shared storage device from it. VirtualBox is great tool for that purpose because you can test such scena...
Recover corrupted blocks using Flashback Logs 17 May 2013 | 04:54 pm
Starting with 11g Oracle can perform block media recovery using flashback logs to get good copies of the blocks. Flashback database is not enabled by default so first step would be to enable it. When...
Recover corrupted blocks using Flashback Logs 17 May 2013 | 04:54 pm
Starting with 11g Oracle can perform block media recovery using flashback logs to get good copies of the blocks. Flashback database is not enabled by default so first step would be to enable it. When...
Oracle Restart: srvctl fails to start database with error CRS-5010 14 Apr 2013 | 07:34 pm
I’ve installed Oracle Grid Infrastructure on one of my standalone test servers. This software includes Oracle ASM as volume manager and Oracle Restart for managing Oracle components. As recommended, G...
Oracle Restart: srvctl fails to start database with error CRS-5010 14 Apr 2013 | 07:34 pm
I’ve installed Oracle Grid Infrastructure on one of my standalone test servers. This software includes Oracle ASM as volume manager and Oracle Restart for managing Oracle components. As recommended, G...
Change SID of the Oracle database using DBNEWID 10 Apr 2013 | 01:06 am
In this post I will describe how to change Oracle SID using utility DBNEWID. As I can see DBNEWID is available from 9i version but I’ve never heard about it. Till now, I have used procedure where I’m ...
Change SID of the Oracle database using DBNEWID 10 Apr 2013 | 01:06 am
In this post I will describe how to change Oracle SID using utility DBNEWID. As I can see DBNEWID is available from 9i version but I’ve never heard about it. Till now, I have used procedure where I’m ...
Transaction restrictions for Parallel DML on 11g 30 Mar 2013 | 09:45 pm
This will be just short post about restriction on parallel DML that I wasn't aware of. Last week we had to perform quick update of several million rows in very big table. Parallel DML has proven to b...
Transaction restrictions for Parallel DML on 11g 30 Mar 2013 | 09:45 pm
This will be just short post about restriction on parallel DML that I wasn't aware of. Last week we had to perform quick update of several million rows in very big table. Parallel DML has proven to b...
Kill stuck Oracle process from OS using DBMS_SCHEDULER 7 Feb 2013 | 07:24 pm
Last month we had annoying problems caused by stuck Oracle process holding locks and not releasing them. Every few days one process hangs with status “ACTIVE” and “SQL*Net message from client” wait ev...
