Re: configure listener.ora and tnsnames.ora

From: Viktor Zacek <>
Date: Wed, 5 Aug 2009 17:37:22 +0200
Message-ID: <>

ilbmbo <> wrote:

> in my software in visual C++ use:
> String^ connectionString = gcnew String ("Data Source=(DESCRIPTION=
> System::Data::OracleClient::OracleConnection^ conn = gcnew
> System::Data::OracleClient::OracleConnection(connectionString);
> conn->Open();
> so in this mode i can connect but sometimes i have error in
> TNS:listener


I would do the following during development (you have to talk with your DBA about corresponding steps):

  • shutdown the database
  • delete all logfiles on server and client
  • sync time between client and server (or just note the difference)
  • start the database
  • use program only to test the connect (simply a loop which connects every 10 seconds, and disconnects, print time if connect not successful)
  • check logfiles on server (esp. listener and alert log and client (esp. sqlnet.log) at printed times for errors

I only delete the logfiles for pure lazyness... its easier to search in nearly empty logfiles ;-)

Best regards,
Viktor Received on Wed Aug 05 2009 - 10:37:22 CDT

Original text of this message