Chuyển đến nội dung chính

Bài đăng

Đang hiển thị bài đăng từ Tháng 7, 2018

configure hibernate using oracle rac

The ordinary way to configure hibernate link oracle database is just like this: jdbc:oracle:thin:@192.100.99.103:1521:Orcl But some times the database server using double network-cards or using rac. Then the configure will be: jdbc:oracle:thin:@ (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.100.99.103)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.100.99.104)(PORT = 1521)) (LOAD_BALANCE = yes) ) (CONNECT_DATA = (SERVICE_NAME = Orcl) ) ) The segment of connection url is copied from oracle configuration file(usually under Oracle_Home\app\product\11.2.0\dbhome_1\NETWORK\ADMIN\ tnsnames.ora ). //////////////// example ///////////////////

Oracle RAC

1. Hướng dẫn cài đặt trên Virtual box: http://www.lab128.com/rac12_installation_using_vb/article_text.html Red Enterprise Linux 7 : https://access.redhat.com/sites/default/files/attachments/deploying_oracle_rac_12c_rhel7_v1.1_0.pdf 2. Oracle license http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf