ora-28547 错误 用oracle developer 连接 一直报错 试过网上的很多方法 都不行、、高手来
系统win7 64位 

用Oracle InstantClien 工具instantclient-basiclite-win32
正确配置好了 
 


本人试过：
1.
SQLNET_AUTHENTICATION_SERVICES= (NTS)  
修改为：  
SQLNET_AUTHENTICATION_SERVICES= (NONE)

重启2个服务（oracleserver 和 listner 开启顺序是 先listner 后 oracle server 下面都是 ） 
还是 同一个错。。。没解决！！
2.
# (PROGRAM = extproc) 注释这个 并且 host=后面的改成 ip 
同样 按顺序重启2个服务 还是 没解决 同样28547！






我的 tnsnames：

# tnsnames.ora Network Configuration File: D:\software\oracle\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))


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

ORCL =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
  )
  )






我的 listner:
# listener.ora Network Configuration File: D:\software\oracle\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = CLRExtProc)
  (ORACLE_HOME = D:\software\oracle\app\Administrator\product\11.2.0\dbhome_1)
  #(PROGRAM = extproc)
  (ENVS = "EXTPROC_DLLS=ONLY:D:\software\oracle\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
  )
  )
 

LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
  )
  )

ADR_BASE_LISTENER = D:\software\oracle\app\Administrator


我的 sqlnet

# sqlnet.ora Network Configuration File: D:\software\oracle\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# 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)
#SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)







------解决方案--------------------
1、确认服务器本身能连接不，即不用服务名的
2、删除掉服务器端的监听，用netca重新建立一个
3、SQLNET.AUTHENTICATION_SERVICES= (NONE)还是需要的