ORA－12560：TNS：协议适配器错误,始终没有解决。在线请教高手

jswdong

我的完整配置文档如下，请高手指教。
listener.ora:
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 128.76.35.24)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 128.76.35.24)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora8)
(ORACLE_HOME = e:\oracle\ora81)
(SID_NAME = ora8)
)
)


tnsnames.ora:
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORA8 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 128.76.35.24)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora8)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 128.76.35.24)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ora8)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

cma =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 128.76.35.24)(PORT = 1521))
(CONNECT_DATA = (SID = ORA8))
)

services.ora:
cma = (ORACLE_NODE, cma,cma,(PLATFORM=(osName=Windows NT)(osVersion=5.2)))


cma:80 = (oracle_sysman_webserver, cma, http://cma:80/server-status, Apache/1.3.12.0.1a, e:\oracle\ora81\Apache\Apache\conf\httpd.conf, e:\oracle\ora81\Apache\Apache)

husthxd

本地连接不需要监听器。
所以listener.ora、tnsnames.ora文件不存在也不会影响本地连接。
用dbca生成建库脚本手工创建数据库试试？
如有错误把信息贴出来。

jswdong

用dbca生成建库脚本手工创建数据库提示
ORA－12560：TNS：协议适配器错误

intotherain

试试卸载TCP/IP协议吧，如有其他服务依赖于TCP/IP协议，先停止该服务．
或许是底层通信协议的问题，我遇过．