Log in to the database, prompt:
Ora11g>sqlplus dcsopen/dcsopen1sql*plus:release 11.2.0.1.0 Production on Mon Jan 5 18:49:31
Copyright (c) 1982, Oracle. All rights reserved.
ERROR:
Ora-01034:oracle Not available
ora-27101:shared Memory Realm does not exist
linux-x86_64 error:2: No such file or directory
Process id:0
Session id:0 Serial number:0
It looks like there is no boot, so start the database:
Ora11g>sqlplus/as sysdba
sql*plus:release 11.2.0.1.0 Production on Mon Jan 5 18:50:29
Copyright (c) 1982, Oracle. All rights reserved.
Connected to an idle instance.
sql> Startup
ORA-00119:INVALID specification for system parameter Local_listener
Ora-00130:invalid Listener Address ' (address= (protocol=tcp) (Host=dcsopen2node ) (port=1521)) 'reported that the above error, see where the listening information isHost=dcsopen2node, the first reaction is to listen to the file has a problem, view the following Listener.ora file:# Listener.ora Network Configuration File:/opt/app/ora11g/product/11.2.0/dcsopen/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
)
Adr_base_listener =/opt/app/ora11gNothe configuration of the Host=dcsopen2node.
View machine Name:Ora11g>hostname
Dcsopen2nodeDiscover the native name isDcsopen2node. Refer to some of the posts, it is possible that the Oracle will be launched at the same time to register a monitor with the same name hostname, so here is the error (address= (protocol=tcp) (Host=dcsopen2node) (port= 1521) This listener, prompt invalid address, and then view the/etc/hosts file: 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6It is found that there is no hostname correspondence at all, and it is inferred that
may be Oracle registered and hostname with the same name, but/etc/hosts does not define the HOSTNAME-IP counterpart, so this listener address is considered invalid。
workaround :Add items in/etc/hosts:172.27.19.57 Dcsopen2nodeRestart Service:Ora11g>sqlplus/as sysdba
sql*plus:release 11.2.0.1.0 Production on Mon Jan 5 20:33:32
Copyright (c) 1982, Oracle. All rights reserved.
Connected to an idle instance.
sql> Startup
ORACLE instance started.
Total System Global area 3290345472 bytes
Fixed Size 2217832 bytes
Variable Size 2533361816 bytes
Database buffers 738197504 bytes
Redo buffers 16568320 bytes
Database mounted.
Database opened.everything was restored to peace.
Once Ora-00130:invalid listener address error
