Oracle啟動出現了ORA-00119,ORA-00130

strivechao發表於2019-05-08

啟動的 ,執行startup,出現了下面故障碼,

SQL> startup

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=orapy)(PORT=1521))'

SQL>

根據ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=orapy)(PORT=1521))' 初步判斷是IP設定問題

檢視主機ip

[root@orapy ~]# ifconfig
eth1 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

檢視監聽檔案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)) 發現配置檔案的ip和主機ip不一致
)

修改好ip好,啟動oracle,問題還是出現

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

再檢視一下linux的配置問題hosts,發現ip配置錯誤,

[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  ------------修改為對應的ip和主機名 (我這裡是192.168.216.129 orapy)
[root@orapy ~]#

然後啟動資料庫,問題解決

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>


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25469263/viewspace-2643663/,如需轉載,請註明出處,否則將追究法律責任。

相關文章