Help! Oracle TNS listener problem

From: Sudip Chakraborty <sudip_at_inductis.com>
Date: Mon, 9 Oct 2000 11:43:29 -0400
Message-ID: <8rspab$isccj$1@ID-45409.news.cis.dfn.de>

Hi,

We are running Oracle 8i Standard Edition on a Windows 2000 Advanced Server with 3 network cards. We have set up one TNS listener listening at one of the IP addresses.

Every once in a while when we reboot we are not able to connect. We get the following error:
SQL state:S1000Error Code:12541Message:[Oracle][ODBC][Ora]ORA-12541: TNS:no listener

Sometimes the following procedure works - disable 2 of the network cards, connect to Oracle, then restart the disabled network cards. Today, that's not working either.

Any ideas/suggestions would be greatly appreciated. Thanks.
Sudip Received on Mon Oct 09 2000 - 10:43:29 CDT