Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have two nodes in a cluster in a load balancer running third party WebSphere application.

We have noticied that ./sqlldr location is different for both the nodes. For one node , its: /usr/app/oracle/product/11.2.0/client

For another, , it is:

I believe this is causing the problem in our WebSphere application whose configuration file has one path for setting ./sqlldr location.

Can you tell me how to best resolve this error without taking a big step such as reinstalling the product.

Would creating a symlink resolve the issue ?

share|improve this question
up vote 1 down vote accepted

You have (at least) two choises:

  1. Symlink (as you suggested) to make the paths identical. For example:

    $ ln -s /usr/app/oracle/product/11.2.0/client /usr/app/oracle/product/11.2.0/client_1
  2. Create a conditional alias into the account's profile (assuming that the profiles must be identical). Into .bash_profile or other profile file that is read before accessing sqlldr:

    if [ `hostname` = "server_a" ]; then
        alias sqlldr='/usr/app/oracle/product/11.2.0/client/bin/sqlldr'
        alias sqlldr='/usr/app/oracle/product/11.2.0/client_1/bin/sqlldr'

Both should work and I would first try the symlink option, since it may be considered simpler.

share|improve this answer
Thanks for the answer. I will try that. Do you think that arguments of ls are reversed ? – Madhur Ahuja Jan 14 '13 at 10:28
ln's arguments are in order ln -s <source> <destination>. – grassroot Jan 14 '13 at 10:35
Ok, got it. It depends which path you are treating as the original/correct path. – Madhur Ahuja Jan 14 '13 at 10:59

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.