Tuesday, 14 August 2012

ERROR ORA-12154 TNS: installing ODAC 11.2

Solution as its progresses

Step 1:

Source of solution 1

SYMPTOM
Receive the error message, "ORA-12154 TNS: could not resolve the connect identifier specified."


Error while installing ODAC 11.2 Release 4 and Oracle Developer Tools for Visual Studio (11.2.0.3.0) in Microsoft Transaction Server

Error:

Value = NumberOfInstalls
INFO: Query Returned: 1
INFO: Setting variable 'n_numInstalls' to '1'. Received the value from a code block.
INFO: Calling Query w32RegQueries10.2.0.1.0  RegGetStringValue
Key = HKEY_LOCAL_MACHINE
SubKey = software\oracle\OracleMTSRecoveryService\Setup\All Versions\1
Value = Home
INFO:
Query Exception: GetValueKeyNotFoundException
Query Exception Class: class oracle.sysman.oii.oiil.OiilQueryException
INFO: *** Cancel Dialog: Specified key not found ***
INFO: User Selected: Stop installation of all products.



 

Solution:

You will need to update registry. Follow steps below

 
Setting up keys in registry:
1, Key = HKEY_LOCAL_MACHINE
SubKey = software\oracle\OracleMTSRecoveryService\Setup\All Versions\1
Value = Home
value: C:\oracle\product\10.2.0\client_1\



select new > String value




2, Key = HKEY_LOCAL_MACHINE
SubKey = software\oracle\OracleMTSRecoveryService\Setup\Current Version\
value: C:\oracle\product\10.2.0\client_1\
this value will get overwritten with installer value, but the key has to be present.