Re: configure listener.ora and tnsnames.ora

From: ilbmbo <ilbimbo_at_gmail.com>
Date: Wed, 5 Aug 2009 08:57:22 -0700 (PDT)
Message-ID: <aa651d2a-57b3-4a06-a5c6-612e15795c2d_at_24g2000yqm.googlegroups.com>

On 5 Ago, 17:37, usenet2..._at_zacek.de (Viktor Zacek) wrote:
> ilbmbo <ilbi..._at_gmail.com> wrote:
> >   in my software in visual C++ use:
> > String^ connectionString = gcnew String ("Data Source=(DESCRIPTION=
> > (ADDRESS=(PROTOCOL=TCP)(HOST= linux-gle)(PORT=1521))(CONNECT_DATA=
> > (SERVICE_NAME=AFTIDI)));User Id=XXXXXXXX;Password=XXXXXX");
> > 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
>
> Interesting...
>
> 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

now i can't do this, because my DBA is on holiday....

but for me the problem is in listener.ora in server because is empty and if i try to configure it the listener don't work when i start it! Received on Wed Aug 05 2009 - 10:57:22 CDT