3、数据库无监听程序解决方法

先查看服务是否开启 services.msc

找到该目录地址：app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN

1、用记事本打开文件tnsnames.ora
新增如下内容

ORCLTEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCLTEST)
    )
  )

其中(ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))
修改HOST的参数
#有网HOST=127.0.0.1
#无网HOST=计算机名

#有网用计算机名可能也行，未验证

2.记事本打开文件listener.ora
新增如下内容

LISTENERTEST =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PC-20160205BPRE)(PORT = 12580))
    )
  )