use OMS to export Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: use OMS to export

  1. #1
    Join Date
    Feb 2002
    I got message: authentication error when I tried to export tables & I login to the db as normal & sysoper.
    Anyone has idea what I did wrong.

    Thank you very much.

  2. #2
    Join Date
    Dec 2001
    You need to set the preferred credentials for the node you want to do the export on. The username/password is usually the "oracle" user on UNIX. On NT you should use an OS user that has the "log on as batch" privilege granted to it.

    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website:
    My blog:

  3. #3
    Join Date
    Feb 2002
    Thank you Tim,

    But I still confused about OMS/OEM user & database perfered credentials & Node perfered credentials.

    When I login OEM as sysman (MS2K), I discovered local & romote db. I set perfered credentials for dbs and nodes, then I connected to local db, try to export table, and it failed with authentication error. I don't know why.

    Also, what the user can do after i configure new repository? should I use domain user as the new user?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width