ORA-12170: TNS:Connect timeout occurred
Date: Wed, 1 Apr 2020 16:50:58 +0000
Message-ID: <98EAFD726DCE474387DC759F678A842A0DB6AF_at_CHCORPEXMBX11.corp.lpl.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 end
Local_Listener parameter is pointing to public IP as opposed to VIP – Does anyone seen this before?
Thanks
Bhavani
The information contained in this email message is being transmitted to and is intended for the use of only the individual(s) to whom it is addressed. If the reader of this message is not the intended recipient, you are hereby advised that any dissemination, distribution or copying of this message is strictly prohibited. If you have received this message in error, please immediately delete.
Member FINRA<http://www.Finra.org> / SIPC<http://www.Sipc.org>
Copyright 2017 – LPL Financial. All Rights Reserved.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 01 2020 - 18:50:58 CEST