I tried to find a perfect SQL format tool for a long long time, while all the attempts failed until ...
Oracle
Wonderful SQL format tool — SQL Pretty Printer
Read More...
Oracle
Expdp and event ‘Streams AQ: enqueue blocked on low memory’
Our daily expdp backup job became abnormally and it would last more than one day, while in the past ...
Got ORA-28500 during ODBC configuration from Oracle 10g to MySQL
These days I tried to configure ODBC to access MySQL from Oracle 10g, and I believed all of my confi...
‘lsnrctl status’ could not display the status of running listener correctly
My friend got this issue and wanted to know the reason, so I built a test VM to verify it. The dbss ...
ORA-12547 and sysctl -p
This night I installed an Oracle 12c database on SLES12SP3 to test the dbss script on SLES system an...
ORA-29382 or ORA-06512 during database upgrade from 11.1 to 12.1
Last year, when I was migrating/upgrading a huge Oracle database from 11.1 to 12.1, I encountered on...
CIFS VFS: No response to cmd
I never thought mounting a shared filesystem maybe cause server reboot! One node in a three-node RAC...
One ORA-12520 issue in Oracle RAC
Several days ago I helped to fix one ORA-12520 issue in RAC database, and from this issue I learned ...
How to install GI patches BEFORE the root.sh is executed?
Such issues happen rarely, while sometimes we have to do such things. If you can access the Oracle S...
ORA-12547 on SUSE12/SLES12
My friend told me his team installed Oracle 11.2.0.4 on a new SLES12 system while could not create t...
