topic ora-28009: connection as sys should be as sysdba or sysoper in University Forum

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

MiliDoshi — Thu, 30 Jan 2020 14:01:00 GMT

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
------------------------------

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

Carl__Carter — Sat, 01 Feb 2020 16:05:00 GMT

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
------------------------------

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

vivek.kumar.goel — Mon, 03 Feb 2020 03:10:00 GMT

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.
------------------------------