I have an issue with generating ASH Report on Oracle 11gR2 (11.2.0.1) RAC (2-nodes) on HP-UX. Its working on one node but not the other.
When I ran ashrpt.sql, its accepting all the inputs and hangs, its not ending. When I trace the session I get the following,
Ioctl ASYNC_CONFIG error, errno = 1
Ioctl ASYNC_CONFIG error, errno = 1
WAIT #5: nam='control file sequential read' ela= 373 file#=0 block#=1 blocks=1 obj#=581 tim=70344326749
WAIT #5: nam='control file sequential read' ela= 425 file#=0 block#=16 blocks=1 obj#=581 tim=70344327317
WAIT #5: nam='control file sequential read' ela= 433 file#=0 block#=18 blocks=1 obj#=581 tim=70344327784
WAIT #5: nam='control file sequential read' ela= 278 file#=0 block#=281 blocks=1 obj#=581 tim=70344328098
WAIT #5: nam='control file sequential read' ela= 331 file#=0 block#=1 blocks=1 obj#=581 tim=70344329323
WAIT #5: nam='control file sequential read' ela= 308 file#=0 block#=16 blocks=1 obj#=581 tim=70344329727
WAIT #5: nam='control file sequential read' ela= 364 file#=0 block#=18 blocks=1 obj#=581 tim=70344330124
WAIT #5: nam='control file sequential read' ela= 383 file#=0 block#=180 blocks=1 obj#=581 tim=70344330541
WAIT #5: nam='asynch descriptor resize' ela= 2 outstanding #aio=0 current aio limit=0 new aio limit=2142 obj#=581 tim=70344330586
Ioctl ASYNC_CONFIG error, errno = 1
Ioctl ASYNC_CONFIG error, errno = 1
WAIT #5: nam='control file sequential read' ela= 310 file#=0 block#=1 blocks=1 obj#=581 tim=70344363432
WAIT #5: nam='control file sequential read' ela= 414 file#=0 block#=16 blocks=1 obj#=581 tim=70344363961
WAIT #5: nam='control file sequential read' ela= 202 file#=0 block#=18 blocks=1 obj#=581 tim=70344364196
WAIT #5: nam='control file sequential read' ela= 360 file#=0 block#=281 blocks=1 obj#=581 tim=70344364592
WAIT #5: nam='control file sequential read' ela= 181 file#=0 block#=1 blocks=1 obj#=581 tim=70344365663
WAIT #5: nam='control file sequential read' ela= 354 file#=0 block#=16 blocks=1 obj#=581 tim=70344366182
WAIT #5: nam='control file sequential read' ela= 325 file#=0 block#=18 blocks=1 obj#=581 tim=70344366541
WAIT #5: nam='control file sequential read' ela= 364 file#=0 block#=180 blocks=1 obj#=581 tim=70344366939
WAIT #5: nam='asynch descriptor resize' ela= 1 outstanding #aio=0 current aio limit=0 new aio limit=2142 obj#=581 tim=70344366984
Ioctl ASYNC_CONFIG error, errno = 1
Ioctl ASYNC_CONFIG error, errno = 1
...............................................................................
...............................................................................
...............................................................................
does anybody has similar problem?