failure to access Database from Enterprise Manager console 1

[masiwan]

After successifully connecting to my Oracle database through Oracle forms 6i I now can no longer access it from Enterprise Manager console.What could be the cause.
I can see it but when I try to access it the message is:ORA-12154:TNS:could not resolve service name.
In fact the usual Host: Port: Service Name: which used to display no longer dislay the accompanying names

 

[LKBrwnDBA]

In Windoze you will allways have "Oracle Home" issues.

Set the correct Oracle Home and the problem will go away!

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Turkbear]

Hi,
If you create a SYSTEM environment variable called TNS_ADMIN and set it to the directory where your best tnsnames.ora file is located , then that one will be used regardless of what Oracle_Home is being used..That way you only have to maintain/update 1 file for new entries, etc..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[avjoshi]

That's a great tip. Does it work on different versions of client software? I mean what if I have 8i,9i and 10g clients?

Anand

 

[Turkbear]

Hi,
ALL Oracle client software ( as fas as I have seen) will look at that variable to find the location of the tnsnames.ora file ( If there is one in the same directory as the executable, it will, I think, use that one..no tnsnames.ora file should be in the BIN directory anyway)





To Paraphrase:"The Help you get is proportional to the Help you give.."