Re: configure listener.ora and tnsnames.ora

On 5 Ago, 17:37, usenet2...@xxxxxxxx (Viktor Zacek) wrote:
ilbmbo <ilbi...@xxxxxxxxx> 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!




.

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Oracle: how to demonstrate successful restore?
    ... just like fire drills. ... to going to remote location and restoring 1.1TB database at a spare ... server, web server, VPN server or LDAP server. ... Maxwell House coffee is critical for DR plans as it enables your DBA to ...
    (comp.databases.oracle.server)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Multiple Vulnerabilities Sybase Anywhere 9
    ... Multiple Vulnerabilities in Adaptive Server Anywhere Network Server ... From Sybase - Adaptive Server Anywhere, the relational database at the core ... attack allowing an authenticated user to escalate privileges to 'dba' within ...
    (Bugtraq)
Loading