Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


dsaucier
2010-07-23T00:06:53Z
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
Sponsor
Forum information
Support
2010-07-23T00:08:18Z
Should not be a problem with the connection. And you did try the SQL Connection guide?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
dsaucier
2010-07-23T00:14:28Z
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,

Support
2010-07-23T09:34:31Z
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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
dsaucier
2010-08-10T17:49:59Z
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.
Support
2010-08-10T19:15:56Z
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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2010-08-10T19:36:47Z
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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top