userAtoZ wrote:The reported error has nothing to do with LD_LIBRARY_PATH, or 32-bit vs 64-bit libraries.
I installed Oracle 11g32 on a separate home directory but in the same partition of the hard disk.
But I have created any listener or tnsnames.ora file for this 11g32 bit libraries.
I pointed the Oracle11g_32bit/lib folder to LD_LIBRARY_PATH_32 environment variable which is read by applications. But I am getting the following errors..
ORA-12505: TNS:listener does not currently know of SID given in connection.