ora-28009: connection as sys should be as sysdba or sysoper

[MiliDoshi]

Hi,

I'm trying to use OLEDB VBO to conenect to Racle DB. Following i my connection string. While executing "Open" Action to open connection in Oracle, it is throwing me the error - "ora-28009: connection as sys should be as sysdba or sysoper". Please help!

Connection String - (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.44.78.12)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SRVICE_NAME=orcl)))
User Id=sys;Password=Oracle123;DBA Privilege=SYSDBA;


------------------------------
Mili Doshi
Business Consultant
Persistent Systems Ltd
Asia/Kolkata
------------------------------

[Carl__Carter]

The OLEDB VBO uses standard .NET libraries to enable connectivity to various database formats, therefore I would recommend posting your question to a .NET or Oracle forum.

------------------------------
Carl Carter
Developer Program Manager
Blue Prism
Europe/London
------------------------------

[vivek.kumar.goel]

With my experience, You would need to hit and try with various connection strings to make it work for your ORacle DB.

Basically, you will have to modify the "Connection String" and need to see which string is best for your version of DB.

NOTE: You may get some more errors like, provider not registered and etc.. Google about them and apply the workarounds provided on your machine.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
"If you like this post, please press the "Recommend" Button.
------------------------------