OraFAQ Forum: Server Administration » OEM problem with wrong date

Home » RDBMS Server » Server Administration » OEM problem with wrong date_time (Oracle 10.2.0.1, Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OEM problem with wrong date_time [message #378151]

Mon, 29 December 2008 03:03

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Hi all!

I found that our server's time is wrong, faster 7h25 minutes than other - correct time. Then, I reset the time in server by user root. After that, when I come back with OEM, it showed that:

"java.lang.Exception: Result has repeating key value : at 2008-12-29 15:21:00 GMT"

15:21 is the time that I reset.

http://i95.photobucket.com/albums/l130/trantuananh24hg/oem.jpg

-- And snap_shot_IDs in awrrpt tool are wrong

http://i95.photobucket.com/albums/l130/trantuananh24hg/awr.jpg

May you guide me to reset it?

Thank you very much!

Report message to a moderator

Re: OEM problem with wrong date_time [message #378164 is a reply to message #378151]

Mon, 29 December 2008 03:33

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Try to purge the unwanted snapshots:

dbms_workload_repository.drop_snapshot_range
(low_snap_id=>40, high_snap_id=>60);

Report message to a moderator

Re: OEM problem with wrong date_time [message #378169 is a reply to message #378164]

Mon, 29 December 2008 03:44

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Thank you for your reply!

I've just drop snap_shot, it - OEM are running now!

Report message to a moderator

Previous Topic:	Unable to analyze table(IOT_TYPE = IOT )
Next Topic:	log 'alter system' command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:38:05 CST 2024