Tuesday, January 22, 2013

Select BLOB Data

select substr(utl_raw.cast_to_varchar2(at.column_name), 341, 41) as MSISDN from archive_tbl at where utl_raw.cast_to_varchar2(at.column_name) like '%01287392728%';

Wednesday, January 9, 2013

CURL Response Time

Http post message which store in request.xml. This command support for SOAP action as well.
curl -o /dev/null -w '\nLookup time:\t%{time_namelookup}\nConnect time:\t%{time_connect}\nPreXfer time:\t%{time_pretransfer}\nStartXfer time:\t%{time_starttransfer}\nRedirect time:\t%{time_redirect}\n\nTotal time:\t%{time_total}\n' -H 'SOAPAction: ""' --header "Content-type: application/soap+xml" -i -d @request.xml -X POST http://www.google.com

Friday, January 4, 2013

OracleValidConnectionChecker - Unexpected error in pingDatabase

Error
[org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker] Unexpected error in pingDatabase

Resolution
Remove the Oracle lib (ojdbc14.jar) from your Ear or War and place it at jboss server/lib directory

Tuesday, August 7, 2012

Include xml file in Maven

Update pom.xml file as below:-
<build>
...
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
...
</build>

Friday, March 2, 2012

Check Oracle DB CharacterSet

SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET'

Sunday, December 4, 2011

Check Memory Usage

prstat -s cpu -a -n 8

http://developers.sun.com/solaris/articles/prstat.html

Wednesday, November 2, 2011

Clean Up Oracle DB Space

Free up oracle db space by delete below log:-
/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
using this command :
cat /dev/null > /oracle/oracle/product/10.2.0/db_1/network/log/listener.log
This log was more than 4GB of size. Emptying this file is harmless as it only contains the connection log to the DB.