About Milo

Posts by Milo

get_trc.sh – a easy packing tracefile script
No Comments

Posted by Milo on July 4, 2014 | Short Link

As many of you may know, sometimes when you’re doing a health check on Oracle database. Trace files are needed for analyzing complicated errors. Are you having trouble on fetching trace file again and again when you go through the error messages one by one OR you gather the Database information from client side, sometimes, […]

Tags:

CRS-4013, CRS-4000 occurred when stop and start cluster

Posted on June 19, 2014 in Troubleshooting | Short Link
with No Comments

A very interesting case : Oracle 11.2.0.3 RAC on HPUX IA64. When I ran DBCA to create a new database on existing environment. This error come out:

This is very strange error on a RAC, so I decide to restart the crs on each node. The crs_stat -t result on node 1 looked cool, […]

Tags: , , , ,

A Procedure transalate hex or dec to ascii string

Posted on June 12, 2014 in SQL/PLSQL | Short Link
with No Comments

  Test this with the following code:

  At last, the procedure will show you the final string you want to translate, but remember if you’re passing the decimal ascii code, then you should add the second parameter with 10. Good luck.          

Copyright © 2014-2018 Come on, Milo! All rights reserved.
This site is using the Shades theme, v2.2.1.1, from BuyNowShop.com.