遭遇ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

最新推荐文章于 2024-12-19 16:33:49 发布

原创最新推荐文章于 2024-12-19 16:33:49 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#service #descriptor #command #domain #linux #database

Oracle 同时被 2 个专栏收录

523 篇文章

订阅专栏

Oracle EBS

416 篇文章

订阅专栏

本文记录了一次Oracle数据库连接失败的问题排查过程。错误为ORA-12514，原因是服务名在监听器中未知。通过检查服务名和服务状态，发现与db_domain参数有关，最终通过修改并重启监听器解决问题。

ora10glin->sqlplus system/orcl@demo

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 11 15:54:19 2009

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Enter user-name:

查询了网络得知：

ora10glin->lsnrctl services demo

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-NOV-2009 15:58:34

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora10glin)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=demo)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "demo.us.com" has 1 instance(s).
Instance "demo", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "demoXDB.us.com" has 1 instance(s).
Instance "demo", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: ora10glin, pid: 4993>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ora10glin)(PORT=33457))
Service "demo_XPT.us.com" has 1 instance(s).
Instance "demo", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
The command completed successfully
ora10glin->