嗨,当我尝试将我的PLSQL Developer连接到Oracle 11g R2 Express Edition时,我遇到了麻烦 .

我在c:\ Oraclex86中创建了一个新文件夹,在该文件夹中我安装了oracle 11g R2 Client for x86

我在c:\ ProgramFiles中安装了PLSQL Developer,因为我在其他出版物中读到了c:\ ProgramFiles(x86)生成连接问题 .

因此,当我尝试将PLSQL Developer连接到数据库时,会出现ORA-12154消息

作为附加信息,我检查过这些东西:

Oracle服务已在运行

PLSQL开发人员首选项:PLSQL Developer Preferences

ORACLE 11g R2登录11g R2 Login

我有Windows 10 x64版

Tnsnames配置:

XE =   (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = Adriano_PC)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = XE)
       )   )

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

   ORACLR_CONNECTION_DATA =    (DESCRIPTION = 
       (ADDRESS_LIST = 
         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
       ) 
       (CONNECT_DATA = 
         (SID = CLRExtProc) 
         (PRESENTATION = RO) 
       )    )

监听器:

SID_LIST_LISTENER =   (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )   )

LISTENER =   (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = Adriano_PC)(PORT = 1521))
    )   )

DEFAULT_SERVICE_LISTENER = (XE)

SQLNET:

This file is actually generated by netca. But if customers choose to 
install "Software Only", this file wont exist and without the native 
authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

那是谁都知道我做错了什么?我会感激你的帮助