很奇怪,为何我的机子在连上网时,使用PL/SQL连接就会报:ora-12541:TNS没有监听器,但是可以使用SQL*PLUS登陆。我看了监听的状态是:
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 08-4月 -2009 18:53:38
Uptime 0 days 1 hr. 18 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.1.0\Db_1\network\admin\listener.o
ra
Listener Log File E:\oracle\product\10.1.0\Db_1\network\log\listener.logListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=QU_YZ)(PORT=8080))(Presentati
on=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=QU_YZ)(PORT=2100))(Presentati
on=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully启动监听器时就出现错误:
LSNRCTL> start
Starting tnslsnr: please wait...
Service OracleOraDb10g_home1TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1056: Unknown error请高手指点,为什么不能使用PL/SQL连接的啊!!!!!!!!!!!!!!!!!!!!!!!!!!!!
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 08-4月 -2009 18:53:38
Uptime 0 days 1 hr. 18 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.1.0\Db_1\network\admin\listener.o
ra
Listener Log File E:\oracle\product\10.1.0\Db_1\network\log\listener.logListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=QU_YZ)(PORT=8080))(Presentati
on=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=QU_YZ)(PORT=2100))(Presentati
on=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully启动监听器时就出现错误:
LSNRCTL> start
Starting tnslsnr: please wait...
Service OracleOraDb10g_home1TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1056: Unknown error请高手指点,为什么不能使用PL/SQL连接的啊!!!!!!!!!!!!!!!!!!!!!!!!!!!!
解决方案 »
- 请教两个sql语句的写法
- 给了年月和第几周 如'2006073',如何得到本周是从哪天开始到哪天结束的呀!!
- 求sql语句,如何复制一条记录?
- 请问oracle9i中SALES_HISTORY_ROLE的权限是什么,在8i中相应role是什么 谢谢!
- 请问如何用SQL语句删除一个表空间里的所有表?
- 不容易啊,终于变成了一颗星!
- 各位大侠是否DBMS_OUTPUT.put_line一行只能输出255个字符?怎样实现将一个大约有3000个字符的varchar2变量输出(里面存的是个SQL)?
- Nt Server 4下Oracle 的ODBC-连接出错,请指教!
- 请教!在oracle中我想返回一个数组,......
- 实例已创建。DIM-00019:创建服务时出错 O/S-Error:(OS1053)服务没有及时响应启动或控制请求
- 如何在oracle中获取并写入图片?
- ORACLE 函数问题
plsql必须用网络服务名,在配置错误的情况下无法登陆建议,把listener.ora和tnsnames.ora里面关于本机IP地址的地方全部改成机器名。