LSNRCTL> start
启动tnslsnr:请稍候...TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
系统参数文件为d:\oracle8\ora81\network\admin\listener.ora
写入d:\oracle8\ora81\network\log\listener.log的日志信息
监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zhongyi)(PORT=1521)))连接至(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zhongyi)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 8.1.7.0.0
tion
启动日期 17-5月 -2003 17:19:13
正常运行时间 0 天 0 小时 0 分 2 秒
跟踪级别 off
安全性 OFF
SNMP OFF
监听器参数文件 d:\oracle8\ora81\network\admin\listener.ora
监听器日志文件 d:\oracle8\ora81\network\log\listener.log
服务摘要..
orcl 具有2个服务处理程序
PLSExtProc 具有1个服务处理程序
orcl 具有2个服务处理程序
命令执行成功又重新运行了一次,现在出现了上面这样的,
从SQL PLUS还是: TNS-12560: TNS:协议适配器错误
启动tnslsnr:请稍候...TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
系统参数文件为d:\oracle8\ora81\network\admin\listener.ora
写入d:\oracle8\ora81\network\log\listener.log的日志信息
监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zhongyi)(PORT=1521)))连接至(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zhongyi)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 8.1.7.0.0
tion
启动日期 17-5月 -2003 17:19:13
正常运行时间 0 天 0 小时 0 分 2 秒
跟踪级别 off
安全性 OFF
SNMP OFF
监听器参数文件 d:\oracle8\ora81\network\admin\listener.ora
监听器日志文件 d:\oracle8\ora81\network\log\listener.log
服务摘要..
orcl 具有2个服务处理程序
PLSExtProc 具有1个服务处理程序
orcl 具有2个服务处理程序
命令执行成功又重新运行了一次,现在出现了上面这样的,
从SQL PLUS还是: TNS-12560: TNS:协议适配器错误
Action: Start your listener with an unused address.
Generally this problem may ocurr for a incorrect setting in the listener.ora. Some causes of this problems may be:
a.- Some defined address in the listeners.ora is been used. Make sure other listeners are not running. Either listener.log and screen output appear the address with problemExplanation: The listener will try to acquire the address in exclusive mode, if this is been used then the process to get it will fail.
D:\oracle8\ora81\network\ADMIN
# LISTENER.ORA Network Configuration File: d:\oracle8\ora81\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zhongyi)(PORT = 1521))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle8\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = d:\oracle8\ora81)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
)
)D:\oracle8\ora81\hs\admin
# This is a sample listener.ora that contains the NET8 parameters that are
# needed to connect to an ODBC Agent# LISTENER =
# (ADDRESS_LIST=
# (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
# (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))# SID_LIST_LISTENER=
# (SID_LIST=
# (SID_DESC=
# (SID_NAME=hsodbc)
# (ORACLE_HOME=/private/app/oracle/product/8.1.6)
# (PROGRAM=hsodbc)
# )
# )#CONNECT_TIMEOUT_LISTENER = 0
ORA-12500: TNS: 监听程序无法启动专用服务器进程我是在服务器上操作的,先连到别的可以连得上的ORACLE服务器,
再用SQL> conn xiao/xiao@orcl 出现上面的提示
host改为用ip地址,试试。
如果出现了你这种情况:
LSNRCTL> stop
连接至(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zhongyi)(PORT=8088)))
TNS-12541: TNS:无监听器
TNS-12560: TNS:协议适配器出现错误
TNS-00511: 无监听器
32-bit Windows Error: 61: Unknown error
的时候,必须重新启动机器,再启动LSNRCTL就没有问题了,sqlplus 使用的是另外一个配置文件,tnsnames.ora.与这个关系不大