在Linux环境下，尝试启动Oracle 11.2.0.3.0数据库的监听器时遇到错误，错误信息显示监听器地址不正确及诊断框架初始化失败。监听器配置文件`listener.ora`中包含了IPC协议和TCP协议的地址设置，但启动时遇到了TNS-01150和TNS-01153错误。问题可能与监听器配置、网络设置或权限有关。
Dear Experts,
I am facing problem with listener startup on newly installed database. Please provide the solution below issue
OS:
Linux solmanserver 2.6.9-55.EL #1 Fri Apr 20 16:25:34 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux
Database: Oracle 11.2.0.3.0
=================================================================
[[email protected] 112_64]$ lsnrctl start LISTENERSMP
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-OCT-2012 23:02:16
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /oracle/SMP/112_64/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /oracle/SMP/112_64/network/admin/listener.ora
Log messages written to /oracle/SMP/112_64/network/log/listenersmp.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SMP.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SMP)))
TNS-01150: The address of the specified listener name is incorrect
TNS-01153: Failed to process string: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=solmanserver)(PORT=1521))
NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging
NL-08002: Diagnosability context creation failed
Listener failed to start. See the error message(s) above...
=================================================================
===============================
listener.ora file contents
===============================
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/LISTENER.ORA#2 $
################
ADMIN_RESTRICTIONS_LISTENERSMP = on
LISTENERSMP =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = SMP.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = SMP)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = solmanserver)
(PORT = 1521)
)
)
STARTUP_WAIT_TIME_LISTENERSMP = 0
CONNECT_TIMEOUT_LISTENERSMP = 10
TRACE_LEVEL_LISTENERSMP = OFF
SID_LIST_LISTENERSMP =
(SID_LIST =
(SID_DESC =
(SID_NAME = SMP)
(ORACLE_HOME = /oracle/SMP/112_64)
)
)
ADR_BASE_LISTENERSMP = undefined
1346
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
