Skip to main content

Home/ eDBA Services - Oracle & MySQL/ Group items tagged documentation

Rss Feed Group items tagged

Dariusz Owczarek

Oracle 11g Database Online Documentation - 0 views

  • Reference HTML
  • Concepts HTML
  • SQL Language Reference HTML
Dariusz Owczarek

eDBA Searche - Search Oracle and MySQL Documentation - 0 views

  •  
    Search online Oracle and MySQL using Google engine
Dariusz Owczarek

eDBA Search - Oracle and MySQL Documentation search - 0 views

  •  
    Search online Oracle and MySQL using Google engine
Dariusz Owczarek

Understanding and Troubleshooting Instance Load Balancing - 0 views

  •  
    This document is intended for use by DBA's and support analysts attempting to understand and troubleshoot Load Balancing issues.
Dariusz Owczarek

How To Configure Dispatchers For RAC Environment - 0 views

  • Doc ID: 578524.1
  • Note: It is very important to use entire address string in order to configure dispatchers on RAC and host name used in it should be a VIP hostname, otherwise connection may suffer intermittent ORA-12545 errors. Refer metalink note <333159.1>
  • alter system set dispatchers='(address=(protocol=tcp)(host=node1-vip))(dispatchers=2)' scope=both   sid='racdb1';
  • ...3 more annotations...
  • If you have a firewall present between client and the server, then it may block connections on the randomly selected dispatchers ports. If this is the case for your setup then set the dispatcher with PORT clause as below and configure the firewall to allow the communication on these ports along with the listener port.
  • alter system set dispatchers='(address=(protocol=tcp)(host=<vip address>)(port=<port_number>))' scope=both sid='racdb1';
  • Note - If the port clause is not used in the dispatchers configuration then port numbers will be chosen randomly which could be blocked in the firewall resulting redirected connection to dispatchers getting time out errors. For more details refer note <125021.1>:Oracle Connections and Firewalls
  •  
    This document would guide you to configure dispatchers for Real Application Cluster (RAC) database.
1 - 5 of 5
Showing 20 items per page