返回
-
标题
First Pass login raised by the error "ORA-12557:TNS protocol adapter not loadable". -
说明
In the scenario where using Stat 6.2 (32-Bit) client and like to install also Stat 6.3 (64-bit), the Stat Client login raises the error First Pass Login...ORA-12557:TNS protocol adapter not loadable". So, the questions below:
1. Is it possible to have two different Stat bit's (i.e.32 and 64 bit) client on same machine?.
2. Is it possible to run Stat 6.3 with Oracle 32 bit client?
-
原因
The DB bitness connectivity must match the architecture (bitness) of the Stat Client. -
解决办法
Solution #1:
The last Stat 6.3 version is ONLY 64-bit, and yes, you can still run the different Stat bit version on the same machine. The Stat client installation will install the software in the proper system folder.In this scenario, however, it's needed to consider the connectivity to the DB. You will have to use the proper bit connectivity for each version. In this case, you will have to install:- Oracle Client 32 bit for Stat 6.2 32-bit connectivity and- Oracle Client 64-bit for Stat 6.3 64-bit connectivityFrom Stat 6.2 Release Notes, you can read the following:To create a successful connection, the architecture (bitness) of the database client/driver must match the architecture (bitness) of the Stat Client. For example, the 64-bit Stat Client requires an applicable 64-bit database client/driver, and the 32-bit Stat Client requires an applicable 32-bit database client/driver.Solution #2:About the error ORA-12557, consider and try the following solution provided by the forum below:http://www.dba-oracle.com/t_ora_12577.htm- put the Oracle DB Home in front of the other paths in the PATH environment variable.- Remove ORACLE_HOME From environment Variable and re-boot PC