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

This article shows you what kind of failure caused by ORA-00130, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1. Log in to the system check service

6 lines

Sqlplus "/ as sysdba" appears ORA-01012: not logged onps-ef | grep smon found that the smon process was present, suspected that there was a transaction that caused the database not to have a complete shutdown, because it was a test environment, I directly took the action of the kill smon process (production environment needs to be weighed) 2. Restart the library

45 lines

SQL > startup nomount ORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address'(ADDRESS= (PROTOCOL=TCP) (HOST=data) (PORT=1521)) 'this error occurs again and suddenly discovers that the hostname in host is not the same as the current hostname [oracle@data ~] $hostnamedata [oracle@data ~] $cat / etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.10.8 ycdb01-10-8 directly modify hostnamehostname ycdb01-10-8 check whether the hostname of / etc/sysconfig/network is consistent SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 26 14:42:12 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL > startup nomount;ORACLE instance started.Total System Global Area 6263357440 bytesFixed Size 2264856 bytesVariable Size 1375731944 bytesDatabase Buffers 4865392640 bytesRedo Buffers 19968000 bytesSQL > alter database mount;Database altered.SQL > alter database open;Database altered. The database is ready for normal open. Summary: be sure to pay attention to some detailed parameters when deploying, that is, what the failure caused by ORA-00130 is like. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.