TNS Server not loadable

Question Recieved: We have encountered issues connecting to distributed databases using the internal CC&B subsystems (and TNSping) resulting in the following errors:

Log is
Fatal NI connect error 12557, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=CCBTEST)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CCBCONVT)(CID=(PROGRAM=C:\spl\CCBCONVT\runtime\CLBDSYNC.exe)(HOST=CCBTEST)(USER=s_cissys))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
Time: 04-SEP-2007 16:26:20
Tracing not turned on.
Tns error struct:
ns main err code: 12557
TNS-12557: TNS:protocol adapter not loadable
ns secondary err code: 12560
nt main err code: 527
TNS-00527: Protocol Adapter not loadable
nt secondary err code: 0
nt OS err code: 0

and

--------------------------------------------------------------------------
--Executing Data Synchronization Process at 09-05-2007 08:50:51

The Actual Path is,

E:\oracle\VIS\apps\tech_st\10.1.2\bin;E:\oracle\VIS\apps\tech_st\10.1.2\jdk\jre\bin\classic;E:\oracle\VIS\apps\tech_st\10.1.2\jdk\jre\bin;E:\oracle\VIS\apps\tech_st\10.1.2\jlib;E:\oracle\VIS\apps\tech_st\10.1.3\bin;E:\oracle\VIS\db\tech_st\10.2.0\bin;D:\Apps\Perl\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;D:\Apps\Cygwin\bin




Oracle SQL Plus is configured for Oracle version 10.2.0.3 but the Environmental path points to Oracle 10.1.2. So this is the culprit here....

The Modifified path is,

E:\oracle\VIS\db\tech_st\10.2.0\bin;E:\oracle\VIS\apps\tech_st\10.1.2\bin;E:\oracle\VIS\apps\tech_st\10.1.2\jdk\jre\bin\classic;E:\oracle\VIS\apps\tech_st\10.1.2\jdk\jre\bin;E:\oracle\VIS\apps\tech_st\10.1.2\jlib;E:\oracle\VIS\apps\tech_st\10.1.3\bin;D:\Apps\Perl\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;D:\Apps\Cygwin\bin



Now,
 E:\BackUp\Imp\SQLAPI\SQLAPI\vs2005\bin>sqltest.exe
1.      Oracle
2.      SQL Server
3.      DB2
4.      Informix
5.      Sybase
6.      InterBase
7.      SQLBase
8.      MySQL
9.      PostrgeSQL
0.      ODBC
a.      SQLite
1
Client version: 10.2
Database name (connection string):      VIS
User name:      system
Password:       manager
Server: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Server version: 10.2