【环境介绍】
系统环境:windows + Oracle 11GR2 + 单机
【背景描述】
业务反馈Oracle数据库连接不上,报错信息为ORA-01033错误,错误信息:
该报错信息解释为数据库正在启动或者数据库关闭状态
[oracle@alllinux ~]$ oerr ora 01033 01033, 00000, "ORACLE initialization or shutdown in progress" // *Cause: An attempt was made to log on while Oracle is being started up // or shutdown. // *Action: Wait a few minutes. Then retry the operation.
【问题处理】
根据无法连接数据库,建议Telnet数据库看看数据库连接是否正常,结果为Telnet验证正常,监听无问题;
登录数据库查看数据库是否异常,查看open_mode状态为mount的状态,尝试使用alter database open,尝试打开数据库,报错信息为:
ORA-00600: ??????, ??: [2252], [2888], [636089479], [2820], [959676416], [], [], [], [], [], [], []
查看数据库错误日志:
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\hisdb\hisdb\trace\hisdb_ora_3456.trc: ORA-00600: ??????, ??: [2252], [2888], [636089479], [2820], [959676416], [], [], [], [], [], [], [] ORA-600 signalled during: alter database open... Fri Jan 01 00:19:10 2010 Sweep [inc][126516]: completed Sweep [inc2][126516]: completed Fri Jan 01 00:20:06 2010
根据00600报错在MOS查询,建议查看操作系统时间,查看操作系统时间与当前时间相差很大,调整操作系统时间后正常启动。
![](https://www.codeprj.com/image/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2ktYmV0YS8xMzM4MTg4LzIwMTkxMi8xMzM4MTg4LTIwMTkxMjIzMTE1NDM5ODQxLTMxNzU3NTUyMS5wbmc=.png)
|