Re: configure listener.ora and tnsnames.ora
From: ddf <oratune_at_msn.com>
Date: Wed, 5 Aug 2009 09:23:35 -0700 (PDT)
Message-ID: <4941ce14-3d71-4796-86a7-49bf1725c730_at_w6g2000yqw.googlegroups.com>
On Aug 5, 10:57 am, ilbmbo <ilbi..._at_gmail.com> wrote:
> 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!- Hide quoted text -
>
> - Show quoted text -
Date: Wed, 5 Aug 2009 09:23:35 -0700 (PDT)
Message-ID: <4941ce14-3d71-4796-86a7-49bf1725c730_at_w6g2000yqw.googlegroups.com>
On Aug 5, 10:57 am, ilbmbo <ilbi..._at_gmail.com> wrote:
> 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!- Hide quoted text -
>
> - Show quoted text -
How are you trying 'to configure it the listener'? Show us your listener.ora file after you've modified it to 'configure' the listener so we can see if you have any syntax errors.
David Fitzjarrell Received on Wed Aug 05 2009 - 11:23:35 CDT