Is it possible to use the connection wizard to connect to an Oracle dabase as sysdba. I have tried several combinations but it doesn't seem to allow this type of connection.
In SQLPlus the format is:

connect SYS/<password> as SYSDBA;

Some jobs require elevated privleges to run.


Thanks,
David A. Saucier

Should not be a problem with the connection. And you did try the SQL Connection guide?

---

I did try the connection guide but it does not accept the privelege piece of "as SYSDBA"

We need to pass four pieces of information for this:

Data Source=myOracle;User Id=myUsername;Password=myPassword;DBA Privilege=SYSDBA;

I can connect to multiple accounts in the same database with the connection's I've already created so I know that works. It's just the elevated privilege that is the problem.


Thanks,

Try combining the connection string with a Credential. I don't know what kind of user it expects to be logged in, yours or SYSDBA but try adding that user and select it in the Task.

---

Maybe this link will help you understand that this is an oracle privilege and requires the addition of the option to "connect as sysdba".

http://www.adp-gmbh.ch/o...sys_system_internal.html 

Maybe I should move this over to the wish list.

Thanks, but could you make a quick test. Stop the VisualCron service. Start the VisualCronService.exe by double clicking on the icon. Now, try to run the Task again. This is just to see if this is a Credential issue.

---

We made some quick research. The problem is that the Microsoft Oracle Provider, that we use, does not support connection as SYSDBA.

Unfortunately, there does not seem to be any development against that.

The alternative is to choose a third party provider. This would involve some work and expenses for that provider. Since this is a specific request it is hard to prioritize this unless you want to support the development.

Please contact sales@visualcron.com for more information.

---