2

When I try to re-organize objects from OEM (11g) and enter my host credentials (not "oracle"), I get the message:

"An error occurred verifying the host credentials. Make sure the credentials are valid and that they specify an account with enough privileges to write to the directory where the reorganization script will be created. Credential verification error: ERROR: Invalid username and/or password"

My host username is a member of the oinstall and dba groups. I guess my first question is what directory is it that I need write access to? My second question is what privileges do I need in order to run a reorg (not as the "oracle" user)?

I should say that this is a linux Oracle server.

Improve this question
3
  • It says invalid username or password?
    – Philᵀᴹ
    Commented Jan 31, 2014 at 23:44
  • Yes, I put the exact message that I received back. The "invalid username and/or password" is strange since I know I am providing the correct values. There doesn't seem to be any way to tell exactly what is happening here.
    – GregH
    Commented Feb 13, 2014 at 16:28
  • Did you ever sort this GregH? Im having the same issue with a tablespace that i cant shrink until i reorganise it. Thanks
    – David Janes
    Commented Jul 4, 2018 at 13:38

1 Answer 1

Reset to default
1

You have different types of credentials in OEM !
First you need to create those credentials and test them.
See here an article that walks you throw how to create and test your named credentials

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.