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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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

Report message to a moderator

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?

Report message to a moderator

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?

Report message to a moderator

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 ?

Report message to a moderator

Previous Topic: Generating AWR report in $ORACLE-HOME dir
Next Topic: Different Space Usage is different in alerts and tablespace information.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 02:55:41 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.