hi guys
recently upgraded our databases to 19.8 from 12.2.0.1. We have a schdeduler job that runs a .cmd file in C:\utilities. We are having to use the local system account to run this ok - using the native oracle scheduler service accountwe get a permission denied error. Strangely running an .exe like ipconfig works fine with the native oracle scheduler service account, but cmd does not.
This is the error
ORA-27369: job of type EXECUTABLE failed with exit code: 2 System error 5 has occurred.
Access is denied.
System error 5 has occur
STANDARD_ERROR="System error 5 has occurred.
Access is denied.
System error 5 has occurred.
Access is denied.
System error 5 has occurred.
Access is denied.
System error 5 has occurred.
Access is"
It is clearly something to do with the permissions of the account this service runs on
I can see this method (enabling the service OracleJobSchedulerSID) is no longer preferred (or whatever the oracle terminology is) and one is supposed to setup two sets of DBMS_CREDENTIAL, however the guide on oracle-base doesnt say anything about having to have already created a windows user. Having gone through the motions with this approach i get an invalid username/pw failure. I do not want another windows user account created thats going to take up disk space just to execute a cmd.
If setting up DBMS_CREDENTIAL, do you HAVE to have a corresponding windows user account already setup?