Native IP Address: 192.168.1.163
[Email protected] ~]$ Sqlplus/nolog
Sql*plus:release 10.2.0.2.0-production on Sun 4 19:32:13 2014
Copyright (c) 1982, 2005, Oracle. All rights Reserved.
@>conn sys/oracleerror:ora-01034:oracle not availableora-27101:shared memory realms does not existlinux Error:2: No s Uch file or directory
ORA-01034 and ORA-27101 are generated because the database does not start and requires a SYSDBA to enter the startup database.
#############################################################################################################
@>conn sys/oracle As
sysdbaConnected to an idle instance. [Email Protected]>startup
ora-00600:internal error code, arguments: [Keltnfy-ldminit], [[]], [1], [], [], [], [], [][Email protected]>startupora-24324:service handle not initializedora-01041:internal error. Hostdef extension doesn ' t exist
The root cause of the above ORA-00600 is that the server hostname is not properly configured, the host name through the hostname command can not be ping, oracle10g that the host could not be reached so start the database error.
Workaround: Add hostname to the/etc/hosts file, and modify/etc/sysconfig/network, keep hostname consistent. Restart the database.
[Email protected] ~]# Vi/etc/sysconfig/networknetworking=yesnetworking_ipv6=nohostname=rtest.localdomain
[[email protected] ~]# vi/etc/hosts# do not remove the following line, or various programs# that require network function Ality'll fail.127.0.0.1 ocm1.localdomain ocm1 localhost.localdomain localhost::1 Localhost6.lo Caldomain6 Localhost6192.168.1.163 rtest.localdomain rtest~
Before it was 192.168.1.161 Ocm1.localdomian OCM1
###########################################################################################[[email protected] ~] $ sqlplus "/as sysdba"
Sql*plus:release 10.2.0.2.0-production on Sun 4 19:43:40 2014
Copyright (c) 1982, 2005, Oracle. All rights Reserved.
Connected to an idle instance.
[Email protected]>startuporacle instance started.
Total System Global area 285212672 bytesfixed size 1260420 bytesvariable size 92275836 byte Sdatabase buffers 188743680 Bytesredo buffers 2932736 bytesdatabase mounted. Database opened. [Email protected]>