oracle 无监听程序

通过plsql远程连接另一台机器的数据库,出现监听错误,修改了被连接机器oracle的LISTENER主机为计算机名后问题解决。

1,

E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = PC-20120913KQNQ)(PORT = 1521))
    )
  )

2,开始->Net Manager->本地->监听程序->LISTENER

 

tnsnames.ora文件配置：

SUNYUAN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xx.xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )