设为首页 加入收藏

TOP

OracleORA-01034,ORA-27101,ORA-00600
2015-07-24 10:54:47 来源: 作者: 【 】 浏览:2
Tags:OracleORA-01034 ORA-27101 ORA-00600

本机IP地址:192.168.1.163
[oracle@rtest ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Sun May 4 19:32:13 2014
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
@>conn sys/oracle ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory
产生ORA-01034和ORA-27101是因为数据库没有启动,需要有sysdba进入启动数据库
#############################################################################################################
@>conn sys/oracle as sysdba Connected to an idle instance. SYS@TEST0422>startup ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] SYS@TEST0422>startup ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist

产生以上ORA-00600根本原因是服务器hostname没有正确配置,通过hostname命令得到的主机名无法ping通,Oracle10g认为主机无法达到所以启动数据库报错。
解决方法:将hostname添加到/etc/hosts文件中,并且修改/etc/sysconfig/network,让hostname保持一致。重新启动数据库。

[root@rtest ~]# vi /etc/sysconfig/network NETWORKING=yes NETWORKING_IPV6=no HOSTNAME=rtest.localdomain

[root@rtest ~]# vi /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 ocm1.localdomain ocm1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 192.168.1.163 rtest.localdomain rtest ~
之前是192.168.1.161 ocm1.localdomian ocm1

########################################################################################### [oracle@rtest ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Sun May 4 19:43:40 2014
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SYS@TEST0422>startup ORACLE instance started.
Total System Global Area 285212672 bytes Fixed Size 1260420 bytes Variable Size 92275836 bytes Database Buffers 188743680 bytes Redo Buffers 2932736 bytes Database mounted. Database opened. SYS@TEST0422>
?

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇如何彻底删除Oracle数据库,以创.. 下一篇oracle的乐观锁和悲观锁

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·微服务 Spring Boot (2025-12-26 18:20:10)
·如何调整 Redis 内存 (2025-12-26 18:20:07)
·MySQL 数据类型:从 (2025-12-26 18:20:03)
·Linux Shell脚本教程 (2025-12-26 17:51:10)
·Qt教程,Qt5编程入门 (2025-12-26 17:51:07)