基础和管理
ORACLE 数据库登录出错－“灾难性故障”
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区我用我的程序连接ORACLE数据库，可是提示“灾难性故障”，然后就登录不上了，除非机器重启才能再次连上（或重启ORACLE服务）。
我的连接字符串如下：
"Provider=OraOLEDB.Oracle;PLSQLRSet=1; Data Source=MYDB; User Id=sa; Password=123"
我查找了一下ORACLE公司的帮助，如下：
Oracle 公司的原版资料：
Problem Description ------------------- When running an application that connects to Oracle and uses the Authenticated User privilege (such as Microsoft’s Internet Information Server (IIS)) via Oracle’s 9.2 client software and any of these programmatic interfaces
1.Oracle Provider for OLE DB
2. Microsoft OLE DB Provider for Oracle
3. Oracle ODBC Driver
4. Microsoft ODBC for Oracle
5. Oracle Objects for OLE (OO4O) you will receive one of the following errors:
a) Oracle Provider for OLE DB Error Type: Microsoft OLE DB Service Components (0x80070005) Access is denied.
b) Microsoft OLE DB Provider for Oracle Error Type: Microsoft OLE DB Provider for Oracle (0x80004005) Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Or Error Type: Microsoft OLE DB Provider for Oracle (0x80004005) Oracle error occurred, but error message could not be retrieved from Oracle.
c) Oracle ODBC Driver Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Specified driver could not be loaded due to system error 5 (Oracle in OraHome92).
d) Microsoft ODBC for Oracle The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use this driver until these components have been installed.
e) Oracle Objects for OLE
i. while using a GLOBAL.ASA file Error Type: Active Server Pages (0x0) An error occurred while creating object ’OraSession’.
ii. not using a GLOBAL.ASA file Error Type: Microsoft VBScript runtime (0x800A0046) Permission denied: ’CreateObject’ (6)
f) Other miscellaneous errors
The Specified Module Could Not Be Found Solution Description -------------------- You need to give the Authenticated User privilege to the Oracle Home by following these steps:
i. Log on to Windows as a user with Administrator privileges.
ii. Launch Windows Explorer from the Start Menu and and navigate to the ORACLE_HOME directory.
iii. Right-click on the ORACLE_HOME folder and choose the "Properties" option from the drop down list. A "Properties" window should appear.
iv. Click on the "Security" tab on the "Properties" window.
v. Click on "Authenticated Users" item in the "Name" list (on Windows XP the "Name" list is called "Group or user names").
vi. Uncheck the "Read and Execute" box in the "Permissions" list (on Windows XP the "Permissions" list is called "Permissions for Authenticated Users"). This box will be under the "Allow" column.
vii. Check the "Read and Execute" box. This is the box you just unchecked.
viii. Click the "Apply" button.
ix. Click the "OK" button.
x. You may need to reboot your computer after these changes have been made. Re-execute the application and it should now work.
Explanation ----------- If you install Oracle9i Release 2 (9.2.0.1) on a computer running Windows with an NTFS partition, the contents of ORACLE_HOME directory will not be visible to users who are authenticated on that machine. These permissions were not set properly when the software was installed. Applications that were working fine with previous versions of Oracle software will stop working when they upgrade to Oracle 9.2.
NOTE: The application will continue to work if the user has logged onto the machine as an Administrator. Any application that is using the Authenticated User privilege will not work. A notable example would be IIS which might service some of the requests based on the Authenticated User privileges. To demonstrate the problem in further detail, you can log on to the operating system as an authenticated machine user. You won’t be able browse the contents of the ORACLE_HOME directory demonstrating your inability to load any Oracle DLLs or make a connection.
References ---------- Bug:2498880 - Oracle 9I Release 2 Installation Issue on Windows 2000 NTFS File System Additional Search Words ----------------------- OLEDB
我的连接字符串如下：
"Provider=OraOLEDB.Oracle;PLSQLRSet=1; Data Source=MYDB; User Id=sa; Password=123"
我查找了一下ORACLE公司的帮助，如下：
Oracle 公司的原版资料：
Problem Description ------------------- When running an application that connects to Oracle and uses the Authenticated User privilege (such as Microsoft’s Internet Information Server (IIS)) via Oracle’s 9.2 client software and any of these programmatic interfaces
1.Oracle Provider for OLE DB
2. Microsoft OLE DB Provider for Oracle
3. Oracle ODBC Driver
4. Microsoft ODBC for Oracle
5. Oracle Objects for OLE (OO4O) you will receive one of the following errors:
a) Oracle Provider for OLE DB Error Type: Microsoft OLE DB Service Components (0x80070005) Access is denied.
b) Microsoft OLE DB Provider for Oracle Error Type: Microsoft OLE DB Provider for Oracle (0x80004005) Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Or Error Type: Microsoft OLE DB Provider for Oracle (0x80004005) Oracle error occurred, but error message could not be retrieved from Oracle.
c) Oracle ODBC Driver Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Specified driver could not be loaded due to system error 5 (Oracle in OraHome92).
d) Microsoft ODBC for Oracle The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use this driver until these components have been installed.
e) Oracle Objects for OLE
i. while using a GLOBAL.ASA file Error Type: Active Server Pages (0x0) An error occurred while creating object ’OraSession’.
ii. not using a GLOBAL.ASA file Error Type: Microsoft VBScript runtime (0x800A0046) Permission denied: ’CreateObject’ (6)
f) Other miscellaneous errors
The Specified Module Could Not Be Found Solution Description -------------------- You need to give the Authenticated User privilege to the Oracle Home by following these steps:
i. Log on to Windows as a user with Administrator privileges.
ii. Launch Windows Explorer from the Start Menu and and navigate to the ORACLE_HOME directory.
iii. Right-click on the ORACLE_HOME folder and choose the "Properties" option from the drop down list. A "Properties" window should appear.
iv. Click on the "Security" tab on the "Properties" window.
v. Click on "Authenticated Users" item in the "Name" list (on Windows XP the "Name" list is called "Group or user names").
vi. Uncheck the "Read and Execute" box in the "Permissions" list (on Windows XP the "Permissions" list is called "Permissions for Authenticated Users"). This box will be under the "Allow" column.
vii. Check the "Read and Execute" box. This is the box you just unchecked.
viii. Click the "Apply" button.
ix. Click the "OK" button.
x. You may need to reboot your computer after these changes have been made. Re-execute the application and it should now work.
Explanation ----------- If you install Oracle9i Release 2 (9.2.0.1) on a computer running Windows with an NTFS partition, the contents of ORACLE_HOME directory will not be visible to users who are authenticated on that machine. These permissions were not set properly when the software was installed. Applications that were working fine with previous versions of Oracle software will stop working when they upgrade to Oracle 9.2.
NOTE: The application will continue to work if the user has logged onto the machine as an Administrator. Any application that is using the Authenticated User privilege will not work. A notable example would be IIS which might service some of the requests based on the Authenticated User privileges. To demonstrate the problem in further detail, you can log on to the operating system as an authenticated machine user. You won’t be able browse the contents of the ORACLE_HOME directory demonstrating your inability to load any Oracle DLLs or make a connection.
References ---------- Bug:2498880 - Oracle 9I Release 2 Installation Issue on Windows 2000 NTFS File System Additional Search Words ----------------------- OLEDB
...全文
相关推荐
Oracle开启归档模式
```bashsu - oracle```**步骤3**：使用SQL*Plus登录到Oracle数据库。```bashsqlplus /nolog```**步骤4**：以系统管理员身份登录数据库。
MySQL 8.4.6 LTS 离线部署实战：从零搭建企业级稳定数据库环境
数据库作为现代应用的核心基础设施，其稳定性与可靠性直接关系到业务连续性。在众多数据库系统中，MySQL凭借其开源特性、成熟生态与高性能，成为企业级应用的首选之一。其核心原理基于客户端-服务器架构，通过SQL语言进行数据操作，并利用存储引擎（如InnoDB）实现事务处理与数据持久化。对于生产环境而言，长期支持（LTS）版本的价值尤为突出，它通过提供长达数年的安全更新与错误修复，在“功能创新”与“运行稳定”之间取得了关键平衡，有效降低了运维风险与升级成本。特别是在服务器没有网的离线部署场景下，如何基于官方二进制
KingbaseES V9R1C10 Windows安装深度指南：原理、避坑与服务配置
国产数据库KingbaseES作为PostgreSQL内核的信创主力，其安装过程远不止点击下一步——它涉及授权验证、服务注册、端口策略、实例初始化等底层系统交互。理解安装向导背后的MSI框架、RSA签名授权校验、pg_hba.conf网络访问控制及Windows服务权限机制，是保障政务云、金融POC等关键场景稳定交付的基础。尤其在等保合规、Docker兼容、中文编码、防病毒软件干扰等真实工程约束下，V9R1C10的‘开箱即用’封装反而提高了排错门槛。本文聚焦Windows平台，解析授权文件.dat的SHA-
机器学习误差六层来源：从数据采集到部署反馈的实战排查指南
机器学习中的误差并非单一指标偏差，而是贯穿数据全生命周期的系统性污染链。理解误差来源是构建可靠AI系统的前提——它涉及数据采集失真、标签定义模糊、特征信息损失、算法假设错配、评估脱离业务、线上环境漂移等核心环节。这些误差往往以空值率突增、标注一致性低（如Fleiss' Kappa＜0.6）、特征与业务常识冲突、时间序列随机切分、PSI＞0.1等可观测形态存在。其技术价值在于将抽象模型问题转化为可定位、可量化、可干预的工程动作；典型应用场景包括金融风控误判、推荐系统转化率下降、IoT设备预测性维护失效等。本文
打开Oracle数据库的归档模式
在归档模式下，Oracle数据库提供了更高的数据保护级别，因为所有事务的更改都会被记录在归档日志中，这对于实现数据库的时间点恢复或者在灾难性故障后恢复数据至关重要。
