I have an issue with a basic snap manager for Oracle install I hope someone can help with. I cant seem to create a profile due to Insufficient Privileges issue with the snap manager windows service account.
We are using
Windows 2K3 host with Oracle 10G v2
Managed to create the repository DB OK and authenticate, but when trying to create a profile to any DB I hit the authentication problem
"-[ERROR] SMO-05075: Profile create failed: SMO-13504: Verify operation failed. Errors: [Oracle error is: ORACLE-00001: Error executing SQL: . The command returned: ORA-01031: insufficient privileges. Verify that the SnapManager Windows service is set up to run as a user with the correct privileges and that the user is included in the ORA_DBA group. ]"
the verification for the sys account passes, as does the other snapdrive pre-reqs.
the snap manager service account is in the domain admins group and also in the ora_db local group and has admin rights to the filer. as far as I am aware this is all it needs.