“Log messages written to /opt/oracle/product/9.2.0/network/log/listener.log” 还是先看一下日志里面记录了什么错误再说吧~
/opt/oracle/product/9.2.0/network/log/listener.log日志显示信息如下: -------------------------------------------------TNSLSNR for Linux: Version 9.2.0.1.0 - Production on 13-APR-2004 14:02:29Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.System parameter file is /opt/oracle/product/9.2.0/network/admin/listener.ora Log messages written to /opt/oracle/product/9.2.0/network/log/listener.log Trace information written to /opt/oracle/product/9.2.0/network/trace/listener.trc Trace level is currently 0Started with pid=4251 Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use 13-APR-2004 14:02:29 * 12502 TNS-12502: TNS:listener received no CONNECT_DATA from client 13-APR-2004 14:06:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=dbserver)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0 13-APR-2004 14:08:30 * service_update * sms * 0 13-APR-2004 14:18:32 * service_update * sms * 0 13-APR-2004 14:28:34 * service_update * sms * 0 13-APR-2004 14:58:39 * service_update * sms * 0
在/opt/oracle/product/9.2.0/network/log/listener.log日志里,出错误的提示:TNS-12560: TNS:protocol adapter error TNS-00512: Address already in useLinux Error: 98: Address already in use
看来是有重复的项目
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbserver )(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = sms)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = sms)
)
)
------------------------
你使用的是 IPC 协议,不过好像是你的连接串不正确,导致了地址被占用,你试试换个端口或者将监听协议进行修改试试,----------------
具体怎么操作,能告之吗?
我是初学者,请多指教!
EXTPROC_CONNECTION_DATA,EXTPROC_CONNECTION_DATA.WORLD=
( DESCRIPTION=
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
(CONNECT_DATA=(SID=PLSExtProc))
)
lsnrctl stop 监听,然后再lsnrctl start再看看提示如何...
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)))
(CONNECT_DATA =(SID = PLSExtProc))
)
还是先看一下日志里面记录了什么错误再说吧~
-------------------------------------------------TNSLSNR for Linux: Version 9.2.0.1.0 - Production on 13-APR-2004 14:02:29Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.System parameter file is /opt/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/product/9.2.0/network/log/listener.log
Trace information written to /opt/oracle/product/9.2.0/network/trace/listener.trc
Trace level is currently 0Started with pid=4251
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
13-APR-2004 14:02:29 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
13-APR-2004 14:06:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=dbserver)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0
13-APR-2004 14:08:30 * service_update * sms * 0
13-APR-2004 14:18:32 * service_update * sms * 0
13-APR-2004 14:28:34 * service_update * sms * 0
13-APR-2004 14:58:39 * service_update * sms * 0
回复:ycbao(ycbao)
-----------------------
在tnsnames.ora中有以下一段
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
----------------
我前面已经提示了,安装数据库的系统是Linux Redhat 9.0
没有这HKEY_LOCALE_MACHIN
TNS-00512: Address already in useLinux Error: 98: Address already in use