Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

MiliDoshi
Level 2

‎30-01-20 02:01 PM

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
------------------------------
0 Likes
2 REPLIES 2

Carl__Carter
Staff
Staff

‎01-02-20 04:05 PM

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

VivekGoel
Level 10

‎03-02-20 03:10 AM

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