CentOS7下Oracle 11gR2監聽啟動錯誤解決
Oracle監聽程式啟動失敗,錯誤如下:
[oracle@localhost ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-APR-2016 00:27:54
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /data/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
[oracle@localhost ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 odb-sonny
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
網速查資料說etc/hosts中需要添加127.0.0.1 localhost 測試無果~~
然後又試了一堆方法,未果~~
最後把listerner.ora中localhost修改為本機IP正常~~
[oracle@localhost ~]$ cat /data/oracle/product/11.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /data/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.232.133)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /data/oracle
[oracle@localhost ~]$