ORA-12514, TNS:listener does not currently know of service requested in connect descriptor案例2 - 数据库编程

TOP

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor案例2(二)

2017-10-13 10:47:07 【大中小】浏览:4283次

Tags：ORA-12514 TNS:listener does not currently know service requested connect descriptor 案例

IPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB-Server.localdomain)(PORT=1521)))

The listener supports no services

The command completed successfully

Step 4：检查$ORACLE_BASE/diag/tnslsnr/DB-Server/listener/alert下的日志，发现host_addr为10.20.34.76，实际IP地址不是这个。因为监听文件里面我使用的hostname DB-Server.localdomain，所以赶紧检查/etc/hosts的配置

   [root@DB-Server ~]# ifconfig
   
   eth0      Link encap:Ethernet  HWaddr B0:83:FE:55:32:E5  
   
             inet addr:10.20.57.15  Bcast:10.20.57.255  Mask:255.255.255.0
   
             UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
   
             RX packets:2363981 errors:0 dropped:0 overruns:0 frame:0
   
             TX packets:180048 errors:0 dropped:0 overruns:0 carrier:0
   
             collisions:0 txqueuelen:1000 
   
             RX bytes:225925147 (215.4 MiB)  TX bytes:14349633 (13.6 MiB)
   
             Interrupt:233 Base address:0x4000 
   
   lo        Link encap:Local Loopback  
   
             inet addr:127.0.0.1  Mask:255.0.0.0
   
             UP LOOPBACK RUNNING  MTU:16436  Metric:1
   
             RX packets:3692 errors:0 dropped:0 overruns:0 frame:0
   
             TX packets:3692 errors:0 dropped:0 overruns:0 carrier:0
   
             collisions:0 txqueuelen:0 
   
             RX bytes:2982961 (2.8 MiB)  TX bytes:2982961 (2.8 MiB)
   
   [root@DB-Server ~]# more /etc/hosts
   
   # Do not remove the following line, or various programs
   
   # that require network functionality will fail.
   
   10.20.34.76        DB-Server.localdomain DB-Server
   
   127.0.0.1               localhost.localdomain localhost
   
   ::1             localhost6.localdomain6 localhost6
   
   [root@DB-Server ~]#

果然发现/etc/hosts下配置为10.20.34.76，具体原因是因为IT部门调换办公室，从三楼撤到二楼，将这台PC搬下来后，服务器IP地址变化了，修改/etc/hosts，然后重启监听服务，问题解决。

首页上一页 1 2 下一页尾页 2/2/2
【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】

上一篇：mySQL 的 2个分类	下一篇：mysql备份和还原数据库及慢查询日..