Monday, October 29, 2007

Oracle TNS Error : Could not resolve the connect identifier specified

A cliché, yes, but I think what cause the problem is worth noted, at least for myself. One day I was thinking about bringing home some of my work and the country in which I live and work was (and still) no high-tech developed countries where internet speed generally fast enough to remotely access a Database Server. Anyway, the problem was that I only have Oracle 9i Client installed on my laptop, I need Server. So I installed Oracle 10g Express Edition (the download took quite some time, mind you).

Everything went just fine until I was back at my office trying to run the application with the TNS configuration set to Oracle Server at the office, when it said:

Oracle TNS Error : Could not resolve the connect identifier specified


I tried TOAD to connect using the same TNS configuration and no problem occurred, which was an addition my confusion. So I called Google, worked some search and found some discussions about the topic here:
http://forums.oracle.com/forums/thread.jspa?messageID=2154989
http://ora-12154.ora-code.com/

The point is that after I installed Oracle XE I had two Oracle Homes, the one used by my application was the Oracle XE’s, that’s why it won’t connect to my office’s server. One of the solutions is to use TNS_ADMIN variable, but those instructions brought me headache. I need a quick solution, my boss was coming. So my solution was to temporarily replace Oracle XE’s TNSNAMES.ORA file with the one from the Oracle 9i Client. It was a quick and certainly a dirty solution, but save me some accusing questions from my boss.

Actually if I was thinking more careful (and having more knowledge on Oracle) instead of instantly weep and ran to Google, I should have seen the Oracle Home options on TOAD’s Login Window at which displayed selections of which Oracle Home to use, then I would (probably) got the problem figured out at that moment, silly me.

8 comments:

Anonymous said...

Hi,

I had the same issue when I installed Oracle 10 XE on my PC. I had to edit the "TNS_ADMIN" system variable and append "C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN;"
Once this was done....things started humming!!!

Thanks,
Saran Sankar

Anonymous said...

Good day !.
You re, I guess , probably curious to know how one can make real money .
There is no initial capital needed You may commense earning with as small sum of money as 20-100 dollars.

AimTrust is what you need
The company represents an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

It is based in Panama with offices around the world.
Do you want to become an affluent person?
That`s your choice That`s what you desire!

I feel good, I began to take up income with the help of this company,
and I invite you to do the same. If it gets down to select a correct partner who uses your savings in a right way - that`s AimTrust!.
I make 2G daily, and my first deposit was 1 grand only!
It`s easy to join , just click this link http://nafazedaxu.easyfreehosting.com/wevoxec.html
and lucky you`re! Let`s take this option together to become rich

Anonymous said...

Good day !.
might , perhaps very interested to know how one can manage to receive high yields .
There is no need to invest much at first. You may start to receive yields with as small sum of money as 20-100 dollars.

AimTrust is what you haven`t ever dreamt of such a chance to become rich
AimTrust incorporates an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

Its head office is in Panama with structures around the world.
Do you want to become really rich in short time?
That`s your chance That`s what you desire!

I`m happy and lucky, I began to take up real money with the help of this company,
and I invite you to do the same. It`s all about how to choose a proper partner who uses your money in a right way - that`s the AimTrust!.
I take now up to 2G every day, and my first investment was 500 dollars only!
It`s easy to get involved , just click this link http://aqiwymol.o-f.com/rytaqys.html
and go! Let`s take our chance together to get rid of nastiness of the life

Anonymous said...

Good day, sun shines!
There have been times of troubles when I felt unhappy missing knowledge about opportunities of getting high yields on investments. I was a dump and downright pessimistic person.
I have never imagined that there weren't any need in big starting capital.
Now, I feel good, I begin take up real money.
It's all about how to select a proper companion who utilizes your funds in a right way - that is incorporate it in real deals, parts and divides the income with me.

You may get interested, if there are such firms? I have to tell the truth, YES, there are. Please get to know about one of them:
[url=http://theblogmoney.com] Online investment blog[/url]

Anonymous said...

Good dispatch and this mail helped me alot in my college assignement. Gratefulness you on your information.

Anonymous said...

Good day!

For sure you didn’t here about me yet,
my name is Nikolas.
Generally I’m a venturesome gambler. all my life I’m carried away by online-casino and poker.
Not long time ago I started my own blog, where I describe my virtual adventures.
Probably, it will be interesting for you to utilize special software facilitating winnings .
Please visit my blog. http://allbestcasino.com I’ll be interested on your opinion..

Anonymous said...

Hi,

I am regular visitor of this website[url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips].[/url]thecodernotes.blogspot.com is filled with quality info. Frankly speaking we really do not pay attention towards our health. Here is a fact for you. Recent Scientific Research indicates that nearly 80% of all U.S. grownups are either chubby or overweight[url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips].[/url] Therefore if you're one of these citizens, you're not alone. Infact many among us need to lose 10 to 20 lbs once in a while to get sexy and perfect six pack abs. Now next question is how you can achive quick weight loss? You can easily lose with with little effort. If you improve some of your daily diet habbits then, its like piece of cake to quickly lose weight.

About me: I am writer of [url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips]Quick weight loss tips[/url]. I am also health trainer who can help you lose weight quickly. If you do not want to go under hard training program than you may also try [url=http://www.weightrapidloss.com/acai-berry-for-quick-weight-loss]Acai Berry[/url] or [url=http://www.weightrapidloss.com/colon-cleanse-for-weight-loss]Colon Cleansing[/url] for quick weight loss.

Anonymous said...

I love thecodernotes.blogspot.com! Here I always find a lot of helpful information for myself. Thanks you for your work.
Webmaster of http://loveepicentre.com and http://movieszone.eu
Best regards