Home » RDBMS Server » Networking and Gateways » Listener response to a TNS ping (Oracle 11.2.0.3.0 , linux 2.6)  () 1 Vote
Listener response to a TNS ping [message #619881] Fri, 25 July 2014 12:47 Go to next message
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
Re: Listener response to a TNS ping [message #619891 is a reply to message #619881] Fri, 25 July 2014 14:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Listener response to a TNS ping [message #619943 is a reply to message #619891] Sat, 26 July 2014 08:19 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
Senior Member
any tnsping which takes more than a second should be investigated
Re: Listener response to a TNS ping [message #619953 is a reply to message #619943] Sat, 26 July 2014 09:26 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
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?

Re: Listener response to a TNS ping [message #619957 is a reply to message #619945] Sat, 26 July 2014 10:52 Go to previous messageGo to next message
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
Re: Listener response to a TNS ping [message #619960 is a reply to message #619957] Sat, 26 July 2014 11:19 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Listener response to a TNS ping [message #620677 is a reply to message #619891] Tue, 05 August 2014 05:19 Go to previous messageGo to next message
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
Re: Listener response to a TNS ping [message #620684 is a reply to message #620677] Tue, 05 August 2014 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
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?

Re: Listener response to a TNS ping [message #620685 is a reply to message #620684] Tue, 05 August 2014 06:24 Go to previous messageGo to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Quote:
How did you get the message?

through alert

[Updated on: Tue, 05 August 2014 06:24]

Report message to a moderator

Re: Listener response to a TNS ping [message #620686 is a reply to message #620685] Tue, 05 August 2014 06:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What alert?

Re: Listener response to a TNS ping [message #620687 is a reply to message #620686] Tue, 05 August 2014 06:56 Go to previous messageGo to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Listener response to a TNS ping is 1320 secs
Re: Listener response to a TNS ping [message #620688 is a reply to message #620687] Tue, 05 August 2014 07:00 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
How did you get the message?


Re: Listener response to a TNS ping [message #620689 is a reply to message #620688] Tue, 05 August 2014 07:18 Go to previous messageGo to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Alert came
Re: Listener response to a TNS ping [message #620690 is a reply to message #620689] Tue, 05 August 2014 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From where?

Re: Listener response to a TNS ping [message #620697 is a reply to message #620690] Tue, 05 August 2014 08:45 Go to previous messageGo to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
OEM alert tool

[Updated on: Tue, 05 August 2014 08:46]

Report message to a moderator

Re: Listener response to a TNS ping [message #620700 is a reply to message #620697] Tue, 05 August 2014 08:50 Go to previous message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What does OEM documentation say about this alert?

[Updated on: Tue, 05 August 2014 08:50]

Report message to a moderator

Previous Topic: "//localhost/testdb" in tnsnames.ora
Next Topic: Failed to connect to database instance
Goto Forum:
  


Current Time: Sat Nov 22 20:40:17 CST 2014

Total time taken to generate the page: 0.09171 seconds