Re: configure listener.ora and tnsnames.ora

> 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 Received on Wed Aug 05 2009 - 10:37:22 CDT