Frank van Bortel <frank.van.bortel_at_gmail.com> wrote in
news:dah5cr$ntt$2_at_news2.zwoll1.ov.home.nl:
> Raymond wrote:
>> hello,
>>
>> I'm running Oracle 10g on redhat es3 and want to access the database
>> from my windows XP (no sp2) machine on which the 10g client software
>> has been installed.
>> However, starting sqlplus (or other tools) I get the TNS:no listerner
>> error. On the redhat machine i can startup sqlplus and log on using
>> scott/tiger_at_sid, so the listerner is running correctly (lsnrctl
>> status also give a messag einicating it is running), datbase is open
>> mounted etc. I cannot log on to the databse from the xp client
>> machine. I can ping the machine, but tnsping fails (no listener
>> message)!
>>
>> What to do next to figure out the problems?
>> TIA
>>
>> Raymond
>>
>>
> configure your local tnsnames to run without listener,
> example at http://vanbortel.blogspot.com/2005/05/watch-out.html
>
If you run without any listener, then TNSNAMES.ORA is NOT used!
Received on Wed Jul 06 2005 - 20:43:40 CDT
