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

 ora10glin->sqlplus system/orcl@demo

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

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

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

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

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->

 

想起来曾经在这个测试库上面改过db_domain这个参数

 

db_domain这个参数改回来之后恢复正常了：

ora10glin->lsnrctl reload

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-NOV-2009 15:59:33

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
ora10glin->sqlplus system/orcl@demo

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 11 15:59:49 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>