Recently when my machine was reimaged all my previous settings were lost. I had real hard time setting up the connection with oracle server from my machine. I installed ODT with ODAC from oracle but something was missing which resulted in “ORA-12154: TNS:could not resolve the connect identifier specified” error message. After reading several blogs I came to know that I have to set the server, host and port details in tnsname.ora file
# alias =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.mycompany.com)(PORT = 1521))
# (CONNECT_DATA =
# (SERVER = DEDICATED)
# (SERVICE_NAME = orcl)
I updated the Host and service name but still something was missing which resulted in the same above error message. After some trial and error methods I was finally able to solve this issue. In the application they were using alias name as datasource in the connection string where as I gave some dummy alias name.
When I finally gave the correct alias name in the tnsname.ora and in the connection string datasource the issue was fixed.
Hope this saves someone’s time.
I don’t understand why people hate Microsoft, all the software and applications developed by Microsoft are just to make life easier for all the users. Just take a look at windows OS or Visual Studio, these are things I use most, Windows is so easy for any kind of user to operate. Visual Studio, makes life easy for the developers but still developers hate it.
The only drawback with Microsoft is they keep on releasing new upgrades and discontinue support to older version. I mean when you compare .Net with java, in java they still use all the core techonology they created ofcourse there will be updates and easier ways to use. When we look at Visual Studio, now we won’t use all the older version controls or coding methodologies, we need to learn all the newer techonogies. with newer version there comes lot to learn. The same thing we used to do changes. Ofcourse, techonology always upgrades.
Missing Hyderabad and all the funny things used to do there… Telugu fm, Hyderabad biryani, roaming with friends.. ashram .. Its not easy to describe what we are missing because we can feel like we are living when you are in a city like hyderabad… Once someone comes and starts living in Hyderabad where ever he goes he is definetely going to miss this beautiful city.
Atleast I could get fm online and on iphone… thanks voicevibes.net and hydfm app for iphone…