ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 启动错误

oracle 启动错误

原创 Linux操作系统 作者:lucash 时间:2009-05-19 19:50:31 0 删除 编辑
今天启动数据库后退出,准备写开机启动ORACLE的脚本,先到oracle的bin目录下看了下dbshut,dbstart脚本。鬼使神差执行另一下dbshut,突然感觉不对径,
然后
[oracle@crys bin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 19 19:16:31 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected.                     /* 感觉跟平常不一样*/
SQL> show sga;
ORA-01012: not logged on                  /*真出问题了 */

尝试打开数据库,结果失败:
SQL> startup open;
ORA-01081: cannot start already-running ORACLE - shut it down first  
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup open;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
SQL> conn internal/oracle@ora10 as sysdba;
ERROR:
ORA-12541: TNS:no listener

查看TNS状态:
[oracle@crys bin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-MAY-2009 19:40:42

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=crys)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist

尝试用dbstart启动,提示如下错误:

[oracle@crys bin]$ dbstart
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
错误仍然继续

因为是自己的机器,接下来把oracle进程直接kill -9,然后
SQL> startup open;
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

看忘上资料说是hostname和/etc/hosts里不一致,想起中午在调apache的时候改过/etchosts文件,
改回来后启动成功。
这个错误刚开始的时候就出现了,没早想到,
原因是更改/etc/hosts前没有现关闭数据库,而导致执行了dbshut之前后的信息不一致,数据库无法启动。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21650889/viewspace-600490/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 一个起点
请登录后发表评论 登录
全部评论

注册时间:2009-05-14

  • 博文量
    5
  • 访问量
    3834