Re: listener problems

From: Andreas Stephan <nospam.as.stedat_at_gmx.net>
Date: 2000/05/31
Message-ID: <3934B7A9.1B5E27EE@gmx.net>#1/1

Seems as if you have an error in your tnsnames.ora file. The address for the second database is misspelled.
The client tries to connect using the entry in the tnsnames.ora and uses the parameters there. Try copying the entry of the first database (the one which is working) and only change the alias and the sid.

hth
Andy

bilal_z_at_my-deja.com schrieb:

> We have set-up 2 seperate databases on our 8i server. The connections
> to the first one work fine, but the second one keeps on giving a 'TNS:
> no listener' error.
> I have configured the listener.ora file to recognize the second DB also
> but I keep getting this error.
>
> Any help would be much appreciated.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed May 31 2000 - 00:00:00 CDT