Oracle RAC 高手也没遇到过的普通问题

comerliang · 发表于 2013-7-18 16:21

你这标题........

VIP干啥的,好像你还没太明白

wfsitpub · 发表于 2013-7-18 16:24

knowwinter 发表于 2013-7-18 15:45
连不上报什么错？
tnsping scccspt通不通？

tnsping 可以ping通

wfsitpub · 发表于 2013-7-18 19:50

comerliang 发表于 2013-7-18 16:20
把地址改成VIP地址

把4个IP都写入你客户端的hosts文件里

客户端可以连接，但是部署应用时不能创建jdbc URL
URL和tnsname.ora中的一致

vc_wjx · 发表于 2013-7-19 15:28

贴出listener.ora的配置看看

wfsitpub · 发表于 2013-7-19 15:57

vc_wjx 发表于 2013-7-19 15:28
贴出listener.ora的配置看看

# listener.ora.sohdb2 Network Configuration File: /home/oracle/product/10.2.0/db/network/admin/listener.ora.sohdb2
# Generated by Oracle configuration tools.

LISTENER_SOHDB2 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sohdb2-vip)(PORT = 1521)(IP = FIRST))
   )
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 155.16.111.7)(PORT = 1521)(IP = FIRST))
   )
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
   )
)
  )

---------------------------------------------------------------------------

# listener.ora.sohdb1 Network Configuration File: /home/oracle/product/10.2.0/db/network/admin/listener.ora.sohdb1
# Generated by Oracle configuration tools.

LISTENER_SOHDB1 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sohdb1-vip)(PORT = 1521)(IP = FIRST))
   )
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 155.16.111.6)(PORT = 1521)(IP = FIRST))
   )
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
   )
)
  )