tnsping without the TNSNAMES.ORA entry

It isn't immediately obvious in the tnsping documentation, but it is possible to perform the ping without having the Transparent Network Substrate configuration in place (i.e net service name) on the client for the database in question.

$ORACLE_HOME/bin/tnsping <hostname>:<port>/<sid>

Tailoring Fusion CRM

The journey for the Fusion CRM development team has been a long one. What a great feeling for all of us when Fusion Applications was officially released this year as Generally Available. During his keynote speech at this year's Oracle OpenWorld Steve Miranda reiterates that statement. Also during his session (more...)

Multi Byte String Generator

Click to go to launch page.
Fusion Applications uses Oracle Data Integrator as part of the data bulk import feature which includes migration and file import. While working on the Opportunity Bulk Import we had to ensure that multi byte characters were imported correctly. The majority of the test data (more...)

Using OSGi to explain the difference between Factory and Broker pattern

Osgi in Action: Creating Modular Applications in JavaAfter some heated discussions about OSGi on The Server Side decided to put together a series of articles on the topic. Quite rightly I think, Peter Kriens has the honour of getting the series started. His article on developing modular applications provides one of the clearest explanations of the differences (more...)

Irish software at Oracle OpenWorld 2010



Preparation for the trio of Oracle's major conferences (Oracle OpenWorld, JavaOne, Oracle Develop) has been underway for months, but once September comes around the pace really quickens. The final touches get put to product demonstration scripts, keynote speeches, and honing the elevator pitch. In product development (more...)

ADF logging level to see SQL statements

Very handy for debugging runtime issues when developing, the Oracle ADF Business Components layer can output the SQL that it is executing. To do this though, the logging threshold must be set to a specific level...


'-Djbo.debugoutput=console -Djbo.logging.trace.threshold=5'


Curiously. the SQL statements do not get displayed for any other threshold level.

Loosely typed interfaces – The Normalizer Pattern and Oracle SOA Suite

When getting two or more systems working together, the making a connection part is generally the easiest, identity propagation is a bit trickier, but many times, the syntax and semantics of one system is at odds with another one. Over the decades this has been manifest in many ways and (more...)

The Art of Agile Development

Keep this book to hand
The Art of Agile Development was recommended to me by Jeff McKenna when he provided some Scrum coaching to those of us in the Dublin office working on Oracle Social CRM. Back then it was a new, hot off the press book, but I have (more...)

Should we ban anonymity on the Internet?

In an Information Security article a few months back, Bruce Schneier (author of Schneier on Security) and Marcus Ranum put some points forward for and against internet anonymity. I have to admit that I agree with Schneier and find Ranum's argument quite weak. He appears to suggest that the (more...)

More than Iron Man – Oracle and Marvel

At the beginning of April 2010, Oracle, using the buzz around the release of Iron Man 2, kicked off a worldwide advertising campaign focused on introducing the powerful combination of Oracle and Sun. This includes old school billboards and commercials on a variety of old and new media platforms...

(more...)

Interface Oriented Design

This book has been sitting on my desk for a long time and I've been dipping in and out of it for at least a year. I'm a big fan of The Pragmatic Programmers and the topic of interface is very close to my heart as it is often the (more...)

It’s not you, it’s me – Check the bugs log before going crazy


How many times have you been working on implementing, unsuccessfully, a feature in your application which relies on a framework, container, or some other indirection layer? You've studied the specifications, memorised the API and you're following the developers guide which are all telling you that what you are trying to (more...)

Unit Testing with SQL Developer

December's release of SQL Developer 2.1 has a number of new bells and whistles. Two of the main new features are:

Your ScrumMaster is a project manager in disguise

In 6 attributes of a good ScrumMaster Mike Cohn repeats the common line that the ScrumMaster role does not always require a full-time, eight-hour-a-day commitment. Often the 'orchestra conductor' role of ScrumMaster is an unofficial one within your organisation even though it clearly has well defined functions and responsibilities. So (more...)

Oracle VPN

Virtual Private Networks have made remote working and access to critical corporate resources so much easier over the past few years. In fact, there is so much about the way we work today that is dependent on being able to get at data remotely yet in a secure manner. The (more...)

Strange cloud heads for Iceland


Google appears to be always thinking about new tools or approaches to make or save money. Lots of these ideas sneak out onto the internet and lots of discussions, articles and opinions get generated. Occasionally, a real product is eventually seen. Way back in 2008 rumours about a Google data (more...)

Ireland’s new Baywatch mashup

Due to a new initiative from the EPA you can keep up to-date on the water quality of Ireland's major bays (hence the article title), beaches and rivers. Made possible by some hard work from the clever people at IBM's Water Management Centre of Excellence, Splash provides a great (more...)

Fear of maths is a problem worth solving

According to researchers at the University of Granada, 6 out of every 10 university students present "mathematical anxiety". This study was carried out in a sample consisting of 885 first-year students from 23 different degrees given at the UGR which include the subject of Mathematics, both compulsory and core. (more...)

What’s the bedrock to your Social CRM Strategy?


Perhaps it is taken for granted, but Esteban Kolsky's recent article on The SCRM Roadmap, is missing the requirement for a Social Media Participation Policy for employees. No matter where you are on his SCRM pyramid such a policy is vital. The first thing it does is give an (more...)

Hosted Security Breakfast Seminar: Dublin

Staying on the topic of hosted applications and security I thought I'd bring this to your attention. MessageLabs, a Symantec Company, is organising a breakfast seminar on Hosted Security in Dublin, in November. Although I won't be attending, you may find the presentations interesting and maybe get a free croissant (more...)