12-01-2006
81,
0
Join Date: Sep 2006
Last Activity: 25 June 2009, 1:35 AM EDT
Posts: 81
Thanks Given: 0
Thanked 0 Times in 0 Posts
[help]oracle database error on solaris 8
hi experts,
i have some problem with my oracle database 8.1.7 running on sun solaris 8, after 2 days or more i cannot login into database and needed to restart the database, below shown the error :
ERROR:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","TRIGGER$","sga heap","state objects")
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")
please help
how to fix this problem?
thank you so much
Best Regards,
wu