Home » RDBMS Server » Enterprise Manager » is there anything dangerous without sysman (oracle 10g for solaris)
is there anything dangerous without sysman [message #397580] Sun, 12 April 2009 22:19 Go to next message
onunix
Messages: 4
Registered: April 2009
Junior Member
hello,
someone have droped user sysman cascade directly on product environment with incaution, is there anything dangerous to the db if I do not create the user?
what do sysman do during the db work ?

thanks
Re: is there anything dangerous without sysman [message #397581 is a reply to message #397580] Sun, 12 April 2009 22:35 Go to previous messageGo to next message
BlackSwan
Messages: 22722
Registered: January 2009
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

When all else fails, RTFM

http://download.oracle.com/docs/cd/B19306_01/em.102/b40103/installing_enterprise_manager.htm#sthref195
Re: is there anything dangerous without sysman [message #397651 is a reply to message #397581] Mon, 13 April 2009 03:03 Go to previous messageGo to next message
onunix
Messages: 4
Registered: April 2009
Junior Member
BlackSwan wrote on Sun, 12 April 2009 22:35
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

When all else fails, RTFM

http://download.oracle.com/docs/cd/B19306_01/em.102/b40103/installing_enterprise_manager.htm#sthref195



thanks, with your help , now I know SYSMAN is the Owner of the Management Repository database schema ,but I wondered what is stored in the Management Repository database .

I think , the during time of the execution of the sql is stored in the db, the sga hit rate is stored in the db, anything else?
Re: is there anything dangerous without sysman [message #397655 is a reply to message #397580] Mon, 13 April 2009 03:11 Go to previous messageGo to next message
onunix
Messages: 4
Registered: April 2009
Junior Member
from http://download.oracle.com/docs/html/B12016_02/glossary.htm
I get:
The SYSMAN account should be used to perform infrequent systemwide, global configuration tasks such as setting up the environment.

but

what means "setting up the environment" ?
what for "setting up the environment" ?

is there any other task?
Re: is there anything dangerous without sysman [message #397658 is a reply to message #397580] Mon, 13 April 2009 03:17 Go to previous message
onunix
Messages: 4
Registered: April 2009
Junior Member
and Automatic Workload Repository is part of Management Repository database ?
Previous Topic: Generating AWR report in $ORACLE-HOME dir
Next Topic: Different Space Usage is different in alerts and tablespace information.
Goto Forum:
  


Current Time: Mon Sep 01 06:20:03 CDT 2014

Total time taken to generate the page: 0.54487 seconds