Oracle 无法使用特定用户 ID 打开



我有一个我从任务调度程序运行的应用程序。如果我从我的帐户运行它,它可以正常运行,但是如果我从系统帐户运行它(此帐户在服务器上的权限与我的权限类似(甚至是管理员),但是有一个非验证密码。当我从系统帐户运行它在打开Oracle时失败。我的应用程序不会抛出异常。它只是死亡。但是,事件查看器具有以下内容:

Application: M921.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.NullReferenceException
Stack:
   at Oracle.DataAccess.Client.OracleException.get_Source()
   at M921.Program.Main(System.String[])
Faulting application name: M921.exe, version: 1.0.0.0, time stamp: 0x58c2d17b
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0xc0000005
Fault offset: 0x037d2be3
Faulting process id: 0x564
Faulting application start time: 0x01d299ba8cb4ef63
Faulting application path: D:ScriptingApplicationsM921M921.exe
Faulting module path: unknown
Report Id: cbb37f30-05ad-11e7-97a4-005056824753

如果我检查了跟踪日志,我发现了这一点:

<msg time='2017-03-10T10:11:23.998-05:00' org_id='oracle' comp_id='clients'
 msg_id='3079483318' type='INCIDENT_ERROR' level='1'
 host_id='PWN401AV1369' host_addr='::1' prob_key='oci 24550 [3221225477]'
 errid='15721' detail_path='C:UsersscrptadminOracleoradiag_scrptadmindiagclientsuser_scrptadminhost_2384361277_82traceora_3292_1232.trc'>
 <txt>Errors in file

C:UsersscrptadminOracleoradiag_scrptadmindiagclientsuser_scrptadminhost_2384361277_82traceora_3292_1232.trc  (incident=15721):
oci-24550 [3221225477] [Unhandled exception: Code=c0000005 Flags=0
] [] [] [] [] [] [] [] [] [] []
 </txt>
</msg>
<msg time='2017-03-10T10:11:24.186-05:00' org_id='oracle' comp_id='clients'
 msg_id='dbgexProcessError:1266:3370026720' type='TRACE' level='16'
 host_id='PWN401AV1369' host_addr='::1'>
 <txt>Incident details in: C:UsersscrptadminOracleoradiag_scrptadmindiagclientsuser_scrptadminhost_2384361277_82incidentincdir_15721ora_3292_1232_i15721.trc
 </txt>
</msg>

我已经检查了我能想到的所有权限。数据库凭据是Oracle凭据(不是Windows凭据;用户名和密码是连接字符串的一部分)

我正在使用版本12.1.0 Oracle客户端

我感到困惑。

由于您尚未提供任何源代码,所以我只是在这里猜测。要使用特权帐户(SYSDBA或SYSOPER)连接,您需要将DBA特权属性添加到您的连接字符串:

//Connect scott/tiger as SYSDBA   
con.ConnectionString = "User Id=scott;Password=tiger;" + 
  "DBA Privilege=SYSDBA;Data Source=oracle;";

oracle文档链接

相关内容

  • 没有找到相关文章

最新更新