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
The generation of ORA-01034 and ORA-27101 is due to the fact that the database is not started and requires SYSDBA into the startup database.
#############################################################################################################
@>conn sys/oracle as sysdbaConnected to an idle instance. [Email protected]>startupora-00600:internal error code, arguments: [Keltnfy-ldminit], [46], [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 serverhostname is not properly configured and the hostname obtained by the hostname command cannot be ping. oracle10g think the host is unable to achieve so start database error.
Workaround: Add hostname to the/etc/hosts file. and Change/etc/sysconfig/network, keep hostname consistent. start the database again.
[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]>
Oracle ora-01034,ora-27101,ora-00600