"Use the Enterprise manager 10g Console for Data management". when trying to import

Posted on 2007-08-10
Last Modified: 2013-12-18
Hi ,
      I have 10g oem client installed on my pc and i am trying to do a import as user who has dba priviileges
but I get a message saying: "Use the Enterprise manager 10g Console for Data management".Is 10g client installed on my pc is different from console or if anybody has link to install it ?


Question by:monto1
    LVL 27

    Accepted Solution

    The almost deprecated "fat client" to handle database tasks has been stripped of many features in 10g.

    So basically you can go with import / export on the command line or install the webbased oem on that database.

    Here is how to setup OEM.

    Manually configure the Oracle 10g EM dbconsole

    Installation should be done within 15 minutes, you also don't have to take the database down during installation, so this is quite safe. Just don't do that during rush hours...

    After that you can access to the dbmanagaer with


    Use the system account to login.


    Author Comment

    Wow!Thanks for your quick reply that is so cool.I would certainly recommend all my dba friends to make use of this site its incredible .
    We have grid control monitoring our databases and the target is being monitored, can i give access to the application team to make use of grid control and do the import,  as the user have dba privileges who is doing import granted to it, but for making use of grid control administartion task one need to have sysdba privileges right ?or can he do the import with dba privileges or grant him sysdba and revoke once he is done with import?

    LVL 27

    Expert Comment

    Thank you.

    Well with grid control you should strip the OEM and install the grid control agent instead.

    Both cannot exist together since they would be both using tables of the user sysman.


    There is of cause an easy way to deconfigure dbcontrol and configure agent monitoring.

    If you need help with that, just ask (best in a new question, since the topic would not match)


    Regarding the import: Well it would be sufficient to import the data with the system account.
    There is no need to use the sys account (with sysdba permisions)

    You can of cause create a new account to grant access to the grid control, they can then use their system account on that database to import the data.

    Overview of Users and Security


    Author Comment

    Thank you i really appericate  it.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now