| Instance RAC down - Listener High Processing [message #549328] |
Thu, 29 March 2012 09:11  |
marcossantos
Messages: 123
Registered: June 2008
|
Senior Member |
|
|
Hi,
I have a RAC enviroment with 3 instance. One instance maybe down. I check the alert log and i find this message:
Wed Mar 28 16:32:30 2012
WARNING: inbound connection timed out (ORA-3136)
Wed Mar 28 17:17:52 2012
ORA-01555 caused by SQL statement below (SQL ID: 237ps0584wd7w, Query Duration=90580 sec, SCN: 0x0143.83b648fe):
Wed Mar 28 17:17:52 2012
select * from RH.tb_servidor
Wed Mar 28 17:54:44 2012
Thread 1 advanced to log sequence 17454
Current log# 1 seq# 17454 mem# 0: +REDO1/bdtrt14/onlinelog/group_1.260.639054149
Current log# 1 seq# 17454 mem# 1: +REDO2/bdtrt14/onlinelog/group_1.261.639054151
Wed Mar 28 17:54:47 2012
Connections via sqlplus on RAC its work. But, on GRID Control the instance 1 appear down. I check the process on the machine and find LISTENER on the top process. When i execute dont return nothing.
I apply a and restart. and its work again.
Can someone help to understand?
1. How a command select * from table can affect this rac this way?
2. Why the listener execute with high process?
3. Can the UNDO segment be affect by select statement?
Regards,
Marcos Santos
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
