今天启动数据库后退出,准备写开机启动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博客 ” ,链接:https://blog.itpub.net/21650889/viewspace-600490/
,如需转载,请注明出处,否则将追究法律责任。