ora9i 監聽器麻煩問題

显示全部楼层 · 2008-1-2 17:35:53

Linux + oracle:Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production (虛擬機上)
$lsnrctl start--啟動失敗
$cat listener.log 錯誤如下
________________________________________________________________________
TNSLSNR for Linux: Version 9.2.0.4.0 - Production on 01-APR-2010 16:18:12
Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.
System parameter file is /opt/ora9/product/9.2/network/admin/listener.ora
Log messages written to /opt/ora9/product/9.2/network/log/listener.log
Trace information written to /opt/ora9/product/9.2/network/trace/listener.trc
Trace level is currently 0
Started with pid=1517
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Linux)(PORT=1521))
)
TNS-12542: TNS:address already in use
TNS-12560: TNS

rotocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
$cat listener.ora
________________________________________________________________________
# LISTENER.ORA Network Configuration File: /opt/ora9/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora9i)
(ORACLE_HOME =/opt/ora9/product/9.2)
(SID_NAME = ora9i)
)
)
--嘗試圖形界面操作
$startx
$netca--點NEXT 無反應

$netmgr--方式創建監聽器 listener.ora 格式如下
# LISTENER.ORA Network Configuration File: /opt/ora9/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521))
)
請高手幫忙
[ 本帖最后由 caijue204 于 2010-4-1 16:31 编辑 ]

千问 · 2008-1-2 17:35:53

提示信息不是很明白么
TNS-12542: TNS:address already in use
要么是监听器已经开了，要么是别的程序占用了1521端口，先lsnrctl stat看看，没开的话换个端口试试，比如1522

ora9i 監聽器 麻煩問題

ora9i 監聽器麻煩問題