In last week I upgraded my laptop from T420s to E485 to get maximum 32G memory also because the T420s was so old and the cooling system worked inefficiently, so during the summer it would become slowe...

Normally when we restore the hot backup of a database, we will recover and open it with resetlogs option because during the restore procedure we have to restore the control file first. Last week I got...

Sometimes, when I installed the Oracle GI and run the asmca, I could create volume and acfs easily, while I never know the background of such things. This time, I need to create a shared cluster files...

First of all, let me show you the installation log: [root@node2 tmp]# /u01/app/11.2.0/grid/OPatch/opatch auto 28813878 -ocmrf /u01/ocm.rsp Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/...

I tried to find a perfect SQL format tool for a long long time, while all the attempts failed until I found this one: SQL Pretty Printer. The online edition is here. It has many options and I think 'M...

Our daily expdp backup job became abnormally and it would last more than one day, while in the past it just took about 40 minutes. From the v$session view I found the expdp related processes were wait...

These days I tried to configure ODBC to access MySQL from Oracle 10g, and I believed all of my configurations were correct, while when I run a select statement from Oracle database, I always got below...

My friend got this issue and wanted to know the reason, so I built a test VM to verify it. The dbss scirpt was used to start their instances and he found if he run 'dbss start' then he could get the c...

This night I installed an Oracle 12c database on SLES12SP3 to test the dbss script on SLES system and found it worked well until I rebooted the server. After the reboot, I found the database was not o...

Last year, when I was migrating/upgrading a huge Oracle database from 11.1 to 12.1, I encountered one really tough issue and I found the reason after several months. The error messages were like this ...