歡迎您光臨本站 註冊首頁

centos中安裝了oracle10g,啟動監聽問題

←手機掃碼閱讀     火星人 @ 2014-03-25 , reply:0

監聽啟動不了,求大神
[oracle@yang admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-SEP-2012 12:38:28

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /opt/oracle10g/product/10.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle10g/product/10.2.0/network/admin/listener.ora
Log messages written to /opt/oracle10g/product/10.2.0/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=221.238.203.46)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist (無法分配請求的地址)
TNS-12560: TNS:protocol adapter error (因目標主機或對象不存在)
TNS-00515: Connect failed because target host or object does not exist (協議適配器錯誤)
Linux Error: 99: Cannot assign requested address (連接失敗,因為目標主機或對象不存在)

Listener failed to start. See the error message(s) above...


這個是啟動監聽時的錯誤,下邊分別是listener.ora和tnsnames.ora的文件內容



# listener.ora Network Configuration File: /opt/oracle10g/product/10.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle10g/product/10.2.0)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 221.238.203.46)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

-------------------------------------------------------------------------------------------------------------------------------------


# tnsnames.ora Network Configuration File: /opt/oracle10g/product/10.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 221.238.203.46)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oral)
)
)


求解決,是不是host哪裡錯誤啊?怎麼改?

[火星人 ] centos中安裝了oracle10g,啟動監聽問題已經有522次圍觀

http://coctec.com/docs/linux/show-post-156385.html