Most of the time I don’t even think about how I connect to a database: set the environment – variables, connect /as sysdba, and voila..
Then I ran into a node in which this was not as simple as I thought. Only connections through the listener were accepted. After serious investigation in discovering some typo’s, a vague bell was ringing…. Not the first thing I would think of… :
The Linux-command: ‘uname -a’ gave me ‘x86_64′. A 64-bits machine! The database and application server turned out to be running in 32-bits emulation mode.
Switched my session into 32-bits-emulation: with the Linux-command ‘ linux32 bash’ , and the problem was solved. Some things can be time consuming but simple (when you think of it…).