两百分求助：局域网内sqlplus连接server2003上oracle10g服务器报ORA-12541
局域网内sqlplus连接server 2003上的oracle10g服务器，报ORA-12541 两天了，尝试了网上的所有方案，仍然不行，请大家帮忙
1 系统信息 ：
ORACLE 10.2.0.1.0 WINDOWS SERVER 2003
数据库信息
全局数据库名：binladen.server606
系统标识符 binladen
C:\Documents and Settings\Administrator> sqlplus system/qazwsx@binladen
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 2 19:28:31 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
listner.log报错信息
02-4月 -2007 19:03:55 * (CONNECT_DATA=(SID=binladen)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=SERVER606)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.197.6.189)(PORT=1173)) * establish * binladen * 0
02-4月 -2007 19:04:11 * service_update * binladen * 0
02-4月 -2007 19:04:13 * (CONNECT_DATA=(SERVICE_NAME=BINLADEN)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\jdk\jre\bin\java.exe)(HOST=SERVER606)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=202.197.6.189)(PORT=1174)) * establish * BINLADEN * 12514
TNS-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
2 lsnrctl status 信息
C:\Documents and Settings\Administrator> lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-4月 -2007 19:0
4:35
Copyright (c) 1991, 2005, Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
启动日期 29-3月 -2007 15:40:27
正常运行时间 4 天 3 小时 24 分 11 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
监听程序日志文件 C:\oracle\product\10.2.0\db_1\network\log\listener.log
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server606)(PORT=1521)))
服务摘要..
服务 "PLSExtProc " 包含 1 个例程。
例程 "PLSExtProc ", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "binladen.server606 " 包含 1 个例程。
例程 "binladen ", 状态 READY, 包含此服务的 1 个处理程序...
服务 "binladenXDB.server606 " 包含 1 个例程。
例程 "binladen ", 状态 READY, 包含此服务的 1 个处理程序...
服务 "binladen_XPT.server606 " 包含 1 个例程。
例程 "binladen ", 状态 READY, 包含此服务的 1 个处理程序...
命令执行成功
3 tnsping binladen
C:\Documents and Settings\Administrator> tnsping binladen
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-4月 -
2007 19:12:22
Copyright (c) 1997, 2005, Oracle. All rights reserved.
已使用的参数文件:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = server606)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = binladen.serve
r606)))
OK (20 毫秒)
4 sqlnet.ora////////////////////////////////////////////
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only ", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
5 tnsnames.ora ////////////////////////////////////////////
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
BINLADEN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server606)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = binladen.server606)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
6 listener.ora ////////////////////////////////////////////
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server606)(PORT = 1521))
)
)
7 show sga结果
Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator> sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 4月 2 18:51:36 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn system/qazwsx as sysdba
已连接。
SQL> show sga
Total System Global Area 167772160 bytes
Fixed Size 1246852 bytes
Variable Size 83888508 bytes
Database Buffers 79691776 bytes
Redo Buffers 2945024 bytes
SQL> startup
ORA-01081: 无法启动已在运行的 ORACLE - 请首先关闭它
SQL>
SQL> alertlog
SP2-0042: 未知命令 "alertlog " - 其余行忽略。
SQL>
[解决办法]
1.执行lsnrctl stop
2.listener.ora修改为：
listener.ora ////////////////////////////////////////////
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
（SID_DESC =
(GLOBAL_DBNAME = binladen.server606)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = binladen)
）
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server606)(PORT = 1521))
)
)
3.执行lsnrctl start
然后再重新连接试下看
[解决办法]
5 tnsnames.ora ////////////////////////////////////////////
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
BINLADEN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server606)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = binladen.server606)
)
)
SERVICE_NAME = binladen.server606???
你的SERVICE_NAME对吗???
[解决办法]
应该是net configuration配置的有问题
[解决办法]
应该是oralce有问题，重装一下客户端吧
