OraFAQ Forum: Networking and Gateways » Listener response to a TNS ping

Home » RDBMS Server » Networking and Gateways » Listener response to a TNS ping (Oracle 11.2.0.3.0 , linux 2.6) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Listener response to a TNS ping [message #619881]

Fri, 25 July 2014 12:47

srikanth02
Messages: 49
Registered: June 2014
Location: India

Member

Hi all,

What does the message "Listener response to a TNS ping is ...secs" mean? What action should be taken?..

Thanks,
Srikanth

Report message to a moderator

Re: Listener response to a TNS ping [message #619891 is a reply to message #619881]

Fri, 25 July 2014 14:57

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It means you executed a tnsping and the listener responsed in ...secs.
There is nothing to do.
It is an information.

Report message to a moderator

Re: Listener response to a TNS ping [message #619943 is a reply to message #619891]

Sat, 26 July 2014 08:19

srikanth02
Messages: 49
Registered: June 2014
Location: India

Member

Hi Michel,
Quote:

It means you executed a tnsping and the listener responsed in ...secs.

The listener response was 61,234 msec.Based on this response, could you tell me is there any problem with network side ?

When i give tnsping SID , it is taking quite sometime to ping the database. (say 5 mins)
Moreover I am able to ping server without any issue.

Regards,
Srikanth

[Updated on: Sat, 26 July 2014 08:20]

Report message to a moderator

Re: Listener response to a TNS ping [message #619945 is a reply to message #619943]

Sat, 26 July 2014 08:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

any tnsping which takes more than a second should be investigated

Report message to a moderator

Re: Listener response to a TNS ping [message #619953 is a reply to message #619943]

Sat, 26 July 2014 09:26

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Moreover I am able to ping server without any issue

Which mean which time?

I agree with BlackSwan.
What is the session creation rate?

Report message to a moderator

Re: Listener response to a TNS ping [message #619957 is a reply to message #619945]

Sat, 26 July 2014 10:52

srikanth02
Messages: 49
Registered: June 2014
Location: India

Member

Hi Blackswan,
Quote:

any tnsping which takes more than a second should be investigated

How to investigate that ?

Michel,
Quote:

What is the session creation rate?

How to find out that ?

Regards,
Srikanth

Report message to a moderator

Re: Listener response to a TNS ping [message #619960 is a reply to message #619957]

Sat, 26 July 2014 11:19

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

By default CREATE SESSION is audited in your version, so query DBA_AUDIT_SESSION and count grouping by each second.

Report message to a moderator

Re: Listener response to a TNS ping [message #620677 is a reply to message #619891]

Tue, 05 August 2014 05:19

srikanth02
Messages: 49
Registered: June 2014
Location: India

Member

Quote:

It means you executed a tnsping and the listener responsed in ...secs

I have not used TNSPING command during alert time.Then how the alert has come ?
Can you explain it ?

Regards,
Srikanth

Report message to a moderator

Re: Listener response to a TNS ping [message #620684 is a reply to message #620677]

Tue, 05 August 2014 06:17

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Then how the alert has come ?

How could we know, it is YOUR system.
You have to realize we know ONLY what you tell us and you don't tell us anything useful.
How did you get the message?

Report message to a moderator