Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Delayed Response

Delayed Response

From: TechBooks <rravi_at_techbooks.com>
Date: Wed, 6 Oct 1999 12:55:50 -0000
Message-ID: <01BF0FFA.1E63F090@TECHBOOKSNT>


From: 	TechBooks
Sent: 	Wednesday, September 29, 1999 2:26 PM
To: 	'comp.databases.oracle.server_at_list.deja.com'
Subject: 	Delayed Response
Importance: 	High
Sensitivity: 	Private

Hi
I have 2 servers rnning two different database erp/orcl in 8.0.4 connected by database links. the select statement issued from database erp to orcl using db linktakes a very long time. Sameway tnsping80 also takes a long time.

But from orcl to erp both select statements and tnsping80 is very fast. Both machines are on same network.

From any third client machine the response while connected to either machine is equally fast.

I have tried reinstalling net8 services and configured listener .ora but no improvement Please help
The listener.ora,sqlnet.ora and tnsnames.ora are almost identical except for SID name.
When i try lsnrctl80>status
on i machine it shows service summary erp has two service handlers on another orcl has one service handler maybe this is the root cause

Thnx

Ravi

Please send a email at below address
rravi_at_techbooks.com

 Sent via Deja.com http://www.deja.com/  Before you buy. Received on Wed Oct 06 1999 - 07:55:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US