database - 错误代码 ORA-12154 解析 Oracle 数据库的问题

Question

我无法解决此错误：

C:\Windows\system32>sqlplus dunya/tiger@ORADATA

SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 2 13:46:10 2018
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

在数据库中：

SQL> select database_name from v$database;

DATABASE_NAME
----------------------------------------------------
ORADATA

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
oradata

tnsnames.ora：

ORADATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL=TCP)(HOST=himanshu-PC)(PORT=1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oradata)
      (SERVER = DEDICATED)
    )
  )

监听器.ora：

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = himanshu-PC)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORADATA)
      (ORACLE_HOME = G:\app\himanshu\product\11.2.0\dbhome_1)
      (SID_NAME = oradata)
    )
  )

sqlnet.ora：

SQLNET.AUTHENTICATION_SERVICES = (NTS)

标签： databaseoracle