ora-12557(win7 64bit oracle database + 32 bit oracle client)

xiaozhuaia

　　机器是win7 64bit，安装的是oracle10g （10.2.0.4）+ 32位的客户端
　　突然想到，为什么windows里不能设置个 ORACLE_HOME,ORACLE_BASE的这个系统变量呢？ 省得每次就敲一堆字符，设置完了之后，感觉挺爽。
　　第二天，突然数据库连接不上来，tnsping 也不行，lsnrctl 中的start 也不行了，很诡异的事情，找了一对文档，问题依旧。
　　
　　木办法，只有上metalink看了，果然是个bug ，对于 10g，windows中不能设置ORACLE_HOME变量，取消变量后，重新启动机器问题解决（不重启，貌似问题依旧）。
　　
　　贴出metalink文档已记录。
　　
　　

Workflow Builder Fails: 1700: Could not connect with username/password 'apps/pwd@VIS' ('ORA-12557: TNS:protocol adapter not loadable') [ID 453241.1]

　　
　　In this Document
  Symptoms
  Cause
  Solution

　　
　　

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

　　
Applies to:
Oracle Net Services - Version: 9.2.0.1.0 to 9.2.0.6.0
Oracle Workflow Cartridge - Version: 2.6.1.5.2
Microsoft Windows 2000
Microsoft Windows XP
Microsoft Windows Server 2003
Symptoms
　　-- Problem Statement:
Oracle Client Workflow Builder version 2.6.3.5 has been installed on a Windows based workstation.  The proper Net Service Names entry has been added the entry for the instance (VIS) to the tnsnames file.  However, you are unable to open definitions in the database (File->Open->database).
The following error message is received:
1700: Could not connect with username/password 'apps/pwd@VIS' ('ORA-12557: TNS:protocol adapter not loadable').
However, TNSPING from the client or server it returns the correct information.
An ORA-12557 'TNS protocal adapter not loadable' error while trying to test the 'VIS' Oracle Net Service Name via the Oracle Net Configuration Assistant :
Result :
Trying to connect to the database VIS :
ORA-12557 TNS protocal adapter not loadable
Test did not succeed


Cause
ORACLE_HOME environment variable statically set in the Windows Users Environment settings.

Solution
-- To implement the solution, please execute the following steps::
Unset/rename the ORACLE_HOME environment variable in the Windows Users Environment setting so the Oracle WorkFlow Builder sub-components can freely reference libraries or executables from the
adjacent Oracle Home locations.