求助 TNS：监听程序当前无法识别描述中的请求服务

AC0858 2013-04-08 09:45:53

4月5号才出现的问题，之前用了1年都没问题，网上说的方法也都试了改listener都没用，希望各位老大们能帮我想个好一点的解决方法。哎真受伤呀！

我贴上配置：listene配置
# listener.ora Network Configuration File: D:\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 = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = serverdata)(PORT = 1521))
)
)
tnsnames配置：
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.254)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

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

...全文

2102 64 打赏收藏转发到动态举报

写回复

用AI写文章

64 条回复

切换为时间正序

请发表友善的回复…

发表回复

iqlife 2013-04-09

打赏
举报

1：最近系统做了哪些变动 2：用netca删除所有的监听，重新配置

AC0858 2013-04-09

打赏
举报

请别人看了后说是37行有问题，select object_id,object_name,object_type,owner from dba_objects where object_id=37

AC0858 2013-04-09

打赏
举报

引用 58 楼 linwaterbin 的回复:

ps aux | grep ora_

这是怎么说的呢？

AC0858 2013-04-09

打赏
举报

日志太多上传不了

AC0858 2013-04-09

打赏
举报

Wed Apr 03 23:33:09 2013 Thread 1 advanced to log sequence 132126 Current log# 2 seq# 132126 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO02.LOG Thread 1 cannot allocate new log, sequence 132127 Checkpoint not complete Current log# 2 seq# 132126 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO02.LOG Wed Apr 03 23:33:20 2013 Thread 1 advanced to log sequence 132127 Current log# 3 seq# 132127 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO03.LOG Wed Apr 03 23:33:47 2013 Thread 1 cannot allocate new log, sequence 132128 Checkpoint not complete Current log# 3 seq# 132127 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO03.LOG Thread 1 advanced to log sequence 132128 Current log# 1 seq# 132128 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO01.LOG Wed Apr 03 23:42:11 2013 Thread 1 advanced to log sequence 132129 Current log# 2 seq# 132129 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO02.LOG Wed Apr 03 23:42:22 2013 Thread 1 advanced to log sequence 132130 Current log# 3 seq# 132130 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO03.LOG Wed Apr 03 23:44:23 2013 Thread 1 advanced to log sequence 132131 Current log# 1 seq# 132131 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO01.LOG Wed Apr 03 23:44:34 2013 Thread 1 cannot allocate new log, sequence 132132 Checkpoint not complete Current log# 1 seq# 132131 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO01.LOG Wed Apr 03 23:44:50 2013 Thread 1 advanced to log sequence 132132 Current log# 2 seq# 132132 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\HYCMP\REDO02.LOG

AC0858 2013-04-09

打赏
举报

没做过改动，出现这问题的前一天服务器死机过，我把日志发上来

AC0858 2013-04-08

打赏
举报

坐等解决方案。真是欲哭无泪呀！谢谢xinpingf的帮忙，没有你我不会连接成功，再次感谢你。也谢谢f0restwow，给出的提议，谢谢

AC0858 2013-04-08

打赏
举报

那这种问题都没谁遇见过吗/到手的希望

xinpingf 2013-04-08

打赏
举报

引用 46 楼 selectza0858 的回复:

天呐！我把错误日志找出来看看可以不呢？

只能从日志里看了，不过就算看日志也是很麻烦的

AC0858 2013-04-08

打赏
举报

你出现的是一会儿自动关闭变成连接到空闲例程了吗？

f0restwow 2013-04-08

打赏
举报

我今天也遇到楼主的情况。监听文件里加了 (SID_DESC = (GLOBAL_DBNAME = localorcl) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (SID_NAME = localorcl) ) localorcl是我本地的SID。。。然后停止、启动监听。再shutdown和startup数据库。就没问题了。不知道你的情况是不是也可以。

AC0858 2013-04-08