Re: Fwd: [External] ORA-12170: TNS:Connect timeout occurred

Hi -

Does it hurt to increase the timeout value like below

net_service_name=
 (DESCRIPTION=
  (CONNECT_TIMEOUT=10)(RETRY_COUNT=3)
  (ADDRESS_LIST=
   (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))    (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521)))   (CONNECT_DATA=
   (SERVICE_NAME=sales.us.example.com
<https://slack-redir.net/link?url=http%3A%2F%2Fsales.us.example.com>)))

Thanks

Bhavani.

On Mon, Apr 6, 2020 at 2:28 PM Bhavani Dhulipalla <bhavanidba6_at_gmail.com> wrote:

> Hi - if the port is not open they shouldn’t be connected at all correct ?
>
> The problem is that the issue happening intermittently and goes fine with
> the restart -
>
> Thanks
> Bhavani.
>
> On Mon, Apr 6, 2020 at 2:27 PM Venkataraman Srinivasan <
> Venkataraman.Srinivasan_at_gcrta.org> wrote:
>
>> Are you able to telnet to <public IP> <db_port#> from your local box?
>>
>> If not ask network people to open the port on that <public IP>
>>
>> Thanks
>> Venkat
>>
>> >>> Bhavani Dhulipalla <bhavanidba6_at_gmail.com> 4/6/2020 2:11 PM >>>
>> 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
>>
>>
>> ------------------------------
>> This email has been scanned for spam and viruses. Click here
>> <https://attseg.cloud-protect.net/index01.php?mod_id=11&mod_option=logitem&mail_id=1586196781-SuGR6Hd444xQ&r_address=venkataraman.srinivasan%40gcrta.org&report=1>
>> to report this email as spam.
>>
>>

--
http://www.freelists.org/webpage/oracle-l