scheduled task running as system cannot connect AS SYSDBA on a Win2k3 DC
My database server is 11.1.0.7 on windows 2k3, which also act as domain controller.
I have a RMAN backup job that run as system (in the task scheduler) which cannot connect as SYSDBA.
On a database server that is NOT a domain controller, no problem. I just add nt authority\system as a member of ora_dba and it work fine.
The problem is when the database server also act as a domain controller.
When I add nt authority\system to ora_dba, which has a group scope = domain local and group type = security, as its members. , it wont accept since it cannot find it.
I found the metalink note "Database creation using DBCA on WIN 2003 PDC fails with DIM-19 [ID 271569.1]" which reports a similar problem.
The solution is to add the machine name to the ORA_DBA group, as "NT Authority\System" account boils down to System name on a DC,
which i did, but I still get an ORA-01031: insufficient privileges.
Anyone now a setting in AD that would work?