topic Re: Snap Manager For Oracle Privileges issue in Data Protection

Snap Manager For Oracle Privileges issue

dfranklin — Thu, 05 Jun 2025 07:24:58 GMT

Guys

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

SMO v3
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.

Help needed please!!!

Thanks again Darren

Re: Snap Manager For Oracle Privileges issue

akhare — Wed, 12 Aug 2009 10:01:42 GMT

Please refer 69642.1 oracle note for this issue.

Regards

Arvind

Re: Snap Manager For Oracle Privileges issue

vrishali — Wed, 12 Aug 2009 10:18:42 GMT

SQLNET.AUTHENTICATION_SERVICES parameter from file SQLNET.ORA is need to be set to NTS for OS Authentication

Please refer to Oracle Metalink DocID: 730067.1 ("Troubleshooting ORA-1031 Insufficient Privilege") for possible issues.

Thanks,

Vrishali

Re: Snap Manager For Oracle Privileges issue

dfranklin — Wed, 12 Aug 2009 11:11:45 GMT

You are a star, this fixed it, couldnt find any information about this in the SMO install guide which isnt very useful

Darren