ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle10g RAC, 客户端登陆,偶尔报 ORA-12535, 急!

Oracle10g RAC, 客户端登陆,偶尔报 ORA-12535, 急!

原创 Linux操作系统 作者:tolywang 时间:2007-12-14 18:23:55 0 删除 编辑
Linux AS4.0  64bit
Oracle10g  10.2.0.1  RAC   OCFS2
数据库名称tpc
每个节点有两个public nic , 一个private nic .   



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



1.    参数文件中Listener相关的参数 (两个节点)  

SQL> show parameter  listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LOCAL_TPC
remote_listener                   string      LISTENERS_TPC


其中 LOCAL_TPC 会在后面的每个节点 tnsnames.ora 中设置。



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

2.    hosts   :  


gnd-rac01$cat   hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.

127.0.0.1               localhost.localdomain    localhost
10.155.4.95     gnd-rac01        #  public nic1   
172.20.1.19     gnd-rac01        #  public nic2   --- VIP统一网段   
10.1.0.1           gnd-pri01         #  private nic  
172.20.1.29     gnd-vip01        #  VIP  

10.155.4.96     gnd-rac02
172.20.1.18     gnd-rac02
10.1.0.2           gnd-pri02
172.20.1.28     gnd-vip02


不过在安装CRS的时候 public nic  10.155.4.95 (96) 被设置为Do Not Use .  VIP使用的是 172.20 段的.
而且vipca的时候选择的也是 172.20 的这块public nic .   


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


3.   节点1的tnsnames.ora 及listener.ora 设置 。

TPC2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tpc)
      (INSTANCE_NAME = tpc2)
    )
  )
TPC1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tpc)
      (INSTANCE_NAME = tpc1)
    )
  )
TPC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tpc)
    )
  )
LISTENERS_TPC =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
  )



#   LOCAL_TPC 对应spfile中的local_listener .  自己加入的。 [节点1]

LOCAL_TPC =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.19)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
  )



节点1 监听:


LISTENER_GND-RAC01 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )







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


4.   节点 2 的tnsnames.ora 及listener.ora 设置 。


TPC2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tpc)
      (INSTANCE_NAME = tpc2)
    )
  )
TPC1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tpc)
      (INSTANCE_NAME = tpc1)
    )
  )
TPC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tpc)
    )
  )
LISTENERS_TPC =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
  )


#   LOCAL_TPC 对应spfile中的local_listener .  自己加入的。  [节点2]

LOCAL_TPC =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.18)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
  )



节点2 监听:

LISTENER_GND-RAC02 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

[ 本帖最后由 tolywang 于 2007-12-14 18:31 编辑 ]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-127532/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13238614