What's happen of our database today??????????
Today we just found one of our database has many errors on alert log ORA-00600 with argument [ 17059 ] , actually this error occur since around 1 a.m. but nobody known until we received SMS in the evening ( 7 p.m. ) that has lower free spaces in the system.
My co-worker access to that server, he found the service has been shutdown already because Oracle Path is out of space and it's full of dump file in udump directory.
When he clear the space and oracle back to the online state, he found the ORA-00600 argument [ 17059 ] occur every time when user call a package.
He to find the solution on the Oracle Metalink, that may be a bug of the oracle again. The short term to resolve this problem is flush shard pool by command "alter system flush shared pool".
After solve the problem, we saw the database back to the normal state, we dicided to go back home. And when I'm home, I want to make sure the database back to the normal state really, Yep!!!! there are no error with ORA-00600 agument [ 17059 ] again but I found the new error in the another database.
.............. T-T .................
--TaTsHuYa--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment