OEM is free?

[evergreean43]

I have Oracle 9i. Is Oracle Enterprise Manager free?

I have several people (3) in my office that need OEM for building tables and editing data.

Please advise.

 

[LKBrwnDBA]

Yes, It's on the 'Client' CD -- Administrator installation option.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[stefanhei]

OEM is free and can be found where LKBrwnDBA stated. But it's a very powerful tool, ment for administrative use.
For the task of creating tables and editing data, which is more the task of a developer I would use something less "dangerous" like SQL*Plus or SQLPlus Worksheet.

Stefan

 

[Turkbear]

Hi,
Also the OEM, to be fully functional, needs a dedicated OEM Oracle instance as well and Oracle Agents running on all managed instances.

The client-side stand-alone version has limited functionality..




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[evergreean43]

Thanks,

My OEM that I use to create tables and edit data has only user privileges only and the DBA made sure I can not do any admin things. Is it still dangerous to use it even if I can only create and edit tables??

 

[KenCunningham]

I guess it depends on whether your edits are accurate?

All I ask of you
Is make my wildest dreams come true

 

[stefanhei]

I think it's not a technical danger you'll face (as your DBA can tweak the rights of those users) but a social one, that's why I quoted dangerous - you are using big guns to shoot a sparrow.
I usually try to keep userinterfaces as slim and simple as possible. OEM is not slim at all - and there are tools available which are easier to use than OEM.
Please don't get me wrong - OEM can do what you want it to do and for a small team of IT-pros trained on databases it might be ok. In our company we only give OEM to DBAs, that's why I posted.

Stefan

 

[LKBrwnDBA]

Maybe your users would be better off with SQL Developer


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[evergreean43]

"The client-side stand-alone version has limited functionality.."

I am using the client-side OEM only so I assume I will be okay with that and still not running a big gun since it is locally and most privileges were taken away by DBA?