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.

Oracle cheat sheet

Display existing tables in oracle db

Code:

SELECT owner, table_name
  FROM dba_tables

if you need only user tables:  

SELECT table_name
  FROM user_tables

ORACLE query samples

Here you can find examples of sql queries.




Select all distinct (unique) rows from table for field:

SELECT UNIQUE (Field)  FROM Shema.TableName

What is Oracle version?

Oracle Version

Today I needed to get find out the version of oracle database using SQL command.

I have achieved it by running::

select *
from v$version; 

or

select *
from product_component_version;

.net4 connection to oracle database using entity framework

ORACLE and Entity Framework

I have small console app to check wheter my db connection works with .NET.
But as you can see below my code throwing errors.

After little of googling answer is here:


What you need to do is go to this page:

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html


download
ODAC xxx Release 4 and Oracle Developer Tools for Visual Studio
mine is: ODAC 11.2 Release 4 and Oracle Developer Tools for Visual Studio (11.2.0.3.0)

Run it on your pc.

and complete with

After then your code should be working.