局域网内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@binladenSQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 2 19:28:31 2007Copyright (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 statusLSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-4月 -2007 19:0
4:35Copyright (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 binladenTNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-4月 -
2007 19:12:22Copyright (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 /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期一 4月 2 18:51:36 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn system/qazwsx as sysdba
已连接。
SQL> show sgaTotal 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>
ORACLE 10.2.0.1.0 WINDOWS SERVER 2003
数据库信息
全局数据库名:binladen.server606
系统标识符 binladen
C:\Documents and Settings\Administrator>sqlplus system/qazwsx@binladenSQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 2 19:28:31 2007Copyright (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 statusLSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-4月 -2007 19:0
4:35Copyright (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 binladenTNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-4月 -
2007 19:12:22Copyright (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 /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期一 4月 2 18:51:36 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn system/qazwsx as sysdba
已连接。
SQL> show sgaTotal 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>
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
然后再重新连接试下看
# 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对吗???
SERVICE_NAME = binladen.server606
您说是服务器端还是客户端的net configuration配置的有问题?
我在服务器端对net configuration配置一直测试不成功,奇怪?
但是,除了enterprise console manager以外,sqlplus system/qazwsx@linux ,PLSQL developer ,TOAD仍然不能访问数据库,报12541错误,大虾帮忙啊!!!# tnsnames.ora Network Configuration File: d:\oracle\product\10.2.0\client_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.LINUX =
(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)
)
)
谢谢大家提醒,现在远程可以使用enterprise console manager访问数据库拉!!!更改就是如上面所说,在net configuration 中把service name 改为binladen.server606
但是,除了enterprise console manager以外,sqlplus system/qazwsx@linux ,PLSQL developer ,TOAD仍然不能访问数据库,报12541错误,大虾帮忙啊!!!# tnsnames.ora Network Configuration File: d:\oracle\product\10.2.0\client_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.LINUX =
(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)
)
)