Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the problem of Oracle startup error report ORA-00119". In daily operation, I believe many people have doubts about how to solve the problem of Oracle startup error report ORA-00119. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubt of "how to solve the problem of Oracle startup error report ORA-00119". Next, please follow the editor to study!

The Oracle that starts, executes startup, and the following fault code appears

SQL > startup

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00130: invalid listener address'(ADDRESS= (PROTOCOL=TCP) (HOST=orapy) (PORT=1521))'

SQL >

According to ORA-00130: invalid listener address'(ADDRESS= (PROTOCOL=TCP) (HOST=orapy) (PORT=1521))', it is preliminarily judged that it is the IP setting problem.

View host ip

[root@orapy ~] # ifconfig

Eth2 Link encap:Ethernet HWaddr 00:0C:29:A7:7A:5D

Inet addr:192.168.216.129 Bcast:192.168.216.255 Mask:255.255.255.0

Inet6 addr: fe80::20c:29ff:fea7:7a5d/64 Scope:Link

View the listening file listener.ora

[oracle@orapy admin] $cat listener.ora

# listener.ora Network Configuration File: / u01/app/oracle/product/11.2.1/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.216.128) (PORT = 1521)) found that the ip of the configuration file is inconsistent with the host ip

)

It is better to modify ip, start oracle, the problem still occurs

SQL > startup

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00130: invalid listener address'(ADDRESS= (PROTOCOL=TCP) (HOST=orapy) (PORT=1521))'

SQL >

Take another look at the configuration problem of linux, hosts, and find that ip is misconfigured.

[root@orapy ~] # cat / etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

#:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.216.128 st-modified to the corresponding ip and hostname (192.168.216.129 orapy here)

[root@orapy ~] #

Then start the database and solve the problem.

SQL > startup

ORACLE instance started.

Total System Global Area 368263168 bytes

Fixed Size 1336596 bytes

Variable Size 272632556 bytes

Database Buffers 88080384 bytes

Redo Buffers 6213632 bytes

Database mounted.

Database opened.

SQL >

At this point, the study on "how to solve the problem of Oracle startup error reporting ORA-00119" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.