One ORA-00130: invalid listener address error, ora-00130listener

Source: Internet
Author: User

One ORA-00130: invalid listener address error, ora-00130listener

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

Ora11g> sqlplus dcsopen/dcsopen1SQL * 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 does not have the configuration of 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. Check the/etc/hosts file: 127.0.0.1 localhost. localdomain localhost4 localhost4.localdomain4
: 1 localhost. localdomain localhost6 localhost6.localdomain6 found that there is no hostname corresponding item at all. Therefore, it is estimated that, 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 considered invalid..
Solution:/Etc/hosts add item: 172.27.19.57 dcsopen2Node Restart 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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.