Каталог статей
Меню сайта


Форма входа


Категории раздела
Oracle DB administering [46]
Oracle DB programming [15]
Oracle DB troubleshooting [11]


Поиск


Друзья сайта
  • Официальный блог
  • Сообщество uCoz
  • FAQ по системе
  • Инструкции для uCoz


  • Статистика

    Онлайн всего: 1
    Гостей: 1
    Пользователей: 0


    Приветствую Вас, Гость · RSS 20.05.2024, 05:56
    Главная » Статьи » Oracle DB » Oracle DB administering

    Configuring client connections for RAC

    The topic is described in Doc ID 453293.1

    http://www.programering.com/a/MjNxgTNwATU.html

    tnsnames.ora record examples:

    Client Side Load Balancing

    Following is an example of TNS net service alias for client side load balancing
    CLIENT_LOADBALANCE=
     (DESCRIPTION =
      (LOAD_BALANCE = yes)
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.idc.oracle.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.idc.oracle.com)(PORT = 1521))  
      (CONNECT_DATA =  
       (SERVICE_NAME = service.idc.oracle.com)  
      )
     )


    Connect Time Failover

    Sample connect time failover TNS net service alias address_list defaults the failover=on


    CLIENT_FAILOVER=
    (DESCRIPTION =  
     (ADDRESS_LIST =  
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.idc.oracle.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.idc.oracle.com)(PORT = 1521))  
     )
     (CONNECT_DATA =
       (SERVICE_NAME = service.idc.oracle.com)
     )
    )


    Client Side Load Balance & Connect-time Failover Connect String


    CLIENT_LOAD_FAILOVER=
    (DESCRIPTION =
     (ADDRESS_LIST =
      (LOAD_BALANCE = yes)
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.idc.oracle.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.idc.oracle.com)(PORT = 1521))
     )
     (CONNECT_DATA =
      (SERVICE_NAME = service.idc.oracle.com)
     )
    )

    TAF - Client Side Configuration

    Failover Mode Type can be Either SESSION or SELECT. Session failover will have just the session to failed over to the next available node.The select query will not be resumed.
    Simple TAF can be configured on the client side tnsnames.ora with following entry:

    TAF=
    (DESCRIPTION = 
     (ADDRESS_LIST =
      (LOAD_BALANCE = yes) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.idc.oracle.com)(PORT = 1521)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.idc.oracle.com)(PORT = 1521)) 
     )
     (CONNECT_DATA = 
       (SERVICE_NAME = service.idc.oracle.com) 
       (failover_mode=(type=select)(method=basic)) 
        ) 
      ) 
     

    TAF - Server Side Configuration

    From Oracle 10.2 onwards, TAF can be configured with server side at the time of service creation also.
    Refer Note 460982.1 How To Configure Server Side Transparent Application

    Категория: Oracle DB administering | Добавил: basil (07.09.2015)
    Просмотров: 371 | Рейтинг: 0.0/0
    Всего комментариев: 0
    Имя *:
    Email *:
    Код *:
    Бесплатный конструктор сайтов - uCoz