Fwd: ORA-12170: TNS:Connect timeout occurred

From: Bhavani Dhulipalla <bhavanidba6_at_gmail.com>
Date: Mon, 6 Apr 2020 14:11:57 -0400
Message-ID: <CAC=-2+yobkaujDOboYHW0nbovbtP3agrMgg9T1Mn9oKiUjct4A_at_mail.gmail.com>



Hi –
We are having the intermittent timeouts with few jobs and after restart Job is finishing fine*DB Version 11.2.0.4 OS is AIX **Error : Error while parsing ORA-12170: TNS:Connect timeout occurred*

Oracle is saying its TCP timeout issue and below is snippet from log[25-MAR-2020
18:06:36:955] ntt2err: soc 7 error - operation=1, ntresnt[0]=505, ntresnt[1]=78, ntresnt[2]=0
[25-MAR-2020 18:06:36:955] ntt2err: exit
[25-MAR-2020 18:06:36:955] nttcni: exit
[25-MAR-2020 18:06:36:955] nttcon: exit
[25-MAR-2020 18:06:36:955] nserror: entry
[25-MAR-2020 18:06:36:955] nserror: nsres: id=0, op=65, ns=12535,
ns2=12560; nt[0]=505, nt[1]=78, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[25-MAR-2020 18:06:36:955] *nsopen: unable to open transport*Oracle is
saying unable to open transport is not the Database Error and should be checked from network side and n/w team is saying there are no packet drops and no issues from their endLocal_Listener parameter is pointing to public IP as opposed to VIP – Does anyone seen this before?Thanks Bhavani

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 06 2020 - 20:11:57 CEST

Original text of this message