ORA-00130: invalid listener address error resolved

ORA-00130: invalid listener address error resolved

Log on to the Oracle database. The following message is displayed:

Ora11g> sqlplus dcsopen/dcsopen1
SQL * Plus: Release 11.2.0.1.0 Production on Mon Jan 5 18:49:31 2015
Copyright (c) 1982,200 9, Oracle. All rights reserved.
ERROR:
A 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

 

If the database is not started, start the database:

Ora11g> sqlplus/as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Mon Jan 5 18:50:29 2015
Copyright (c) 1982,200 9, 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 ))'
The above error is reported. The listening information is HOST = dcsopen2Node. The first response is that there is a problem with the listening file. Check the 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/ora11g
There is no configuration for HOST = dcsopen2Node.

View the machine Name:
Ora11g> hostname
Dcsopen2Node
The local name is dcsopen2Node. Refer to some posts, saying that it is possible that a listener with the same name as hostname will be registered at the same time when oracle is started, so the error message here is (ADDRESS = (PROTOCOL = TCP) (HOST = dcsopen2Node) (PORT = 1521) This listener prompts that the address is invalid, and then check the/etc/hosts file:
127.0.0.1 localhost. localdomain localhost4 localhost4.localdomain4
: 1 localhost. localdomain localhost6 localhost6.localdomain6
No hostname corresponding item is found. From this assumption, it may be a listener with the same name as the hostname registered in Oracle, but no hostname-IP corresponding item is defined in/etc/hosts, therefore, the listener address is invalid.

Solution:
Add items in/etc/hosts:
172.27.19.57 dcsopen2Node
Restart the service:
Ora11g> sqlplus/as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Mon Jan 5 20:33:32 2015
Copyright (c) 1982,200 9, 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 has recovered.