Chinaunix

标题: 帮我看看 TNS：protocol adapter　error [打印本页]

作者: giant 时间: 2004-04-27 11:41
标题: 帮我看看 TNS：protocol adapter　error
SQL>;connect /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

SQL>;

我的ＯＲＡＣＬＥ９Ｉ＋ＷＩＮ２０００　启动时报以上错误是什么意思

作者: giant 时间: 2004-04-27 11:44
标题: 帮我看看 TNS：protocol adapter　error
ＯＲＡ－１２５６０：ＴＮＳ：protocol adapter error

作者: txfy 时间: 2004-04-27 15:05
标题: 帮我看看 TNS：protocol adapter　error
你是不是有防火墙呀？端口被限制了？

作者: giant 时间: 2004-04-29 15:03
标题: 帮我看看 TNS：protocol adapter　error
没有啊

作者: txfy 时间: 2004-04-29 16:38
标题: 帮我看看 TNS：protocol adapter　error
2000？xp?你看看你的服务里的listener.ora是不是没起呀？

作者: ruknow 时间: 2004-04-29 17:42
标题: 帮我看看 TNS：protocol adapter　error
跟我一样的问题:
C:\>;lsnrctl

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 29-APR-2004 17:17
38

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL>; statu
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yuan)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                   listener
Version                TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produ
tion
Start Date             29-APR-2004 17:11:51
Uptime                   0 days 0 hr. 5 min. 52 sec
Trace Level             off
Security                OFF
SNMP                   OFF
Listener Parameter File G:\oracle\ora92\network\admin\listener.ora
Listener Log File       G:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yuan)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "KING" has 1 instance(s).
  Instance "KING", status UNKNOWN, has 1 handler(s) for this service...
Service "OEMREP" has 1 instance(s).
  Instance "OEMREP", status UNKNOWN, has 1 handler(s) for this service...
Service "

LSExtProc" has 1 instance(s).
Instance "

LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>; quit

C:\>;sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Apr 29 17:18:47 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL>; conn sys/oracle as sysdba;
ERROR:
ORA-12560: TNS:protocol adapter error

SQL>;

作者: ruknow 时间: 2004-04-29 17:49
标题: 帮我看看 TNS：protocol adapter　error
只启动了LISTENER就会出现上面的错误,
手动启动数据库服务以后就可以连接了,
难道WINDOWS下不能用SQLPLUS命令行来启动数据库服务?

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)