ORA-00130 引發的故障

sqlplus "/ as sysdba"
出現ORA-01012: not logged on
ps -ef |grep smon
發現smon程式在，懷疑是有事務導致資料庫沒有完全shutdown
由於是測試環境,我直接採取了kill smon程式的操作(生產環境需要權衡) 

SQL> startup nomount;
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=data)(PORT=1521))'

又出現此錯誤

突然發現host裡面的主機名跟當前主機名不一致，
[oracle@data ~]$ hostname
data
[oracle@data ~]$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.10.8 ycdb01-10-8

直接修改hostname
hostname  ycdb01-10-8

注意檢查一下/etc/sysconfig/network 主機名是否一致

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 26 14:42:12 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 6263357440 bytes
Fixed Size		    2264856 bytes
Variable Size		 1375731944 bytes
Database Buffers	 4865392640 bytes
Redo Buffers		   19968000 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

資料庫可以正常open了。
總結：在部署的時候一定要注意一些細節引數