ORA-28547 如何解决？
刚安装了ORACLE 11g。。

listener.ora 配置如下
# listener.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
#CLRExtProc

#DIRECT_HANDOFF_TTC_LISTENER = OFF

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

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

ADR_BASE_LISTENER = D:\oracle


tnsnames.ora 配置如下
# tnsnames.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(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 = localhost)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
  )
  )



sqlnet.ora 配置如下
# sqlnet.ora Network Configuration File: D:\oracle\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)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


刚开始是可以的用的 什么也没动 突然之间。

到实例的代理连接 ORA-28547: connection to server failed, probable Oracle Net admin error (DBD ERROR: OCISessionBegin)

请高手指点。

------解决方案--------------------
-- *1). 绑定你的IP地址，别让其动态获取!

-- *2). 修改oracle的网络配置文件，具体做法是：在oracle安装目录下搜索sqlnet.ora文件，一般在$\NETWORK\ADMIN目录下， 
用记事本打开把文件中的一行： 
SQLNET_AUTHENTICATION_SERVICES= (NTS) 
修改为： 
SQLNET_AUTHENTICATION_SERVICES= (NONE) 

--*3).同时修改监听器配置文件，具体做法是： 在oracle安装目录下搜索listener.ora文件，一般在$\NETWORK\ADMIN目录下，把主机名用ip地址代替，例如(ADDRESS = (PROTOCOL = TCP)(HOST = HBONLINE1)(PORT = 1523))改为(ADDRESS = (PROTOCOL = TCP)(HOST = 168.168.168.42)(PORT = 1523))。
------解决方案--------------------
1楼正解
用Google可以搜到好多回答的
------解决方案--------------------
重新配置一下listener，如果你想知道原因，我帮顶~~
------解决方案--------------------
重新建立监听！
------解决方案--------------------
把杀毒软件暂时关闭，重装一遍数据库，再进行监听文件配置，试试！