Home » RDBMS Server » Enterprise Manager » role needed for oem user?
role needed for oem user? [message #219535] Wed, 14 February 2007 15:14 Go to next message
marks20101
Messages: 74
Registered: May 2005
Member
Can someone tell me the required role(s) for exporting and importing data within oem10g. See sceen shot. Also, if there is some documentation on this that would be great.

Thanks...
  • Attachment: oem.bmp
    (Size: 289.33KB, Downloaded 306 times)

[Updated on: Wed, 14 February 2007 15:16]

Report message to a moderator

Re: role needed for oem user? [message #219543 is a reply to message #219535] Wed, 14 February 2007 22:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
Put you OS USERNAME OR PASSWORD.
before that grant "LOGON AS AN BATCH" job privs to your OS USERS.
START ---> PROGRAM ---->CONTROL PANEL ---> ADMINISTRATIVE TOOLS -> LOCAL SECURITY POLICY -> USER ASSIGNMENT -> LOGON AS AN BATCH JOB.


REGARDS
Taj

[Updated on: Wed, 14 February 2007 22:14]

Report message to a moderator

Re: role needed for oem user? [message #220005 is a reply to message #219543] Sat, 17 February 2007 09:36 Go to previous messageGo to next message
marks20101
Messages: 74
Registered: May 2005
Member
Thanks Taj. I have created the oem_user, with the logon as an batch job. What role do I need to logon to OEM? I log in currently as sysdba (http://server:1158/em/), but when selecting export or import I get the validation error. See screen shot attached.

Thanks...
  • Attachment: oem2.bmp
    (Size: 289.33KB, Downloaded 282 times)
Re: role needed for oem user? [message #220006 is a reply to message #220005] Sat, 17 February 2007 09:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
You cann't export database with SYSDBA USERS
"export and import are not supported on 10g databases for users logged in with the SYSDBA role. Logout and Trying again."

Try with normal user.

regards
Taj
Re: role needed for oem user? [message #220007 is a reply to message #220006] Sat, 17 February 2007 10:01 Go to previous messageGo to next message
marks20101
Messages: 74
Registered: May 2005
Member
Taj, I see the error message. I need the database privileges that I can grant to a user so that this user can log on to the app.

Thanks...
Re: role needed for oem user? [message #220015 is a reply to message #219535] Sat, 17 February 2007 11:53 Go to previous message
marks20101
Messages: 74
Registered: May 2005
Member
Taj, thanks for your help. I was looking for the SELECT_CATALOG_ROLE.

Mark...
Previous Topic: ORA-03113
Next Topic: Problem in dataguard configuration
Goto Forum:
  


Current Time: Sat Dec 10 03:01:54 CST 2016

Total time taken to generate the page: 0.25963 seconds