Shulou(Shulou.com)06/01 Report--

I. description of the environment

Suse 11 Enterprise SP3, Oracle 11gR2 single instance

Second, the question

The database cannot be started after the hostname is modified

III. Problem handling

1. Phenomenon

Mmpt-site:~ # su-oracleoracle@mmpt-site:~ > sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 27 08:22:08 2018Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL > SQL > startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address'(ADDRESS= (PROTOCOL=TCP) (HOST=mmpt-site) (PORT=1521)) 'SQL > 2. Modify the correspondence between IP and hostname while modifying the hostname. Mmpt-SRJ:~ # vi / etc/hosts## hosts This file describes a number of hostname-to-address# mappings for the TCP/IP subsystem. It is mostly# used at boot time, when no name servers are running.# On small systems This file can be used instead of a # "named" name server.# Syntax:# # IP-Address Full-Qualified-Hostname Short-Hostname#127.0.0.1 localhost# special IPv6 addresses::1 localhost ipv6-localhost ipv6-loopbackfe00::0 ipv6-localnetff00::0 ipv6-mcastprefixff02::1 ipv6-allnodesff02::2 ipv6-allroutersff02::3 Ipv6-allhosts#192.168.1.11 suse11.site suse11192.168.1.11 mmpt-SRJ mmpt-SRJ~ "/ etc/hosts" 24L 718C written mmpt-SRJ:~ # su-oracleoracle@mmpt-SRJ:~ > sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 27 08:36:14 2018Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL > SQL > startupORACLE instance started.Total System Global Area 784998400 bytesFixed Size 2217464 bytesVariable Size 465570312 bytesDatabase Buffers 314572800 bytesRedo Buffers 2637824 bytesDatabase mounted.Database opened.SQL >

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.