Hi,
How to solve below error msg. Just restarted that particular database. users can able to access now.
DISTRIB TRAN MIMS.WORLD.d0c46b42.5.16.9664
is local tran 5.16.9664 (hex=05.10.25c0)
insert pending collecting tran, scn=621062569 (hex=0.2504a9a9)
*** 2006-08-06 07:47:05.923
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4128 bytes of shared memory ("shared pool","unknow
n object","sga heap","multiblock rea")
*** 2006-08-06 09:50:00.500
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4128 bytes of shared memory ("shared pool","unknow
n object","sga heap","multiblock rea")
Regards.