The ORA-01092: ORACLE instance terminated disconnection forced
来源:互联网 发布:上位机组态软件 编辑:程序博客网 时间:2024/05/16 09:35
今天启动database 的时候,先到mounted ,后来就force terminated, 数据库shutdown 了,后来查了alert log, 发现是bdump 里的trc 不能打开,原因是数据库以外关闭的。
下面看一下oracle 的提供的信息:
The Oracle docs note details on the ORA-1092 error:
ORA-01092: ORACLE instance terminated. Disconnection forced
Cause: The instance connected to was terminated abnormally, probably due to aSHUTDOWN ABORT
. The current process was forced to disconnect from the instance.
Action: Examine the alert log for more details. Contact the database administrator to determine when the instance is restarted. Attempt to reconnect after the instance is running again.
The ORA-01092: ORACLE instance terminated Disconnection forced. is a generic error when Oracle detects a serious problem at database start time.
The ORA-01092: ORACLE instance terminated error can be caused by many factors :
- A shutdown abort
- Bad permissions of BDUMP, CDUMP or UDUMP directories
- Missing datafiles
- Renaming files when Oracle is down
- and many other OS-related causes
Check your alert log for a more descriptive report of the exact startup problem.
Check …./bdump/*.log
ORA-30012: undo tablespace ‘UNDO_TBS’ does not exist or of wrong type
SQL> startup mount
SQL> select name from v$datafile;
SQL> show parameter undo;
SQL> select name from v$tablespace;
SQL> alter system set undo_tablespace=’undotbs1′ scope=spfile;
SQL> shutdown immediate;
SQL> startup;
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/undo.htm
可以先启动database 到mounted 状态, show parameter dump
看到bdump 下alert 日志。
- ORA-01092: ORACLE instance terminated. Disconnection forced
- The ORA-01092: ORACLE instance terminated disconnection forced
- 【ORACLE】升级数据字典,解决ORA-01092: ORACLE instance terminated. Disconnection forced问题
- sap install dba tools出错ORA-01092: ORACLE instance terminated. Disconnection forced
- 不能打开数据库的一次处理 ORA-01092: ORACLE instance terminated. Disconnection forced
- 给大家说明。升级数据字典,解决ORA-01092: ORACLE instance terminated. Disconnection forced问题
- ORA-01092:ORACLE instance terminated. Disconection forced
- oracle10g升级后启动失败(ORACLE instance terminated. Disconnection forced)
- Instance terminated by PMON
- ORA-00603: ORACLE server session terminated by fatal error
- ORA-00600 internal error code, arguments [1265]和ORA-00603 ORACLE server session terminated by fatal
- ORA-15149: another ASM instance found running on the host
- ORA-15149: another ASM instance found running on the host
- Connected to an idle instance. ORA-01034: ORACLE not available
- Oracle 10g RAC ASM Instance Conenction ORA-12528
- the cdb process terminated
- oracle的sqlplus中插入中文错误:ERROR: ORA-01756: quoted string not properly terminated
- oracle 10.2.0.1 ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance
- 中文转数字
- 合并模块和安装文件的区别
- android基础
- 游戏UI设计2
- WS_CLIPCHILDREN,WS_CLIPSIBLINGS含义
- The ORA-01092: ORACLE instance terminated disconnection forced
- Android内存泄漏简介
- 深入理解C/C++数组和指针
- 一、叙述Hibernate应用的主要接口和类
- 关于回车换行
- 由这篇文章引发的思考“技术控解释为什么Android没有iOS那么顺滑”
- 讨论 Setsockopt选项
- Hibernate中的复杂查询
- Android中如何查找内存泄露