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

Thread: use OMS to export

  1. #1
    Join Date
    Feb 2002
    Posts
    3
    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
    Location
    UK
    Posts
    1,684
    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.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Feb 2002
    Posts
    3
    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