ORA-12514: TNS:listener does not currently know ...

olivehb

我的oracle 装在linux 上, 客户端装在windows XP 下, 我还在XP上装了toad, 可是toad能连上oracle, XP上的sqlplus却连不上, 报错:

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

有可能是什么原因?

olivehb

oracle10g

remen

贴你的详细步骤 出错信息 以及tnsnames.ora

olivehb

我在XP上装了客户端, 执行sqlplusw.exe, log on界面要求输入用户,密码和host string, 我完成输入后就报上面的错,可是我在XP上装的toad却能连上数据库.

tnsnames.ora:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLE_TESTER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = tester)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = oracle)
      (SERVER = DEDICATED)
    )
  )

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

olivehb

客户端(XP):

C:\Documents and Settings\oracle>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 7 14:59:10 2006

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

SQL> conn sys/sys@tester as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


SQL>

remen

分别执行
c:\tnsping ORACLE_TESTER
c:\ping tester
然后给结果

remen

SQL> conn sys/sys@tester as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

should be conn sys/sys@ORACLE_TESTER as sysdba

olivehb

tnsping tester 和 ping tester 都ok; tester 是我的oracle server的机器

mtx99

你的数据库监听没有起来，用lsnrctl start起来监听就可以了.