Database - RAC/Scalability (MOSC)

MOSC Banner

11.2.03. rogue scanlisteners showing very slow response times in tnsping

edited Jul 4, 2017 8:32AM in Database - RAC/Scalability (MOSC) 8 commentsAnswered

In 11.2.03.  I have had 1 or 2 rogue scanlisteners  showing very slow response times in tnsping  of hundreds even thousands  of msec.   So basically scan is there  but very slow


(DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=695.200.102.81)(PORT=1521))(CONNECT_DATA=(SID=MYDBP11)(SERVER=DEDICATED)))

OK (4030 msec)

(DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=695.200.102.82)(PORT=1521))(CONNECT_DATA=(SID=MYDBP11)(SERVER=DEDICATED)))

OK (0 msec)

(DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=695.200.102.80)(PORT=1521))(CONNECT_DATA=(SID=MYDBP111)(SERVER=DEDICATED)))

OK (31820 msec)  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center