如何使用bltoolkit以sysdba的身份连接到Oracle数据库? [英] How can i connect to oracle database as sysdba using bltoolkit?
问题描述
我可以成功连接到oracle普通用户,但是当我尝试连接sys用户时,出现此错误.
i can connect to oracle normal user successfully but when i try to connect sys user i got this error.
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
因为我必须以sysdba身份进行连接,但是如何在bltoolkit上进行连接?
because i have to connect as sysdba but how can do it on bltoolkit ?
如何解决这个问题?
我必须使用bltoolkit以sys用户身份连接到oracle
I have to connect as sys user to oracle using bltoolkit
我的Connstring:
My Connstring:
数据源=(DESCRIPTION =(地址=(PROTOCOL = TCP)(主机=本地主机)(PORT = 1521))(CONNECT_DATA =(SID = prod))));用户ID = sys;密码=管理器; DBA Privilege = SYSDBA;数据源= oracle;
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=prod)));User Id=sys;Password=manager;DBA Privilege=SYSDBA;Data Source=oracle;
推荐答案
Oracle允许数据库管理员使用SYSDBA或SYSOPER特权连接到Oracle数据库.这是通过ConnectionString的DBA Privilege属性完成的.
Oracle allows database administrators to connect to an Oracle Database with either SYSDBA or SYSOPER privileges. This is done through the DBA Privilege attribute of the ConnectionString.
//Connect SYS/SYS as SYSDBA
con.ConnectionString = "User Id=SYS;Password=SYS;" +
"DBA Privilege=SYSDBA;Data Source=oracle;";
这篇关于如何使用bltoolkit以sysdba的身份连接到Oracle数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!